What you unlock
Spreadsheet data access
Read, write, and update cell values across any spreadsheet — your agent can pull data or push changes on demand.
Sheet management
Create new spreadsheets and sheets, add or remove rows and columns, and manage sheet properties.
SQL queries and formulas
Run SQL queries against your spreadsheet data and aggregate column values without writing formulas by hand.
15+ agent tools
Give your AI agent full read/write access to spreadsheets, values, formatting, charts, and data validation.
Connect Google Sheets
Open Settings → Integrations
In any workspace go to Settings → Integrations and select Google Sheets.
Authorize with Google
Click Connect — you’ll be redirected to Google’s OAuth consent screen. Sign in with your Google account and
grant spreadsheet access.
Agent tools
Any agent in your workspace can use Google Sheets tools the moment the OAuth connection is active.Spreadsheets
| Tool | Description |
|---|---|
| Create spreadsheet | Create a new Google Sheets spreadsheet |
| Search spreadsheets | Find spreadsheets by name or keyword |
| Get spreadsheet info | Retrieve metadata and sheet names for a spreadsheet |
Values
| Tool | Description |
|---|---|
| Get values | Read cell values from a specified range |
| Update values | Write values to a specified range |
| Append values | Append rows of data to the end of a sheet |
| Batch get | Read values from multiple ranges in a single request |
| Batch update | Write values to multiple ranges in a single request |
| Clear values | Clear cell contents in a specified range |
Rows and columns
| Tool | Description |
|---|---|
| Lookup row | Find a row by matching a column value |
| Create row | Insert a new row with specified values |
| Insert dimension | Add new rows or columns at a specified position |
| Delete dimension | Remove rows or columns from a sheet |
Data and formatting
| Tool | Description |
|---|---|
| Execute SQL | Run a SQL query against spreadsheet data |
| Find and replace | Search for and replace text across cells |
| Format cell | Apply formatting (bold, color, borders) to cells |
| Create chart | Generate a chart from spreadsheet data |
Triggers
Triggers are not yet available for Google Sheets. Tools are fully supported — connect and start using them in any
agent.
Example use cases
Pull a weekly metrics report
Pull a weekly metrics report
Ask your agent to read the latest row from your KPI spreadsheet, summarize the numbers, and post a formatted digest
to your team channel — every Monday morning.
Log data from chat into a spreadsheet
Log data from chat into a spreadsheet
When someone shares feedback or a data point in chat, tell your agent to append it as a new row in a tracking
spreadsheet — complete with timestamp and source.
Query spreadsheet data with SQL
Query spreadsheet data with SQL
Ask your agent to run a SQL query against your spreadsheet to find all records matching specific criteria, then
summarize the results in chat without opening the sheet.
Troubleshooting
OAuth consent screen doesn't appear
OAuth consent screen doesn't appear
Make sure pop-ups are not blocked in your browser. If the Google sign-in page doesn’t open, try again with pop-ups
allowed or use a different browser.
Agent can't find my spreadsheet
Agent can't find my spreadsheet
Search uses the name of the spreadsheet. Make sure the file is accessible to the authenticated Google account —
check sharing settings in Google Drive if needed.
Write operations fail with a permission error
Write operations fail with a permission error
Confirm that the authenticated account has edit access to the spreadsheet. View-only access allows reads but blocks
writes.
Authorization expired
Authorization expired
Back to Integrations
View all available integrations