Google Sheets

Triggers16

Things that can wake up your Google Sheets coworker.

• Aggregate Metric Changed

  Triggers 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.

  GOOGLESHEETS_AGGREGATE_METRIC_CHANGED_TRIGGER
• Cell Range Values Changed

  Triggers 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.

  GOOGLESHEETS_CELL_RANGE_VALUES_CHANGED_TRIGGER
• Conditional Format Rule Changed

  Triggers 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.

  GOOGLESHEETS_CONDITIONAL_FORMAT_RULE_CHANGED_TRIGGER
• Data Validation Rule Changed

  Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.

  GOOGLESHEETS_DATA_VALIDATION_RULE_CHANGED_TRIGGER
• Developer Metadata Changed

  Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.

  GOOGLESHEETS_DEVELOPER_METADATA_CHANGED_TRIGGER
• Filtered Range Values Changed

  Polling 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.

  GOOGLESHEETS_FILTERED_RANGE_VALUES_CHANGED_TRIGGER
• New Rows in Google Sheet

  Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.

  GOOGLESHEETS_NEW_ROWS_TRIGGER
• New Sheet Added in Google Spreadsheet

  Polling trigger that detects when a new sheet is added to a Google Spreadsheet.

  GOOGLESHEETS_NEW_SHEET_ADDED_TRIGGER
• New Spreadsheet Created

  Triggers 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.

  GOOGLESHEETS_NEW_SPREADSHEET_CREATED_TRIGGER
• Spreadsheet Metadata Changed

  Polling trigger that detects when a Google Spreadsheet's metadata changes. Uses snapshot-based diffing to detect any changes in spreadsheet properties, sheets, named ranges, developer metadata, data sources, etc.

  GOOGLESHEETS_SPREADSHEET_METADATA_CHANGED_TRIGGER
• Spreadsheet Properties Changed

  Polling trigger that detects when a Google Spreadsheet's top-level properties change. Monitors properties such as title, locale, timeZone, and autoRecalc settings.

  GOOGLESHEETS_SPREADSHEET_PROPERTIES_CHANGED_TRIGGER
• Spreadsheet Row Changed

  Triggers 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.

  GOOGLESHEETS_SPREADSHEET_ROW_CHANGED_TRIGGER
• Spreadsheet Search Match

  Triggers 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.

  GOOGLESHEETS_SPREADSHEET_SEARCH_MATCH_TRIGGER
• Table Query Result Changed

  Triggers 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.

  GOOGLESHEETS_TABLE_QUERY_RESULT_CHANGED_TRIGGER
• Table Schema Changed

  Polling 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.

  GOOGLESHEETS_TABLE_SCHEMA_CHANGED_TRIGGER
• Worksheet Names Changed

  Triggers when the set of worksheet/tab names changes in a Google Spreadsheet. Detects when sheets are added, deleted, or renamed.

  GOOGLESHEETS_WORKSHEET_NAMES_CHANGED_TRIGGER

Actions20

Things your coworker can do in Google Sheets.

• Add Sheet to Existing Spreadsheet

  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. - OBJECT: Sheet containing a chart. Requires objectSheetConfig with chartSpec (basicChart or pieChart). - DATA_SOURCE: Sheet connected to BigQuery. Requires dataSourceConfig with bigQuery spec and bigquery.readonly OAuth scope. OTHER 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) - OBJECT sheets are created via addChart with position.newSheet=true - DATA_SOURCE sheets require bigquery.readonly OAuth scope Use cases: Add standard grid sheet, create chart on dedicated sheet, connect to BigQuery data source.

  GOOGLESHEETS_ADD_SHEET
• Append Dimension

  Tool 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.

  GOOGLESHEETS_APPEND_DIMENSION
• Batch Clear Values By Data Filter

  Clears 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.

  GOOGLESHEETS_BATCH_CLEAR_VALUES_BY_DATA_FILTER
• Batch get spreadsheet

  Retrieves data from specified cell ranges in a Google Spreadsheet.

  GOOGLESHEETS_BATCH_GET
• Batch update spreadsheet (Deprecated)

  DEPRECATED: Use GOOGLESHEETS_VALUES_UPDATE instead. Write values to ONE range in a Google Sheet, or append as new rows if no start cell is given. IMPORTANT - This tool does NOT accept the Google Sheets API's native batch format: - WRONG: {"data": [{"range": "...", "values": [[...]]}], ...} - CORRECT: {"sheet_name": "...", "values": [[...]], "first_cell_location": "...", ...} To update MULTIPLE ranges, make SEPARATE CALLS to this tool for each range. Features: - Auto-expands grid for large datasets (prevents range errors) - Set first_cell_location to write at a specific position (e.g., "A1", "B5") - Omit first_cell_location to append values as new rows at the end Requirements: Target sheet must exist and spreadsheet must contain at least one worksheet.

  GOOGLESHEETS_BATCH_UPDATE
• Clear Basic Filter

  Tool 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.

  GOOGLESHEETS_CLEAR_BASIC_FILTER
• Create a Google Sheet

  Creates 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 like 'Untitled spreadsheet'. Optionally create the spreadsheet in a specific folder by providing either: - folder_id: The Google Drive folder ID (preferred, unambiguous) - folder_name: The folder name (searches for exact match; if multiple folders match, returns choices) If neither folder_id nor folder_name is provided, the spreadsheet is created in the root Drive folder.

  GOOGLESHEETS_CREATE_GOOGLE_SHEET1
• 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.

  GOOGLESHEETS_DELETE_DIMENSION
• Delete Sheet

  Tool to delete a sheet (worksheet) from a spreadsheet. Use when you need to remove a specific sheet from a Google Sheet document.

  GOOGLESHEETS_DELETE_SHEET
• Find and Replace in Spreadsheet

  Tool 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 replacing with empty string or correct formula - Update old values with new ones across multiple cells - Fix formula references or patterns - Clean up data formatting issues

  GOOGLESHEETS_FIND_REPLACE
• Batch Get Spreadsheet Values (Deprecated)

  DEPRECATED: 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.

  GOOGLESHEETS_GET_BATCH_VALUES
• 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
• Get Spreadsheet by Data Filter

  Returns 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.

  GOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER
• Get spreadsheet info

  Retrieves 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.

  GOOGLESHEETS_GET_SPREADSHEET_INFO
• Insert Dimension in Google Sheet

  Tool 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.

  GOOGLESHEETS_INSERT_DIMENSION
• List Charts in Google Sheets

  Lists 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.

  GOOGLESHEETS_LIST_CHARTS
• Move or Resize Chart in Google Sheets

  Move 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.

  GOOGLESHEETS_MOVE_CHART
• Mutate conditional format rules

  Add, 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).

  GOOGLESHEETS_MUTATE_CONDITIONAL_FORMAT_RULES
• Search Developer Metadata

  Tool to search for developer metadata in a spreadsheet. Use when you need to find specific metadata entries based on filters.

  GOOGLESHEETS_SEARCH_DEVELOPER_METADATA
• Search Spreadsheets

  Search for Google Spreadsheets using various filters including name, content, date ranges, and more.

  GOOGLESHEETS_SEARCH_SPREADSHEETS