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
1
Open Settings → Integrations
In any workspace go to Settings → Integrations and select Google Sheets.
2
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.
3
Start using Google Sheets in agents
Open the agent and enable only the Google Sheets actions it needs. Access is limited by the connected Google
account.
Agent tools
Add Google Sheets tools to agents that need them. Their access is limited by the connected Google account and selected tools.Spreadsheets
Values
Rows and columns
Data and formatting
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.
Back to Integrations
View all available integrations