Reference

GOOGLESHEETS_AGGREGATE_METRIC_CHANGED_TRIGGER

Fires when a calculation like sum, count, average, minimum, or maximum changes for a specific column. Use this to trigger alerts or workflows when key metrics shift.

GOOGLESHEETS_CELL_RANGE_VALUES_CHANGED_TRIGGER

Fires when values change in a specified cell or range of cells. Use this to trigger actions whenever specific data points are updated.

GOOGLESHEETS_NEW_ROWS_TRIGGER

Fires when new rows are added to a spreadsheet. Use this to automatically process, notify about, or sync new data entries.

GOOGLESHEETS_NEW_SPREADSHEET_CREATED_TRIGGER

Fires when a new spreadsheet is created. Use this to automatically initialize new spreadsheets with templates, permissions, or integrations.

GOOGLESHEETS_SPREADSHEET_ROW_CHANGED_TRIGGER

Fires when a specific row's values change, or when a row you're tracking appears or disappears. Use this to monitor individual records and react to their updates.

GOOGLESHEETS_CONDITIONAL_FORMAT_RULE_CHANGED_TRIGGER

Fires when conditional formatting rules are added, modified, or deleted in a spreadsheet. Use this to track changes to visual formatting rules.

GOOGLESHEETS_DATA_VALIDATION_RULE_CHANGED_TRIGGER

Fires when data validation rules are added, modified, or removed from a spreadsheet. Use this to keep other systems updated when input restrictions change.

GOOGLESHEETS_DEVELOPER_METADATA_CHANGED_TRIGGER

Fires when custom metadata tags added to a spreadsheet are created, updated, or removed. Use this to track changes to spreadsheet annotations or custom attributes.

GOOGLESHEETS_FILTERED_RANGE_VALUES_CHANGED_TRIGGER

Fires when values change within a filtered range of cells in a spreadsheet. Use this to monitor specific data subsets and react to their changes.

GOOGLESHEETS_NEW_SHEET_ADDED_TRIGGER

Fires when a new sheet or tab is added to a spreadsheet. Use this to automatically set up formatting, formulas, or data for newly created sheets.

GOOGLESHEETS_SPREADSHEET_METADATA_CHANGED_TRIGGER

Fires when any aspect of a spreadsheet's metadata changes, including properties, sheets, named ranges, or data connections. Use this for comprehensive monitoring of spreadsheet configuration changes.

GOOGLESHEETS_SPREADSHEET_PROPERTIES_CHANGED_TRIGGER

Fires when a spreadsheet's settings change, such as its title, language, time zone, or calculation preferences. Use this to react to changes in how the spreadsheet is configured.

GOOGLESHEETS_SPREADSHEET_SEARCH_MATCH_TRIGGER

Fires when a new spreadsheet is created or becomes accessible that matches your search criteria. Use this to automatically react to newly created spreadsheets that meet certain conditions.

GOOGLESHEETS_TABLE_QUERY_RESULT_CHANGED_TRIGGER

Fires when rows are added, removed, or updated in a saved query's results. Use this to trigger workflows based on changes to query output from your data.

GOOGLESHEETS_TABLE_SCHEMA_CHANGED_TRIGGER

Fires when a table's structure changes, such as columns being added, removed, renamed, or changing data types. Use this to stay informed about changes to your data organization.

GOOGLESHEETS_WORKSHEET_NAMES_CHANGED_TRIGGER

Fires when sheets are added, deleted, or renamed within a spreadsheet. Use this to keep external systems in sync with your spreadsheet structure.

Create Chart in Google Sheets

Automatically generate visual charts from your spreadsheet data to transform numbers into clear, easy-to-understand graphics that tell your business story at a glance.

Delete Chart from Google Sheets

Remove unwanted chart visualizations from your Google Sheets spreadsheet to keep your data presentation clean and organized. This helps you maintain focused, professional-looking sheets by eliminating outdated or redundant charts.

List Charts in Google Sheets

Retrieve all charts from a Google Sheets spreadsheet, including their IDs, types, titles, and positions across all sheets. Use this to discover existing charts, get IDs needed for updates or deletions, or review your spreadsheet's visualization setup.

Move or Resize Chart in Google Sheets

Reposition or resize charts on your Google Sheets to improve layout and readability, whether moving them between sheets or adjusting their dimensions on the current sheet.

Update Chart in Google Sheets

Modify an existing chart's properties like title, type, data ranges, colors, and axes to keep your visualizations current with your spreadsheet data. This helps you maintain accurate reporting and presentations without recreating charts from scratch.

Aggregate Column Data

Quickly calculate totals, averages, or other metrics for specific data subsets by finding rows that match criteria and running math operations on related columns.

Create spreadsheet column

Add a new column to your Google Sheet to organize and store additional data alongside your existing information. This helps you expand your spreadsheet structure without manually creating columns in the interface.

Append Dimension

Expand your spreadsheet by adding new empty rows or columns to accommodate growing data. This is useful when you need to extend your sheet's structure without manually resizing.

Auto-Resize Rows or Columns

Automatically adjusts column widths or row heights to perfectly fit your content, eliminating manual formatting after adding or updating data in your spreadsheet.

Delete Dimension (Rows/Columns)

Remove unwanted rows or columns from your Google Sheet to clean up data and reorganize your spreadsheet structure. Use this when you need to delete a range of rows or columns that are no longer needed.

Insert Dimension in Google Sheet

Add new rows or columns at specific positions in your Google Sheet to reorganize data without losing existing information. This lets you insert space for new data or restructure your sheet layout on demand.

Update Dimension Properties (Hide/Unhide & Resize)

Modify the visibility and size of rows and columns in your Google Sheet to organize data presentation and improve readability. This helps you control which information is displayed and how much space each dimension occupies.

Clear Basic Filter

Remove filtering restrictions from a sheet to display all rows and columns again, making it easier to see your complete dataset or apply different filters.

Set Basic Filter

Apply filtering to your spreadsheet data to show only the rows that match your criteria, making it easier to focus on relevant information without manually hiding rows.

Format cell

Applies visual formatting like text color, background color, and text style to cells in your Google Sheet to make important data stand out and improve readability.

Get conditional format rules

Retrieve all conditional formatting rules applied to your spreadsheet sheets to view, audit, or prepare modifications. This helps you understand how your data is currently highlighted or formatted based on specific conditions.

Mutate conditional format rules

Automatically create, modify, remove, or reorder conditional formatting rules in your Google Sheets to highlight cells based on specific conditions. This lets you visually organize and manage data formatting at scale without manually configuring each rule.

Search Developer Metadata

Find and retrieve custom metadata tags you've added to your spreadsheet cells, rows, or columns based on specific criteria. This helps you quickly locate and organize data that's been tagged with custom information for your workflows.

Execute SQL on Spreadsheet

Query and modify Google Sheets data using SQL syntax, allowing you to perform complex searches, updates, and data transformations without leaving your spreadsheet. This operation automatically recognizes your sheet structure and supports SELECT, INSERT, UPDATE, and DELETE commands.

Look up spreadsheet row

Search for the first row in a Google Spreadsheet that exactly matches a specific value, automatically locating the data you need without manual scrolling. This helps you quickly find customer records, inventory items, or any specific information stored in your sheets.

Upsert Rows (Smart Update/Insert)

Intelligently updates existing rows in a spreadsheet by matching a key column, or inserts new rows if no match is found, while automatically handling column mapping and partial updates without disrupting other data.

Create spreadsheet row

Adds a new empty row to your Google Sheet at a specific position, optionally copying formatting from the row above to maintain consistent styling.

Create a Google Sheet

Creates a new Google Sheet in your Google Drive with an optional custom name and location. Use this to quickly set up spreadsheets for tracking, analysis, or collaboration without leaving your workflow.

Batch get spreadsheet

Fetch data from multiple cell ranges in a Google Sheet at once, allowing you to quickly gather specific information without retrieving the entire spreadsheet.

Batch update spreadsheet (Deprecated)

Write or append data to a specific location in a Google Sheet, automatically expanding the spreadsheet if needed to accommodate your data. Use this to update existing cells or add new rows of information to your sheets.

Get Spreadsheet by Data Filter

Retrieves specific data from a Google Sheet based on your filtering criteria, such as particular columns, rows, or ranges. This lets you extract only the information you need without having to work with the entire spreadsheet.

Get spreadsheet info

Retrieves metadata and structural information about a Google Spreadsheet, including its ID, title, and sheet properties. This helps you understand and manage your spreadsheet's organization without opening it manually.

Search Spreadsheets

Quickly locate specific Google Sheets across your account by searching for spreadsheet names, content, and other criteria without manually browsing folders.

Update Spreadsheet Properties

Modify the overall configuration of your Google Spreadsheet, including its title, locale, time zone, and auto-recalculation settings to match your business needs and preferences.

Get Table Schema

Analyzes the structure of a Google Sheet table to identify column names, data types, and formatting patterns before performing data operations. This helps ensure accurate data processing and reduces errors when working with spreadsheet data.

List Tables in Spreadsheet

Discover and retrieve all data tables within a Google Spreadsheet by analyzing sheet structure and detecting organized data patterns. This helps you quickly identify where your actual data tables are located, regardless of how sheets are organized.

Query Spreadsheet Table

Execute SQL-like queries against your Google Sheets data to filter, sort, and retrieve specific rows from spreadsheet tables. This helps you quickly extract the information you need without manually scrolling through large datasets.

Get Data Validation Rules

Retrieve all data validation rules from your Google Sheets to understand what values are allowed in each cell, including dropdown lists, number ranges, and custom constraints.

Set Data Validation Rule

Applies validation rules like dropdown lists and custom restrictions to cells in Google Sheets, ensuring data consistency and reducing entry errors across your spreadsheet.

Append Values to Spreadsheet

Adds new rows of data to the end of your Google Sheet without overwriting existing information. Perfect for continuously building datasets like customer records, sales logs, or inventory updates.

Find and Replace in Spreadsheet

Quickly find and replace text, numbers, or formulas across your entire spreadsheet to fix errors, update information, or clean up data in bulk. This saves hours of manual cell-by-cell editing when you need to make consistent changes throughout your sheet.

Batch Clear Spreadsheet Values

Remove data from multiple specific ranges in a spreadsheet while preserving formatting and structure. Use this when you need to clear outdated information, reset sections of a sheet, or prepare data for new entries without losing your sheet design.

Batch Clear Values By Data Filter

Removes cell values from specific rows or columns in a spreadsheet based on filters while preserving all formatting and rules. This helps you quickly clean up data without losing important cell properties.

Batch Get Spreadsheet Values (Deprecated)

Retrieve multiple ranges of data from a Google Sheet in a single request, allowing you to gather scattered information without making separate calls for each data location.

Batch Get Spreadsheet Values by Data Filter

Retrieve specific data from a spreadsheet using custom filters to pull only the information you need without manual searching. This saves time when working with large datasets by automatically extracting rows or columns that match your criteria.

Batch update spreadsheet values

Update multiple cells or ranges across your spreadsheet in a single operation, saving time and reducing manual data entry errors.

Batch Update Values by Data Filter

Updates specific cells in your Google Sheet based on matching criteria, allowing you to change data without knowing exact cell locations. Perfect for updating multiple rows that meet certain conditions all at once.

Clear spreadsheet values

Remove data from specific cells or ranges in your Google Sheet while keeping formatting and notes intact, allowing you to reset content without losing your sheet structure.

Add Sheet to Existing Spreadsheet

Creates a new sheet within an existing spreadsheet, allowing you to add standard grids, charts, or connect to external data sources like BigQuery. This helps you organize different types of data and analyses within a single workbook.

Copy Sheet to Another Spreadsheet

Duplicates a sheet from one spreadsheet into another spreadsheet, allowing you to reuse templates and structures across different projects without manual recreation.

Create sheet from JSON

Creates a new Google Spreadsheet and automatically populates it with data from a JSON structure, using the first item's keys as column headers. This is useful when you need to quickly transform structured data into a spreadsheet without manual formatting.

Delete Sheet

Remove unwanted sheets from your Google Sheets spreadsheet to keep your documents organized and reduce clutter. Use this when you need to delete outdated worksheets or consolidate information across fewer sheets.

Find worksheet by title (Deprecated)

Locates a specific worksheet within a Google Spreadsheet by matching its exact title, useful for automating workflows that need to identify and work with particular sheets.

Get sheet names

Retrieves all worksheet names from a Google Spreadsheet, enabling you to discover and identify sheets before performing operations like reading data or updating content.

Update Sheet Properties

Modify the appearance and settings of individual sheets within your spreadsheet, including names, colors, visibility, and layout properties. Use this to organize your spreadsheets and make them visually distinct for different purposes.

Get spreadsheet values

Returns a range of values from a spreadsheet.

Update spreadsheet values

Tool to set values in a range of a Google Spreadsheet.