Google Sheets for AI agents
Agents read Google Sheets at once. Changes and sends are held for a person's approval by default.
About Google Sheets
Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps
What an agent can do in Google Sheets
Every Google Sheets action is classed by the platform as a read, a change or a send. Reads run at once. Changes and sends are held for a person by default.
Runs at once (reads)
Looks things up in Google Sheets without asking first. 15 actions.
- Batch get spreadsheetRetrieves data from specified cell ranges in a Google Spreadsheet.
- Get Drive File MetadataGet JSON metadata for one Drive file without downloading its content.
- 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. Use this tool when you need to retrieve specific subsets of data from a Google Sheet based on criteria like A1 notation
- Get spreadsheet infoRetrieves metadata for a Google Spreadsheet using its ID. By default, returns essential information (ID, title, sheet properties) to avoid payload size issues. Use the fields parameter for comprehensi
- 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. Use this action when you need to discover what charts exist in a
- List Drive ChangesStart a Drive change monitor or list one page after an existing token.
- Search Developer MetadataTool to search for developer metadata in a spreadsheet. Use when you need to find specific metadata entries based on filters.
- Search SpreadsheetsSearch for Google Spreadsheets using various filters including name, content, date ranges, and more.
- Batch Get Spreadsheet Values by Data FilterTool to return one or more ranges of values from a spreadsheet that match the specified data filters. Use when you need to retrieve specific data sets based on filtering criteria rather than entire sh
- Get spreadsheet valuesReturns a range of values from a spreadsheet. Use when you need to read data from specific cells or ranges in a Google Sheet.
- Aggregate Column DataSearches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Show all 15
- Get conditional format rulesList conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form. Use when you need to view, audit, or prepare to modify conditional format rules.
- Get Data Validation RulesTool to extract data validation rules from a Google Sheets spreadsheet. Use when you need to understand dropdown lists, allowed values, custom formulas, or other validation constraints for cells.
- 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 sheet by default.
Held for approval by default (changes and sends)
Held for a person's approval by default. The approval is recorded and the action is sent once, never twice, with 10 seconds to undo. 33 actions.
- Add Sheet to Existing SpreadsheetAdd a GRID sheet with rows and columns to an existing spreadsheet. This action does not create chart-only or DATA_SOURCE sheets. Use properties to configure the GRID sheet's dimensions, tab color, pos
- Append DimensionTool to append new rows or columns to a sheet, increasing its size. Use when you need to add empty rows or columns to an existing sheet.
- Batch Clear Values By Data FilterClears one or more ranges of values from a spreadsheet using data filters. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges matching any of the specified data filters wil
- Clear Basic FilterTool to 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.
- Create a Google SheetCreates a new Google Spreadsheet in Google Drive. If a title is provided, the spreadsheet will be created with that name. If no title is provided, Google will create a spreadsheet with a default name
- Delete Dimension (Rows/Columns)Tool to delete specified rows or columns from a sheet in a Google Spreadsheet. Use when you need to remove a range of rows or columns.
- Delete SheetTool to delete a sheet (worksheet) from a spreadsheet. Use when you need to remove a specific sheet from a Google Sheet document.
- Find and Replace in SpreadsheetTool to find and replace text in a Google Spreadsheet. Use when you need to fix formula errors, update values, or perform bulk text replacements across cells. Common use cases: - Fix #ERROR! cells by
- Insert Dimension in Google SheetTool to insert new rows or columns into a sheet at a specified location. Use when you need to add empty rows or columns within an existing Google Sheet.
- Move or Resize Chart in Google SheetsMove or resize an existing chart on a Google Sheets spreadsheet. Use this action when you need to reposition a chart to a different location on the same or different sheet, move it to a brand-new shee
- Move Spreadsheet to FolderMove an existing Google Spreadsheet to a different Google Drive folder.
- Mutate conditional format rulesAdd, update, delete, or reorder conditional format rules on a Google Sheet. Use when you need to create, modify, or remove conditional formatting without manually building batchUpdate requests. Suppor
Show all 33
- Set Basic FilterTool to set a basic filter on a sheet in a Google Spreadsheet. Use when you need to filter or sort data within a specific range on a sheet.
- Set Data Validation RuleTool to set or clear data validation rules (including dropdowns) on a range in Google Sheets. Use when you need to apply dropdown lists, range-based dropdowns, or custom formula validation to cells.
- Sort RangeSorts data within a specified range in a Google Sheet based on one or more sort criteria. Use this action when you need to reorder rows in a range by column values, with support for multi-level (casca
- Copy Sheet to Another SpreadsheetTool to copy a single sheet from a spreadsheet to another spreadsheet. Use when you need to duplicate a sheet into a different spreadsheet.
- Append Values to SpreadsheetTool to append values to a spreadsheet. Use when you need to add new data to the end of an existing table in a Google Sheet.
- Batch Clear Spreadsheet ValuesTool to clear one or more ranges of values from a spreadsheet. Use when you need to remove data from specific cells or ranges while keeping formatting and other properties intact.
- Update Dimension Properties (Hide/Unhide & Resize)Tool to hide/unhide rows or columns and set row heights or column widths. Use when you need to change visibility or pixel sizing of dimensions in a Google Sheet.
- 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. Use this when you need to modify the metadata or appe
- Update Spreadsheet PropertiesTool to update SPREADSHEET-LEVEL properties such as the spreadsheet's title, locale, time zone, or auto-recalculation settings. Use when you need to modify the overall configuration of a Google Spread
- Batch update spreadsheet valuesTool to set values in one or more ranges of a spreadsheet. Use when you need to update multiple ranges in a single operation for better performance.
- Upsert Rows (Smart Update/Insert)Upsert rows - update existing rows by key, append new ones. Automatically handles column mapping and partial updates. Use for: CRM syncs (match Lead ID), transaction imports (match Transaction ID), in
- Update spreadsheet valuesTool to set values in a range of a Google Spreadsheet. Use when you need to update or overwrite existing cell values in a specific range.
- Auto-Resize Rows or ColumnsAuto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions. Use when you need to automatically adjust row heights or column widths to fit content after writing
- Batch Update Values by Data FilterTool to update values in ranges matching data filters. Use when you need to update specific data in a Google Sheet based on criteria rather than fixed cell ranges.
- 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 cells.
- Create Chart in Google SheetsCreate a chart in a Google Sheets spreadsheet using the specified data range and chart type. Conditional requirements: - Provide either a simple chart via chart_type + data_range (basicChart), OR supp
- Create spreadsheet columnCreates a new column in a Google Spreadsheet. Specify the target sheet using sheet_id (numeric) or sheet_name (text). If neither is provided, defaults to the first sheet (sheet_id=0).
- 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.
- Delete Chart from Google SheetsDelete an existing chart from a Google Sheets spreadsheet. Use this action when you need to remove a chart that is no longer needed or needs to be replaced. This action is irreversible — once a chart
- Format cellApplies text and background cell formatting to a specified range in a Google Sheets worksheet.
- Update Chart in Google SheetsUpdate the specification of an existing chart in a Google Sheets spreadsheet. Use this action when you need to modify an existing chart's properties such as its title, chart type, data ranges, colors,
Changes wait in Needs you
Changes and sends in Google Sheets are held for a person's approval by default. The approval is recorded, and the action is sent once, never twice, with 10 seconds to undo.
Google Sheets questions
Can an agent change data in Google Sheets on its own?
Not by default. Changes and sends in Google Sheets are held for a person's approval. The approval is recorded, and the action is sent once, never twice, with 10 seconds to undo.
What can an agent read in Google Sheets?
This connector lists 15 read actions. Reads run at once, without waiting for approval.
How does Google Sheets connect?
It connects with OAuth 2.0. Connectors are built and maintained by third-party developers; availability is confirmed during scoping.