- Category: spreadsheets
- Auth: OAUTH2
- Composio-managed OAuth available? Yes
- Tools: 58
- Triggers: 16
- Slug:
GOOGLESHEETS - Version: 20261101_00
Frequently Asked Questions
How do I set up custom Google OAuth credentials for Google Sheets?
How do I set up custom Google OAuth credentials for Google Sheets?
Why am I seeing "App is blocked" when connecting Google Sheets?
Why am I seeing "App is blocked" when connecting Google Sheets?
Why am I getting "Google Sheets API has not been used in project" error?
Why am I getting "Google Sheets API has not been used in project" error?
Why am I getting "Error 400: invalid_scope"?
Why am I getting "Error 400: invalid_scope"?
Why does the OAuth consent screen show "Composio" instead of my app?
Why does the OAuth consent screen show "Composio" instead of my app?
Why am I getting 401 errors on tool calls?
Why am I getting 401 errors on tool calls?
Why am I getting "Quota Exhausted" or "rate limit exhausted"?
Why am I getting "Quota Exhausted" or "rate limit exhausted"?
Tools
Add Sheet to Existing Spreadsheet
Add Sheet to Existing Spreadsheet
GOOGLESHEETS_ADD_SHEETAdd 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, position, visibility, and text direction. Notes: - Sheet names must be unique; use forceUnique=true to auto-append suffix (_2, _3) if name exists - For tab colors, use EITHER rgbColor OR themeColor, not both - Avoid ‘index’ when creating sheets in parallel (causes errors)Input Parameters
Output
Aggregate Column Data
Aggregate Column Data
GOOGLESHEETS_AGGREGATE_COLUMN_DATAAggregates data from a column in a Google Sheet, either across all rows or rows matching column-value filters. Supports sum, average, count, minimum, maximum, and percentage.Input Parameters
Output
Append Dimension
Append Dimension
GOOGLESHEETS_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.Input Parameters
Output
Auto-Resize Rows or Columns
Auto-Resize Rows or Columns
GOOGLESHEETS_AUTO_RESIZE_DIMENSIONSAuto-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 data.Input Parameters
Output
Batch Clear Values By Data Filter
Batch Clear Values By Data Filter
GOOGLESHEETS_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 will be cleared. Only values are cleared — all other properties of the cell (such as formatting, data validation, etc..) are kept.Input Parameters
Output
Batch get spreadsheet
Batch get spreadsheet
GOOGLESHEETS_BATCH_GETRetrieves values from specified cell ranges in a Google Spreadsheet. If ranges are omitted or empty after filtering blank entries, it retrieves data from the first sheet.Input Parameters
Output
Batch update spreadsheet (Deprecated)
Batch update spreadsheet (Deprecated)
GOOGLESHEETS_BATCH_UPDATEDeprecated: Writes values to one range in a Google Sheet, or appends rows when no start cell is given. It may expand the sheet grid; if a recognized default sheet name is not found, it uses the first sheet instead.Input Parameters
Output
Batch Update Values by Data Filter
Batch Update Values by Data Filter
GOOGLESHEETS_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.Input Parameters
Output
Clear Basic Filter
Clear Basic Filter
GOOGLESHEETS_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.Input Parameters
Output
Clear spreadsheet values
Clear spreadsheet values
GOOGLESHEETS_CLEAR_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.Input Parameters
Output
Create Chart in Google Sheets
Create Chart in Google Sheets
GOOGLESHEETS_CREATE_CHARTCreate a chart in a Google Sheets spreadsheet using a specified data range and chart type, or an optional full chart specification. The chart type and data range are required even when supplying a chart specification.Input Parameters
Output
Create a Google Sheet
Create a Google Sheet
GOOGLESHEETS_CREATE_GOOGLE_SHEET1Creates a new Google Spreadsheet in Drive with an optional title and folder ID or exact folder name. Multiple matching folders return choices before creation; if moving a created spreadsheet to the requested folder fails, the response reports partial success.Input Parameters
Output
Create spreadsheet column
Create spreadsheet column
GOOGLESHEETS_CREATE_SPREADSHEET_COLUMNInserts a new column in a Google Spreadsheet at a specified index. Select the target sheet by numeric ID or name; if neither is provided, sheet ID 0 is used.Input Parameters
Output
Create spreadsheet row
Create spreadsheet row
GOOGLESHEETS_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.Input Parameters
Output
Delete Chart from Google Sheets
Delete Chart from Google Sheets
GOOGLESHEETS_DELETE_CHARTDelete 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 is deleted, it cannot be recovered. The chart data source (the cells containing the data) remains unchanged; only the chart visualization is removed.Input Parameters
Output
Delete Dimension (Rows/Columns)
Delete Dimension (Rows/Columns)
GOOGLESHEETS_DELETE_DIMENSIONTool 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.Input Parameters
Output
Delete Sheet
Delete Sheet
GOOGLESHEETS_DELETE_SHEETTool to delete a sheet (worksheet) from a spreadsheet. Use when you need to remove a specific sheet from a Google Sheet document.Input Parameters
Output
Execute SQL on Spreadsheet
Execute SQL on Spreadsheet
GOOGLESHEETS_EXECUTE_SQLDeprecated SQL facade for selecting, inserting, updating, and deleting data in automatically detected spreadsheet tables, including limited WITH queries; discovery reads at most 10,000 rows per sheet. For detected header-based tables, the first data row is skipped and update/delete row targeting can be offset.Input Parameters
Output
Export Drive Spreadsheet
Export Drive Spreadsheet
GOOGLESHEETS_EXPORT_DRIVE_FILEExport an entire native spreadsheet as XLSX, ODS, PDF, ZIP, CSV, or TSV; use Export Sheet as PDF for print layout and range controls.Input Parameters
Output
Export Sheet as PDF
Export Sheet as PDF
GOOGLESHEETS_EXPORT_SHEET_AS_PDFRender one sheet tab or rectangular range as PDF with orientation, gridline, margin, and fit-to-width controls.Input Parameters
Output
Find and Replace in Spreadsheet
Find and Replace in Spreadsheet
GOOGLESHEETS_FIND_REPLACEFinds and replaces text across cells in a Google Spreadsheet, scoped to a sheet, range, or all sheets; if no scope is specified, it searches all sheets. Formula cells can be included explicitly when fixing formula references or patterns.Input Parameters
Output
Find worksheet by title (Deprecated)
Find worksheet by title (Deprecated)
GOOGLESHEETS_FIND_WORKSHEET_BY_TITLEDEPRECATED: Finds a worksheet by its case-sensitive title within a Google Spreadsheet, after trimming input whitespace and decoding Unicode escapes. Returns a found boolean and matched worksheet metadata, or indicates no match.Input Parameters
Output
Format cell
Format cell
GOOGLESHEETS_FORMAT_CELLFormats a specified cell range in a Google Sheets worksheet. It always applies text style, font size and background color defaults unless supplied; a sheet prefix in an A1 range is ignored, so select the worksheet separately.Input Parameters
Output
Batch Get Spreadsheet Values (Deprecated)
Batch Get Spreadsheet Values (Deprecated)
GOOGLESHEETS_GET_BATCH_VALUESDEPRECATED: Use GOOGLESHEETS_BATCH_GET instead. Tool to return one or more ranges of values from a spreadsheet. Use when you need to retrieve data from multiple ranges in a single request.Input Parameters
Output
Get conditional format rules
Get conditional format rules
GOOGLESHEETS_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.Input Parameters
Output
Get Data Validation Rules
Get Data Validation Rules
GOOGLESHEETS_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.Input Parameters
Output
Get Drive File Metadata
Get Drive File Metadata
GOOGLESHEETS_GET_DRIVE_FILE_METADATAGet JSON metadata for one Drive file without downloading its content.Input Parameters
Output
Get sheet names
Get sheet names
GOOGLESHEETS_GET_SHEET_NAMESLists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations.Input Parameters
Output
Get Spreadsheet by Data Filter
Get Spreadsheet by Data Filter
GOOGLESHEETS_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, developer metadata, or grid ranges. Important: This action is designed for filtered data retrieval. While it accepts empty filters and returns full metadata in that case, GOOGLESHEETS_GET_SPREADSHEET_INFO is the recommended action for unfiltered spreadsheet retrieval.Input Parameters
Output
Get spreadsheet info
Get spreadsheet info
GOOGLESHEETS_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 comprehensive metadata or specific fields.Input Parameters
Output
Get Table Schema
Get Table Schema
GOOGLESHEETS_GET_TABLE_SCHEMADeprecated: Retrieves an inferred schema for a detected table in a Google Spreadsheet, including column names and types estimated from sampled data.Input Parameters
Output
Insert Dimension in Google Sheet
Insert Dimension in Google Sheet
GOOGLESHEETS_INSERT_DIMENSIONTool 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.Input Parameters
Output
List Charts in Google Sheets
List Charts in Google Sheets
GOOGLESHEETS_LIST_CHARTSLists 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 spreadsheet, retrieve chart IDs for update or delete operations, or inspect chart configurations. The default field mask in GOOGLESHEETS_GET_SPREADSHEET_INFO omits chart data, making this dedicated action necessary for chart discovery.Input Parameters
Output
List Drive Changes
List Drive Changes
GOOGLESHEETS_LIST_DRIVE_CHANGESStart a Drive change monitor or list one page after an existing token.Input Parameters
Output
List Tables in Spreadsheet
List Tables in Spreadsheet
GOOGLESHEETS_LIST_TABLESDeprecated: Lists heuristically detected tables in a Google Spreadsheet. It scans up to the first 1,000 rows and skips sheets with more than 2,000 rows or 100 columns.Input Parameters
Output
Look up spreadsheet row
Look up spreadsheet row
GOOGLESHEETS_LOOKUP_SPREADSHEET_ROWFinds the first row in a specified A1 range or the first sheet where a cell matches the query after Unicode and invisible-character normalization. Matching is case-insensitive and trims surrounding whitespace by default; both behaviors are configurable.Input Parameters
True, strips leading and trailing whitespace from cell values before matching. This helps match cells like ’ TOTAL ’ or ‘TOTAL ’ when searching for ‘TOTAL’.Output
Move or Resize Chart in Google Sheets
Move or Resize Chart in Google Sheets
GOOGLESHEETS_MOVE_CHARTMove 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 sheet, or change its size. This action wraps the updateEmbeddedObjectPosition batchUpdate request type and supports three positioning modes: moving to a new sheet, moving to an existing sheet, or repositioning via pixel-perfect overlay coordinates.Input Parameters
Output
Move Spreadsheet to Folder
Move Spreadsheet to Folder
Mutate conditional format rules
Mutate conditional format rules
GOOGLESHEETS_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. Supports four operations: ADD (create new rule), UPDATE (replace existing rule), DELETE (remove rule), MOVE (reorder rules by changing index).Input Parameters
Output
Query Spreadsheet Table
Query Spreadsheet Table
GOOGLESHEETS_QUERY_TABLEExecutes SQL-like SELECT queries against detected tables in a native Google spreadsheet, with filtering, sorting, and limits. Sheet names can refer to the first detected table; detection and query processing are heuristic, and results may omit rows. DEPRECATED: Use GOOGLESHEETS_VALUES_GET or GOOGLESHEETS_BATCH_GET for table reads, and GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW for row lookup or filtering.Input Parameters
Output
Search Developer Metadata
Search Developer Metadata
Search Spreadsheets
Search Spreadsheets
GOOGLESHEETS_SEARCH_SPREADSHEETSSearch for Google spreadsheets accessible in Drive by name, content, dates, and other filters, including starred and shared-with-me status. Results are paginated, with up to 1,000 items per page; shared drives are included by default and searches across them may be incomplete.Input Parameters
Output
Set Basic Filter
Set Basic Filter
GOOGLESHEETS_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.Input Parameters
Output
Set Data Validation Rule
Set Data Validation Rule
GOOGLESHEETS_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.Input Parameters
Output
Create sheet from JSON
Create sheet from JSON
GOOGLESHEETS_SHEET_FROM_JSONDEPRECATED: Creates a new Google Spreadsheet and populates its first worksheet from JSON rows; an empty list creates an empty worksheet. Headers use keys from the first row followed by additional keys found in later rows.Input Parameters
Output
Sort Range
Sort Range
GOOGLESHEETS_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 (cascading) sorts.Input Parameters
Output
Copy Sheet to Another Spreadsheet
Copy Sheet to Another Spreadsheet
Append Values to Spreadsheet
Append Values to Spreadsheet
GOOGLESHEETS_SPREADSHEETS_VALUES_APPENDTool 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.Input Parameters
Output
Batch Clear Spreadsheet Values
Batch Clear Spreadsheet Values
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEARTool 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.Input Parameters
Output
Batch Get Spreadsheet Values by Data Filter
Batch Get Spreadsheet Values by Data Filter
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTERRetrieves one or more ranges of values from a Google Spreadsheet using data filters. Each filter specifies an A1 range or a grid range.Input Parameters
Output
Update Chart in Google Sheets
Update Chart in Google Sheets
GOOGLESHEETS_UPDATE_CHARTUpdates an existing chart in a Google Sheets spreadsheet by replacing its chart specification. The specification can change its title, chart type, data ranges, colors, axes, and other visual settings without moving or resizing the chart.Input Parameters
Output
Update Dimension Properties (Hide/Unhide & Resize)
Update Dimension Properties (Hide/Unhide & Resize)
GOOGLESHEETS_UPDATE_DIMENSION_PROPERTIESTool 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.Input Parameters
Output
Update Sheet Properties
Update Sheet Properties
GOOGLESHEETS_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 appearance of a specific sheet.Input Parameters
Output
Update Spreadsheet Properties
Update Spreadsheet Properties
GOOGLESHEETS_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 Spreadsheet. NOTE: To update individual SHEET properties (like renaming a specific sheet/tab), use GOOGLESHEETS_UPDATE_SHEET_PROPERTIES instead.Input Parameters
Output
Batch update spreadsheet values
Batch update spreadsheet values
GOOGLESHEETS_UPDATE_VALUES_BATCHTool 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.Input Parameters
Output
Upsert Rows (Smart Update/Insert)
Upsert Rows (Smart Update/Insert)
GOOGLESHEETS_UPSERT_ROWSUpserts rows in a Google Sheet by matching a key column: updates matching rows and appends new ones. It maps columns by header name, adds missing columns, and supports partial updates.Input Parameters
Output
Get spreadsheet values
Get spreadsheet values
GOOGLESHEETS_VALUES_GETReturns a range of values from a spreadsheet. Use when you need to read data from specific cells or ranges in a Google Sheet.Input Parameters
Output
Update spreadsheet values
Update spreadsheet values
GOOGLESHEETS_VALUES_UPDATESets or overwrites values in a Google Spreadsheet range, adjusting the range to fit the supplied values and potentially expanding the sheet by default. Unmatched common default sheet names may resolve to the first sheet.Input Parameters
Output
Triggers
Aggregate Metric Changed
Aggregate Metric Changed
GOOGLESHEETS_AGGREGATE_METRIC_CHANGED_TRIGGERType: pollTriggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.Configuration
Payload
Cell Range Values Changed
Cell Range Values Changed
GOOGLESHEETS_CELL_RANGE_VALUES_CHANGED_TRIGGERType: pollTriggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.Configuration
Payload
Conditional Format Rule Changed
Conditional Format Rule Changed
GOOGLESHEETS_CONDITIONAL_FORMAT_RULE_CHANGED_TRIGGERType: pollTriggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.Configuration
Payload
Data Validation Rule Changed
Data Validation Rule Changed
GOOGLESHEETS_DATA_VALIDATION_RULE_CHANGED_TRIGGERType: pollTriggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.Configuration
Payload
Developer Metadata Changed
Developer Metadata Changed
GOOGLESHEETS_DEVELOPER_METADATA_CHANGED_TRIGGERType: pollTriggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.Configuration
Payload
Filtered Range Values Changed
Filtered Range Values Changed
GOOGLESHEETS_FILTERED_RANGE_VALUES_CHANGED_TRIGGERType: pollPolling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.Configuration
Payload
New Rows in Google Sheet
New Rows in Google Sheet
New Sheet Added in Google Spreadsheet
New Sheet Added in Google Spreadsheet
New Spreadsheet Created
New Spreadsheet Created
GOOGLESHEETS_NEW_SPREADSHEET_CREATED_TRIGGERType: pollTriggers when a new Google Spreadsheet is created. This trigger monitors Google Spreadsheets and fires when new spreadsheets are detected. Uses timestamp filtering to efficiently detect newly created spreadsheets.Configuration
Payload
Spreadsheet Metadata Changed
Spreadsheet Metadata Changed
Spreadsheet Properties Changed
Spreadsheet Properties Changed
Spreadsheet Row Changed
Spreadsheet Row Changed
GOOGLESHEETS_SPREADSHEET_ROW_CHANGED_TRIGGERType: pollTriggers when a looked-up spreadsheet row changes. This trigger monitors a specific row (located by searching for a query value within a user-specified range) and fires when the row’s values change, when the row appears, or when the row disappears.Configuration
True, strips leading and trailing whitespace from cell values before matching. This helps match cells like ’ TOTAL ’ or ‘TOTAL ’ when searching for ‘TOTAL’.Payload
Spreadsheet Search Match
Spreadsheet Search Match
GOOGLESHEETS_SPREADSHEET_SEARCH_MATCH_TRIGGERType: pollTriggers when a new spreadsheet appears that matches a saved search. This trigger uses snapshot-based diffing to detect when spreadsheets matching the search criteria are newly created or become visible to the user.Configuration
Payload
Table Query Result Changed
Table Query Result Changed
GOOGLESHEETS_TABLE_QUERY_RESULT_CHANGED_TRIGGERType: pollTriggers when the result set of a saved table query changes in Google Sheets. Detects rows added, removed, or updated in the query output. This trigger monitors the result of a SQL query against a Google Sheets table and fires when changes are detected.Configuration
Payload
Table Schema Changed
Table Schema Changed
GOOGLESHEETS_TABLE_SCHEMA_CHANGED_TRIGGERType: pollPolling trigger that detects when a table’s schema changes in Google Sheets. Monitors columns added/removed/renamed and inferred type/format changes. Uses snapshot-based diffing to compare schemas between polls.