Can I limit what agents can do in Google Sheets?

Yes, twice over. The connection itself has an access level (Read-only, Read + create, Full access), and on top of that you can allow, scope, or deny each individual agent from the Integrations page.

Can I connect more than one Google Sheets account?

Yes. Connect additional accounts from the same card and mark one as primary; agents use the primary unless a mission names a specific account.

How do I disconnect Google Sheets?

Open Integrations, choose the account under Google Sheets, and revoke it. Agents lose access immediately; nothing keeps working in the background.

Email & Productivity

📈 Google Sheets integration

Access levels: Read-only · Read + create · Full access · Verified July 15, 2026

Connect Google Sheets once and every agent in your squad can work in it for you, with exactly as much access as you decide to give, and a receipt for every call it makes.

What your squad can do in Google Sheets

Look things up, batch get; get batch values; get conditional format rules, and more.
Do real work, add sheet; batch update; batch update values by data filter; create chart, and more.
Run it on a schedule: any of the 52 available tools below can be part of a scheduled task or a mission.

How to connect

In your dashboard, open Integrations and find Google Sheets.
Click Connect and pick an access level (we recommend Full access): this is the ceiling for every agent.
Sign in to Google Sheets in the window that opens and approve. You land back on the Integrations page with the account live.

You can change an account's access level any time under Manage. It applies instantly, no re-authorization. If the connection ever expires, the card shows Reconnect; one click re-authorizes the same account with the same settings.

Multiple accounts: connect as many as you need (say, yours and a client's). One is primary. Agents use it unless a mission says otherwise.

Access levels

The level you pick at connect time is enforced on our side for every agent call: an agent can never do more than the level allows, no matter what it's asked.

Level	What it allows
Read-only	Read your spreadsheets. Cannot edit or create.
Read + create	Read existing sheets and create new ones.
Full access	Read, edit, create, and delete any Google Sheet.	Recommended

On top of the connection's level, every agent can be individually allowed, scoped down, or denied for this app from the Integrations page. Deny an agent and it doesn't even see the connection.

Every tool, in plain terms

The 52 tools agents use in Google Sheets through Mission Control, and the lowest access level that includes each. Agents discover these themselves. You never have to name a tool; asking in plain language is enough.

Tool	What it does	Access level
Add sheet `GOOGLESHEETS_ADD_SHEET`	Adds a new sheet to a spreadsheet. Supports three sheet types: GRID, OBJECT, and DATA_SOURCE. SHEET TYPES: - GRID (default): Standard spreadsheet with rows/columns. Use properties to set dimensions, tab color, etc. - OB…	Read + create, Full access
Aggregate column data `GOOGLESHEETS_AGGREGATE_COLUMN_DATA`	Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.	All levels
Append dimension `GOOGLESHEETS_APPEND_DIMENSION`	Append new rows or columns to a sheet, increasing its size.	Read + create, Full access
Auto resize dimensions `GOOGLESHEETS_AUTO_RESIZE_DIMENSIONS`	Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions.	Read + create, Full access
Batch clear values by data filter `GOOGLESHEETS_BATCH_CLEAR_VALUES_BY_DATA_FILTER`	Clears one or more ranges of values from a spreadsheet using data filters.	Full access
Batch get `GOOGLESHEETS_BATCH_GET`	Retrieves data from specified cell ranges in a Google Spreadsheet.	All levels
Batch update `GOOGLESHEETS_BATCH_UPDATE`	DEPRECATED: Use GOOGLESHEETS_VALUES_UPDATE instead.	Full access
Batch update values by data filter `GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER`	Update values in ranges matching data filters.	Read + create, Full access
Clear basic filter `GOOGLESHEETS_CLEAR_BASIC_FILTER`	Clear the basic filter from a sheet. Use when you need to remove an existing basic filter from a specific sheet within a Google Spreadsheet.	Read + create, Full access
Clear values `GOOGLESHEETS_CLEAR_VALUES`	Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the range must correspond to an existing sheet and cells.	Full access
Create chart `GOOGLESHEETS_CREATE_CHART`	Create a chart in a Google Sheets spreadsheet using the specified data range and chart type.	Read + create, Full access
Create google sheet1 `GOOGLESHEETS_CREATE_GOOGLE_SHEET1`	Creates a new Google Spreadsheet in Google Drive.	Read + create, Full access
Create spreadsheet column `GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN`	Creates a new column in a Google Spreadsheet.	Read + create, Full access
Create spreadsheet row `GOOGLESHEETS_CREATE_SPREADSHEET_ROW`	Inserts a new, empty row into a specified sheet of a Google Spreadsheet at a given index, optionally inheriting formatting from the row above.	Read + create, Full access
Delete chart `GOOGLESHEETS_DELETE_CHART`	Delete an existing chart from a Google Sheets spreadsheet.	Full access
Delete dimension `GOOGLESHEETS_DELETE_DIMENSION`	Delete specified rows or columns from a sheet in a Google Spreadsheet.	Full access
Delete sheet `GOOGLESHEETS_DELETE_SHEET`	Delete a sheet (worksheet) from a spreadsheet.	Full access
Execute sql `GOOGLESHEETS_EXECUTE_SQL`	DEPRECATED: Use direct Google Sheets actions instead: - GOOGLESHEETS_VALUES_GET / GOOGLESHEETS_BATCH_GET for reads - GOOGLESHEETS_VALUES_UPDATE / GOOGLESHEETS_UPDATE_VALUES_BATCH / GOOGLESHEETS_SPREADSHEETS_VALUES_APPEN…	Full access
Find replace `GOOGLESHEETS_FIND_REPLACE`	Find and replace text in a Google Spreadsheet.	Read + create, Full access
Find worksheet by title `GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE`	DEPRECATED: Use GetSpreadsheetInfo instead.	All levels
Format cell `GOOGLESHEETS_FORMAT_CELL`	Applies text and background cell formatting to a specified range in a Google Sheets worksheet.	Read + create, Full access
Get batch values `GOOGLESHEETS_GET_BATCH_VALUES`	DEPRECATED: Use GOOGLESHEETS_BATCH_GET instead.	All levels
Get conditional format rules `GOOGLESHEETS_GET_CONDITIONAL_FORMAT_RULES`	List conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.	All levels
Get data validation rules `GOOGLESHEETS_GET_DATA_VALIDATION_RULES`	Extract data validation rules from a Google Sheets spreadsheet.	All levels
Get sheet names `GOOGLESHEETS_GET_SHEET_NAMES`	Lists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.	All levels
Get spreadsheet by data filter `GOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER`	Returns the spreadsheet at the given ID, filtered by the specified data filters.	All levels
Get spreadsheet info `GOOGLESHEETS_GET_SPREADSHEET_INFO`	Retrieves metadata for a Google Spreadsheet using its ID.	All levels
Get table schema `GOOGLESHEETS_GET_TABLE_SCHEMA`	DEPRECATED: Use GOOGLESHEETS_GET_SHEET_NAMES and GOOGLESHEETS_GET_SPREADSHEET_INFO for sheet structure metadata, and GOOGLESHEETS_VALUES_GET for direct range inspection.	All levels
Insert dimension `GOOGLESHEETS_INSERT_DIMENSION`	Insert new rows or columns into a sheet at a specified location.	Read + create, Full access
List charts `GOOGLESHEETS_LIST_CHARTS`	Lists all charts in a Google Sheets spreadsheet across all sheets, returning chart_id, sheet metadata, chart type, title, and position.	All levels
List tables `GOOGLESHEETS_LIST_TABLES`	DEPRECATED: Use GOOGLESHEETS_GET_SHEET_NAMES for tab discovery and GOOGLESHEETS_GET_SPREADSHEET_INFO for full sheet metadata.	All levels
Lookup spreadsheet row `GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW`	Finds the first row in a Google Spreadsheet where a cell's entire content exactly matches the query string, searching within a specified A1 notation range or the first sheet by default.	All levels
Move chart `GOOGLESHEETS_MOVE_CHART`	Move or resize an existing chart on a Google Sheets spreadsheet.	Read + create, Full access
Mutate conditional format rules `GOOGLESHEETS_MUTATE_CONDITIONAL_FORMAT_RULES`	Add, update, delete, or reorder conditional format rules on a Google Sheet.	Full access
Query table `GOOGLESHEETS_QUERY_TABLE`	DEPRECATED: Use GOOGLESHEETS_VALUES_GET / GOOGLESHEETS_BATCH_GET for table reads and GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW for row lookup/filter workflows.	All levels
Search developer metadata `GOOGLESHEETS_SEARCH_DEVELOPER_METADATA`	Search for developer metadata in a spreadsheet.	All levels
Search spreadsheets `GOOGLESHEETS_SEARCH_SPREADSHEETS`	Search for Google Spreadsheets using various filters including name, content, date ranges, and more.	All levels
Set basic filter `GOOGLESHEETS_SET_BASIC_FILTER`	Set a basic filter on a sheet in a Google Spreadsheet.	Read + create, Full access
Set data validation rule `GOOGLESHEETS_SET_DATA_VALIDATION_RULE`	Set or clear data validation rules (including dropdowns) on a range in Google Sheets.	Read + create, Full access
Sheet from json `GOOGLESHEETS_SHEET_FROM_JSON`	DEPRECATED: Use GOOGLESHEETS_CREATE_GOOGLE_SHEET1 + GOOGLESHEETS_UPDATE_VALUES_BATCH (or GOOGLESHEETS_VALUES_UPDATE / GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND) instead.	Read + create, Full access
Spreadsheets sheets copy to `GOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TO`	Copy a single sheet from a spreadsheet to another spreadsheet.	Read + create, Full access
Spreadsheets values append `GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND`	Append values to a spreadsheet. Use when you need to add new data to the end of an existing table in a Google Sheet.	Read + create, Full access
Spreadsheets values batch clear `GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR`	Clear one or more ranges of values from a spreadsheet.	Full access
Spreadsheets values batch get by data filter `GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTER`	Return one or more ranges of values from a spreadsheet that match the specified data filters.	All levels
Update chart `GOOGLESHEETS_UPDATE_CHART`	Update the specification of an existing chart in a Google Sheets spreadsheet.	Read + create, Full access
Update dimension properties `GOOGLESHEETS_UPDATE_DIMENSION_PROPERTIES`	Hide/unhide rows or columns and set row heights or column widths.	Read + create, Full access
Update sheet properties `GOOGLESHEETS_UPDATE_SHEET_PROPERTIES`	Update properties of a sheet (worksheet) within a Google Spreadsheet, such as its title, index, visibility, tab color, or grid properties.	Read + create, Full access
Update spreadsheet properties `GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES`	Update SPREADSHEET-LEVEL properties such as the spreadsheet's title, locale, time zone, or auto-recalculation settings.	Read + create, Full access
Update values batch `GOOGLESHEETS_UPDATE_VALUES_BATCH`	Set values in one or more ranges of a spreadsheet.	Read + create, Full access
Upsert rows `GOOGLESHEETS_UPSERT_ROWS`	Upsert rows - update existing rows by key, append new ones.	Read + create, Full access
Values get `GOOGLESHEETS_VALUES_GET`	Returns a range of values from a spreadsheet.	All levels
Values update `GOOGLESHEETS_VALUES_UPDATE`	Set values in a range of a Google Spreadsheet.	Read + create, Full access

What agents can't do in Google Sheets (yet)

'Make me a spreadsheet' can target an existing sheet. If a similarly named spreadsheet exists, an agent may write into it. Say 'create a NEW spreadsheet' (and name it) when that's what you want.
If something you need is missing, there's usually a path: add the service's API key under Settings → Custom integrations and your agents can call it directly. See custom integrations & secrets. You can also ask your lead agent to open a ticket describing what it needs.

Using it in missions

Just ask in plain language: “check Google Sheets for …”, “create … in Google Sheets”, “every Monday, … ”, and the agent finds the right tool, runs it, and reports back with a receipt in your Runs ledger. Anything outward-facing (sending, posting, publishing) that a mission didn't clearly authorize comes back to you as a ticket first.

Troubleshooting

Agent says	What's happening	Fix
"Google Sheets isn't connected"	No active connection (or this agent is denied)	Connect on the Integrations page; check the agent's per-app policy
"The connection has expired"	Google Sheets ended the authorization (they all do periodically)	Click Reconnect on the account, same settings, one click
"I'm not allowed to do that"	The action is above the account's access level, or the agent is scoped down	Raise the level under Manage, or adjust that agent's policy
It did something unexpected	The ask was ambiguous (e.g. matched an existing item)	Be explicit, "create a NEW …", and give agents a working folder where relevant