Google Sheets

Auth type: OAuth

For fundamentals on connecting and managing integrations, see: App Integrations.

Connect Google Sheets

Go to Settings → Apps in Hyper
Select Google Sheets → Connect New
Complete OAuth and grant requested scopes

Common capabilities

Read and write spreadsheets
Append rows and generate reports
Transform data between systems

Use in Chat

Enable Sheets in the tool selector to analyze, summarize, and update sheets via prompts.

Use in Agents

Add Sheets to an agent’s toolkits and select the connection. Require approval for write operations.

Use in Flows

Build reporting and ETL‑style steps using Sheets action nodes.

Troubleshooting

Permission errors: share the sheet with the connected account
Range issues: verify sheet name and A1 notation

Available Actions

Hyper agents can run the following actions for this integration. Each action can be individually set to Enabled, Requires Approval, or Disabled in your agent’s toolkit settings. Actions can be set to one of three control states:

State	Behavior
Enabled	Agent runs the action automatically
Requires Approval	Agent pauses and waits for your confirmation before proceeding
Disabled	Action is blocked and cannot be used

Configure these in the agent’s toolkit settings or in workspace defaults.

Action	Description
Add Chart	Add a chart to a Google Spreadsheet
Add Sheet	Add a new sheet to a Google Spreadsheet
Batch Get Values	Get values from multiple ranges in a Google Spreadsheet. Use this to inspect headers, helper columns, and destination ranges before any write operation
Batch Update Values	Update values in multiple ranges in a Google Spreadsheet. Only use this after reading the sheet structure and verifying each target range against the real headers and layout
Clear Values	Clear values in a range in a Google Spreadsheet. Double-check the target range against the real sheet layout before clearing anything
Create Pivot Table	Create a pivot table in a Google Spreadsheet
Create Spreadsheet	Create a new Google Spreadsheet
Delete Chart	Delete a chart from a Google Spreadsheet
Delete Pivot Table	Delete a pivot table from a Google Spreadsheet
Delete Sheet	Delete a sheet from a Google Spreadsheet
Get Spreadsheet	Get information about a specific Google Spreadsheet
Get Values	Get values from a range in a Google Spreadsheet. Use this to inspect header rows and surrounding columns before writing so you map by actual header names instead of assumed column letters
List Spreadsheets	List Google Spreadsheets
List Worksheets	List worksheets in a Google Spreadsheet
Update Chart	Update a chart in a Google Spreadsheet
Update Sheet Properties	Update properties of a sheet in a Google Spreadsheet
Update Spreadsheet Properties	Update properties of a Google Spreadsheet
Update Values	Update VALUES in a range in a Google Spreadsheet. Do not use this to update propertis like title, hidden, etc. Never guess column letters from memory. Read the sheet first, identify the real header row, ignore helper columns like totals or notes, map fields by header name, and only then write the verified target range

Overview

Communication & Collaboration

Productivity & Files

Calendars & Scheduling

Sales & CRM

Marketing & Ads

Social Media

Content & Website

Developer & DevOps

Databases & Storage

Analytics & Research

Finance & E-commerce

AI & Media

Additional

Google Sheets

Connect Google Sheets

Common capabilities

Use in Chat

Use in Agents

Use in Flows

Troubleshooting

Available Actions

​Connect Google Sheets

​Common capabilities

​Use in Chat

​Use in Agents

​Use in Flows

​Troubleshooting

​Available Actions

Connect Google Sheets

Common capabilities

Use in Chat

Use in Agents

Use in Flows

Troubleshooting

Available Actions