53 available actions

What your AI agent can do in Google Sheets

Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps This page lists every available action. Your agent only receives the actions and permissions required for the role you approve.

Common starting points

Find and Replace in SpreadsheetTool to find and replace text in a Google Spreadsheet.
Search Developer MetadataTool to search for developer metadata in a spreadsheet.
Add Sheet to Existing SpreadsheetAdds a new sheet to a spreadsheet.
Create Chart in Google SheetsCreate a chart in a Google Sheets spreadsheet using the specified data range and chart type.
Update Chart in Google SheetsUpdate the specification of an existing chart in a Google Sheets spreadsheet.
Update Dimension Properties (Hide/Unhide & Resize)Tool to hide/unhide rows or columns and set row heights or column widths.

Browse all 53 actions by capability

Open a capability to see every supported action and its description.

Find & reviewLook up and review existing recordsView 14 actionsHide actions

Find and Replace in SpreadsheetTool to find and replace text in a Google Spreadsheet.
Find worksheet by title (Deprecated)DEPRECATED: Use GetSpreadsheetInfo instead.
Get conditional format rulesList conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.
Get Data Validation RulesTool to extract data validation rules from a Google Sheets spreadsheet.
Get sheet namesLists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.
Get Spreadsheet by Data FilterReturns the spreadsheet at the given ID, filtered by the specified data filters.
Get spreadsheet infoRetrieves metadata for a Google Spreadsheet using its ID.
Get Table SchemaDEPRECATED: Use GOOGLESHEETS_GET_SHEET_NAMES and GOOGLESHEETS_GET_SPREADSHEET_INFO for sheet structure metadata, and GOOGLESHEETS_VALUES_GET for direct range inspection.
List Charts in Google SheetsLists all charts in a Google Sheets spreadsheet across all sheets, returning chart_id, sheet metadata, chart type, title, and position.
List Tables in SpreadsheetDEPRECATED: Use GOOGLESHEETS_GET_SHEET_NAMES for tab discovery and GOOGLESHEETS_GET_SPREADSHEET_INFO for full sheet metadata.
Query Spreadsheet TableDEPRECATED: Use GOOGLESHEETS_VALUES_GET / GOOGLESHEETS_BATCH_GET for table reads and GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW for row lookup/filter workflows.
Search Developer MetadataTool to search for developer metadata in a spreadsheet.
Search SpreadsheetsSearch for Google Spreadsheets using various filters including name, content, date ranges, and more.
Get spreadsheet valuesReturns a range of values from a spreadsheet.

Create & communicateCreate records or send supported messagesView 6 actionsHide actions

Add Sheet to Existing SpreadsheetAdds a new sheet to a spreadsheet.
Create Chart in Google SheetsCreate a chart in a Google Sheets spreadsheet using the specified data range and chart type.
Create a Google SheetCreates a new Google Spreadsheet in Google Drive.
Create spreadsheet columnCreates a new column in a Google Spreadsheet.
Create spreadsheet rowInserts a new, empty row into a specified sheet of a Google Spreadsheet at a given index, optionally inheriting formatting from the row above.
Create sheet from JSONDEPRECATED: Use GOOGLESHEETS_CREATE_GOOGLE_SHEET1 + GOOGLESHEETS_UPDATE_VALUES_BATCH (or GOOGLESHEETS_VALUES_UPDATE / GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND) instead.

Update & manageChange and manage existing recordsView 11 actionsHide actions

Execute SQL on SpreadsheetDEPRECATED: Use direct Google Sheets actions instead: - GOOGLESHEETS_VALUES_GET / GOOGLESHEETS_BATCH_GET for reads - GOOGLESHEETS_VALUES_UPDATE /…
Move or Resize Chart in Google SheetsMove or resize an existing chart on a Google Sheets spreadsheet.
Set Basic FilterTool to set a basic filter on a sheet in a Google Spreadsheet.
Set Data Validation RuleTool to set or clear data validation rules (including dropdowns) on a range in Google Sheets.
Copy Sheet to Another SpreadsheetTool to copy a single sheet from a spreadsheet to another spreadsheet.
Update Chart in Google SheetsUpdate the specification of an existing chart in a Google Sheets spreadsheet.
Update Dimension Properties (Hide/Unhide & Resize)Tool to hide/unhide rows or columns and set row heights or column widths.
Update Sheet PropertiesTool to update properties of a sheet (worksheet) within a Google Spreadsheet, such as its title, index, visibility, tab color, or grid properties.
Update Spreadsheet PropertiesTool to update SPREADSHEET-LEVEL properties such as the spreadsheet's title, locale, time zone, or auto-recalculation settings.
Upsert Rows (Smart Update/Insert)Upsert rows - update existing rows by key, append new ones.
Update spreadsheet valuesTool to set values in a range of a Google Spreadsheet.

Remove & cancelRemove records or cancel supported workView 3 actionsHide actions

Delete Chart from Google SheetsDelete an existing chart from a Google Sheets spreadsheet.
Delete Dimension (Rows/Columns)Tool to delete specified rows or columns from a sheet in a Google Spreadsheet.
Delete SheetTool to delete a sheet (worksheet) from a spreadsheet.

Other actionsSpecialist and administrative actions.View 19 actionsHide actions

Aggregate Column DataSearches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Append DimensionTool to append new rows or columns to a sheet, increasing its size.
Auto-Resize Rows or ColumnsAuto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions.
Batch Clear Values By Data FilterClears one or more ranges of values from a spreadsheet using data filters.
Batch get spreadsheetRetrieves data from specified cell ranges in a Google Spreadsheet.
Batch update spreadsheet (Deprecated)DEPRECATED: Use GOOGLESHEETS_VALUES_UPDATE instead.
Batch Update Values by Data FilterTool to update values in ranges matching data filters.
Clear Basic FilterTool to clear the basic filter from a sheet.
Clear spreadsheet valuesClears 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…
Format cellApplies text and background cell formatting to a specified range in a Google Sheets worksheet.
Batch Get Spreadsheet Values (Deprecated)DEPRECATED: Use GOOGLESHEETS_BATCH_GET instead.
Insert Dimension in Google SheetTool to insert new rows or columns into a sheet at a specified location.
Look up spreadsheet rowFinds 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…
Mutate conditional format rulesAdd, update, delete, or reorder conditional format rules on a Google Sheet.
Sort RangeSorts data within a specified range in a Google Sheet based on one or more sort criteria.
Append Values to SpreadsheetTool to append values to a spreadsheet.
Batch Clear Spreadsheet ValuesTool to clear one or more ranges of values from a spreadsheet.
Batch Get Spreadsheet Values by Data FilterTool to return one or more ranges of values from a spreadsheet that match the specified data filters.
Batch update spreadsheet valuesTool to set values in one or more ranges of a spreadsheet.

Connection record

A connection you can control.

Sign-in: OAuth sign-in
Setup: Sign in with your own Google Sheets account. Access is limited to the work agreed for the role.
Boundaries: Only the approved role and actions.
Off switch: Revoke the connection from your account.

FAQ

Before you connect Google Sheets

How does the agent connect to Google Sheets?

You sign in with your own Google Sheets account. Permissions are limited to what the agent needs, the connection is health-checked, and you can revoke access from Google Sheets at any time.

What can the agent actually do in Google Sheets?

The page above lists the 53 actions currently available through the Google Sheets connection. The role determines which of those actions the agent may use, and write access is only enabled when the workflow needs it.

Is Google Sheets included in my plan?

Connections are priced per tool on top of the base plan. Some are included and some are premium. See pricing for how connection charges work.

How long until Google Sheets is ready?

Timing depends on the sign-in method, permissions and workflow being connected. We confirm the scope and setup plan before enabling the connection.

Bring the workflow together

Ready to put Google Sheets to work?

Start with the responsibility you want off your plate. We’ll map the connection and the boundaries around it.

Book a setup call Browse all connections

All product names, logos, and brands are property of their respective owners and are used for identification only. ZeroToClaw is not affiliated with or endorsed by Google Sheets.