Google Sheets

Connect Google Sheets so your agents can work in your Google Sheets account. You choose an access level for each account, and Squad refuses any agent action outside that level.

Access levels

Each Google Sheets account has an access level: Read-only, Read + create, and Full access. Squad refuses any agent action outside that level. You can also narrow or block single agents under Per-agent access.

Level	The connect window describes this level as	Actions agents can use
Read-only	”Read your spreadsheets. Cannot edit or create.”	18 of 56
Read + create	”Read existing sheets and create new ones.”	47 of 56
Full access (recommended)	“Read, edit, create, and delete any Google Sheet.”	56 of 56

Full access is the recommended level. The connect window selects it for you, and you can choose another level. The Google Sheets sign-in page asks you to approve full access to your account. This is expected. Squad does not narrow the sign-in. It checks every agent action against the level you chose, and it refuses actions outside that level.

What agents can do at each level

Each level opens with a short summary in plain tasks, then lists every action it adds, grouped by what the action works on. You do not need to name actions. Ask in plain words, and the agent searches for the matching action.

Find an action. Open a level and use your browser’s find (Ctrl+F, or Cmd+F on a Mac) with a word from the task or part of a slug. Or ask your agent in plain words, for example “What can you do in my Google Sheets account?” The agent can search the Google Sheets actions for you.

Each action shows its name, a one-line description where the Google Sheets action catalog has one, and its slug. The slug is the ID that agents use when they call the action.

Read-only

Agents can use 18 of the 56 Google Sheets actions at this level:

View cell values
View and search spreadsheets
View rules
View and search tables
View charts
View columns
View rows
View schemas
Search worksheets

All 18 actions at this level:

Works on	Action	What it does	Slug
Cell values	Get batch values	DEPRECATED: Use GOOGLESHEETS_BATCH_GET instead.	`GOOGLESHEETS_GET_BATCH_VALUES`
	Spreadsheets values batch get by data filter	Return one or more ranges of values from a spreadsheet that match the specified data filters.	`GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTER`
	Values get	Returns a range of values from a spreadsheet.	`GOOGLESHEETS_VALUES_GET`
Charts	List charts	Lists all charts in a Google Sheets spreadsheet across all sheets, returning chart_id, sheet metadata, chart type, title, and position.	`GOOGLESHEETS_LIST_CHARTS`
Columns	Aggregate column data	Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.	`GOOGLESHEETS_AGGREGATE_COLUMN_DATA`
Rows	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.	`GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW`
Rules	Get conditional format rules	List conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.	`GOOGLESHEETS_GET_CONDITIONAL_FORMAT_RULES`
	Get data validation rules	Extract data validation rules from a Google Sheets spreadsheet.	`GOOGLESHEETS_GET_DATA_VALIDATION_RULES`
Schemas	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.	`GOOGLESHEETS_GET_TABLE_SCHEMA`
Sheets	Get sheet names	Lists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.	`GOOGLESHEETS_GET_SHEET_NAMES`
Spreadsheets	Get spreadsheet by data filter	Returns the spreadsheet at the given ID, filtered by the specified data filters.	`GOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER`
	Get spreadsheet info	Retrieves metadata for a Google Spreadsheet using its ID.	`GOOGLESHEETS_GET_SPREADSHEET_INFO`
	Search spreadsheets	Search for Google Spreadsheets using various filters including name, content, date ranges, and more.	`GOOGLESHEETS_SEARCH_SPREADSHEETS`
Tables	List tables	DEPRECATED: Use GOOGLESHEETS_GET_SHEET_NAMES for tab discovery and GOOGLESHEETS_GET_SPREADSHEET_INFO for full sheet metadata.	`GOOGLESHEETS_LIST_TABLES`
	Query table	DEPRECATED: Use GOOGLESHEETS_VALUES_GET / GOOGLESHEETS_BATCH_GET for table reads and GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW for row lookup/filter workflows.	`GOOGLESHEETS_QUERY_TABLE`
Worksheets	Find worksheet by title	DEPRECATED: Use GetSpreadsheetInfo instead.	`GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE`
Other actions	Batch get	Retrieves data from specified cell ranges in a Google Spreadsheet.	`GOOGLESHEETS_BATCH_GET`
	Search developer metadata	Search for developer metadata in a spreadsheet.	`GOOGLESHEETS_SEARCH_DEVELOPER_METADATA`

Read + create

Agents can use 47 of the 56 Google Sheets actions at this level: everything in Read-only, plus:

Update cell values
View, create, and manage sheets
Create and update charts
Create, update, and manage dimensions
Update properties
View files
Update and delete filters
Create rows
View change history
Create columns
Update rules

The 29 actions that this level adds to Read-only:

Works on	Action	What it does	Slug
Cell values	Batch update values by data filter	Update values in ranges matching data filters.	`GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER`
	Format cell	Applies text and background cell formatting to a specified range in a Google Sheets worksheet.	`GOOGLESHEETS_FORMAT_CELL`
	Spreadsheets values append	Append values to a spreadsheet.	`GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND`
	Update values batch	Set values in one or more ranges of a spreadsheet.	`GOOGLESHEETS_UPDATE_VALUES_BATCH`
	Values update	Set values in a range of a Google Spreadsheet.	`GOOGLESHEETS_VALUES_UPDATE`
Change history	List drive changes		`GOOGLESHEETS_LIST_DRIVE_CHANGES`
Charts	Create chart	Create a chart in a Google Sheets spreadsheet using the specified data range and chart type.	`GOOGLESHEETS_CREATE_CHART`
	Move chart	Move or resize an existing chart on a Google Sheets spreadsheet.	`GOOGLESHEETS_MOVE_CHART`
	Update chart	Update the specification of an existing chart in a Google Sheets spreadsheet.	`GOOGLESHEETS_UPDATE_CHART`
Columns	Create spreadsheet column	Creates a new column in a Google Spreadsheet.	`GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN`
Dimensions	Append dimension	Append new rows or columns to a sheet, increasing its size.	`GOOGLESHEETS_APPEND_DIMENSION`
	Auto resize dimensions	Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions.	`GOOGLESHEETS_AUTO_RESIZE_DIMENSIONS`
	Insert dimension	Insert new rows or columns into a sheet at a specified location.	`GOOGLESHEETS_INSERT_DIMENSION`
Files	Export drive file		`GOOGLESHEETS_EXPORT_DRIVE_FILE`
	Get drive file metadata		`GOOGLESHEETS_GET_DRIVE_FILE_METADATA`
Filters	Clear basic filter	Clear the basic filter from a sheet.	`GOOGLESHEETS_CLEAR_BASIC_FILTER`
	Set basic filter	Set a basic filter on a sheet in a Google Spreadsheet.	`GOOGLESHEETS_SET_BASIC_FILTER`
Properties	Update dimension properties	Hide/unhide rows or columns and set row heights or column widths.	`GOOGLESHEETS_UPDATE_DIMENSION_PROPERTIES`
	Update sheet properties	Update properties of a sheet (worksheet) within a Google Spreadsheet, such as its title, index, visibility, tab color, or grid properties.	`GOOGLESHEETS_UPDATE_SHEET_PROPERTIES`
	Update spreadsheet properties	Update SPREADSHEET-LEVEL properties such as the spreadsheet’s title, locale, time zone, or auto-recalculation settings.	`GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES`
Rows	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.	`GOOGLESHEETS_CREATE_SPREADSHEET_ROW`
	Upsert rows	Automatically handles column mapping and partial updates.	`GOOGLESHEETS_UPSERT_ROWS`
Rules	Set data validation rule	Set or clear data validation rules (including dropdowns) on a range in Google Sheets.	`GOOGLESHEETS_SET_DATA_VALIDATION_RULE`
Sheets	Add sheet	Adds a new sheet to a spreadsheet.	`GOOGLESHEETS_ADD_SHEET`
	Create Google sheet1	Creates a new Google Spreadsheet in Google Drive.	`GOOGLESHEETS_CREATE_GOOGLE_SHEET1`
	Export sheet as PDF		`GOOGLESHEETS_EXPORT_SHEET_AS_PDF`
	Sheet from JSON	DEPRECATED: Use GOOGLESHEETS_CREATE_GOOGLE_SHEET1 + GOOGLESHEETS_UPDATE_VALUES_BATCH (or GOOGLESHEETS_VALUES_UPDATE / GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND) instead.	`GOOGLESHEETS_SHEET_FROM_JSON`
	Spreadsheets sheets copy to	Copy a single sheet from a spreadsheet to another spreadsheet.	`GOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TO`
Other actions	Find replace	Find and replace text in a Google Spreadsheet.	`GOOGLESHEETS_FIND_REPLACE`

Full access (recommended)

Agents can use 56 of the 56 Google Sheets actions at this level: everything in Read + create, plus:

Delete cell values
Delete charts
Delete dimensions
Delete sheets

The 9 actions that this level adds to Read + create:

Works on	Action	What it does	Slug
Cell values	Batch clear values by data filter	Clears one or more ranges of values from a spreadsheet using data filters.	`GOOGLESHEETS_BATCH_CLEAR_VALUES_BY_DATA_FILTER`
	Clear values	Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet.	`GOOGLESHEETS_CLEAR_VALUES`
	Spreadsheets values batch clear	Clear one or more ranges of values from a spreadsheet.	`GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR`
Charts	Delete chart	Delete an existing chart from a Google Sheets spreadsheet.	`GOOGLESHEETS_DELETE_CHART`
Dimensions	Delete dimension	Delete specified rows or columns from a sheet in a Google Spreadsheet.	`GOOGLESHEETS_DELETE_DIMENSION`
Rules	Mutate conditional format rules	Add, update, delete, or reorder conditional format rules on a Google Sheet.	`GOOGLESHEETS_MUTATE_CONDITIONAL_FORMAT_RULES`
Sheets	Delete sheet	Delete a sheet (worksheet) from a spreadsheet.	`GOOGLESHEETS_DELETE_SHEET`
Other actions	Batch update	DEPRECATED: Use GOOGLESHEETS_VALUES_UPDATE instead.	`GOOGLESHEETS_BATCH_UPDATE`
	Execute SQL	DEPRECATED: Use direct Google Sheets actions instead.	`GOOGLESHEETS_EXECUTE_SQL`

Connect Google Sheets

Before you start:

You need a Google Sheets account that you can sign in to.
Your Squad subscription must be active. Squad does not connect apps while the subscription is not active.

Open Integrations

Open Settings > Integrations.

Add an integration

On the Connected apps tab, click + Add integration.

Find Google Sheets

Find Google Sheets in the catalog and click it. You can type the name in Search the catalog….

Choose an access level

Under Default scope, choose an access level. This level applies to every agent.

Click Connect Google Sheets

Click Connect Google Sheets. The Google Sheets sign-in page opens in a new tab.

Check that it works: Google Sheets shows under YOUR CONNECTIONS, with a row for the account and its access level.

Change the access level

Under YOUR CONNECTIONS, find the Google Sheets account.
Open the account menu (⋯) and click Manage scope.
Under Default scope, choose the new level.
Click Save access.

The change does not need a new sign-in. Agents get the new level from their next call.

Set access for one agent

Every agent uses the account’s level unless you set something else for it. You can narrow one agent to a lower level, or block it.

Under YOUR CONNECTIONS, open the account menu (⋯) on the Google Sheets account.
Click Manage scope.
Under Per-agent access, find the agent.
Choose the Default option to follow the account’s level, choose a lower level, or choose No access.
Click Save access.

An agent never gets more than the account’s level, even if you choose a higher level for it. Changes apply from the agent’s next call. An agent with No access does not see the account.

Use more than one Google Sheets account

Click + Account on the Google Sheets card to connect another account. Agents use the primary account unless they are asked to use a specific one.

After you click + Account, follow the connect steps above.
Each account has its own access level.
The first account you connect becomes the primary account. It shows ★ PRIMARY.
To change the primary account, open the account menu (⋯) and click Make primary.
To tell accounts apart, open the account menu (⋯) and click Rename.

Reconnect or disconnect

Reconnect when the connection has expired, or when you need to change what the account can reach on the Google Sheets side:

Open the account menu (⋯) and click Reconnect.
Click Reauthorize on Google Sheets.
Sign in to Google Sheets and approve the request.

Reconnect signs in to the same account again. It does not add a second connection. Open the account menu (⋯) on the Google Sheets account and click Disconnect. Agents lose access to that account at once.

Disconnect acts at once, with no confirmation step. If it was the primary account, another connected Google Sheets account becomes primary.

Costs

Google Sheets actions do not use Squad credits. Connected apps never use credits. For what does use credits, see What Squad costs.

Troubleshooting

An agent reports that an action is not allowed on this account.

Cause: the action is outside the account’s access level, or outside the level you set for that agent.
Fix: choose a higher level in Manage scope, or change the agent’s row under Per-agent access.

An agent says it has no access to Google Sheets, or it does not see the account.

Cause: the agent is set to No access under Per-agent access, or the account is not connected.
Fix: open Manage scope and change the agent’s row. If the account is missing, connect it again.

Connecting or saving fails with “Your subscription isn’t active.”

Cause: your Squad subscription is not active.
Fix: resubscribe. See Manage your subscription.

An agent says the Google Sheets connection has expired.

Cause: the sign-in for that account is no longer valid.
Fix: use Reconnect on the account.

Common questions

Can I limit what agents can do in Google Sheets?

Can I connect more than one Google Sheets account?

Click + Account on the Google Sheets card to connect another account. Agents use the primary account unless they are asked to use a specific one.

How do I disconnect Google Sheets?

Open the account menu (⋯) on the Google Sheets account and click Disconnect. Agents lose access to that account at once.

Connect apps

Add an MCP server or an API key

Use this when an action you need is not in this app.

Recommended

Analytics

Communication

CRM & Support

Dev & Project Management

E-commerce & Payments

Email & Productivity

File Storage

Finance & Time

Marketing & Social

Scheduling & Meetings

Access levels

What agents can do at each level

Connect Google Sheets

Change the access level

Set access for one agent

Use more than one Google Sheets account

Reconnect or disconnect

Costs

Troubleshooting

Common questions

Connect apps

Add an MCP server or an API key

​Access levels

​What agents can do at each level

​Connect Google Sheets

​Change the access level

​Set access for one agent

​Use more than one Google Sheets account

​Reconnect or disconnect

​Costs

​Troubleshooting

​Common questions

​Related pages

Connect apps

Add an MCP server or an API key

Access levels

What agents can do at each level

Connect Google Sheets

Change the access level

Set access for one agent

Use more than one Google Sheets account

Reconnect or disconnect

Costs

Troubleshooting

Common questions

Related pages