NAiOS IconNAiOS Logo
Contacto
Volver al catálogo

Google Sheets

googlesheets

Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps

SpreadsheetsWeb del proveedor
Acciones
36
Triggers
16
Autenticación
—
OAuth gestionado
Sí
Información técnica: el detalle de parámetros, schemas y triggers de esta página está pensado para equipos de integración. Si solo necesitas saber si tu herramienta favorita está disponible, basta con ver la lista de acciones.

Acciones disponibles (36)

Cada acción es una operación que el agente puede ejecutar contra este conector. Haz clic en una acción para ver sus parámetros.

Add Sheet to SpreadsheetGOOGLESHEETS_ADD_SHEETAcción

Adds a new sheet (worksheet) to a spreadsheet. use this tool to create a new tab within an existing google sheet, optionally specifying its title, index, size, and other properties.

Parámetros de entrada

  • propertiesobject

    The properties the new sheet should have. All properties are optional. If none are specified, a default sheet will be created.

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet to add the sheet to. This is the long string of characters in the URL of your Google Sheet.

  • responseIncludeGridDataboolean

    True if grid data should be returned. This parameter is ignored if includeSpreadsheetInResponse is false. Defaults to false.

  • includeSpreadsheetInResponseboolean

    Whether the response should include the entire spreadsheet resource. Defaults to false.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Aggregate Column DataGOOGLESHEETS_AGGREGATE_COLUMN_DATAAcción

Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.

Parámetros de entrada

  • operationstringObligatorioenum

    The mathematical operation to perform on the target column values.

    sumaveragecountminmaxpercentage
  • sheet_namestringObligatorio

    The name of the specific sheet within the spreadsheet.

  • search_valuestringObligatorio

    The exact value to search for in the search column. Case-sensitive by default.

  • search_columnstringObligatorio

    The column to search in. Can be a letter (e.g., 'A', 'B') or column name from header row (e.g., 'Region', 'Department').

  • target_columnstringObligatorio

    The column to aggregate data from. Can be a letter (e.g., 'C', 'D') or column name from header row (e.g., 'Sales', 'Revenue').

  • case_sensitiveboolean

    Whether the search should be case-sensitive.

  • has_header_rowboolean

    Whether the first row contains column headers. If True, column names can be used for search_column and target_column.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Sheets spreadsheet.

  • percentage_totalnumber

    For percentage operation, the total value to calculate percentage against. If not provided, uses sum of all values in target column.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Append DimensionGOOGLESHEETS_APPEND_DIMENSIONAcción

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.

Parámetros de entrada

  • lengthintegerObligatorio

    The number of rows or columns to append.

  • sheet_idintegerObligatorio

    The ID of the sheet to append rows or columns to.

  • dimensionstringObligatorioenum

    Specifies whether to append rows or columns.

    ROWSCOLUMNS
  • spreadsheet_idstringObligatorio

    The ID of the spreadsheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Batch get spreadsheetGOOGLESHEETS_BATCH_GETAcción

Retrieves data from specified cell ranges in a google spreadsheet; ensure the spreadsheet has at least one worksheet and any explicitly referenced sheet names in ranges exist.

Parámetros de entrada

  • rangesstring[]

    A list of cell ranges in A1 notation (e.g., 'Sheet1!A1:B2', 'A1:C5') from which to retrieve data. If this list is omitted or empty, all data from the first sheet of the spreadsheet will be fetched. A range can specify a sheet name (e.g., 'Sheet2!A:A'); if no sheet name is provided in a range string (e.g., 'A1:B2'), it defaults to the first sheet.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet from which data will be retrieved.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Batch update spreadsheetGOOGLESHEETS_BATCH_UPDATEAcción

Updates a specified range in a google sheet with given values, or appends them as new rows if `first cell location` is omitted; ensure the target sheet exists and the spreadsheet contains at least one worksheet.

Parámetros de entrada

  • valuesarray[]Obligatorio

    A 2D list of cell values. Each inner list represents a row. Values can be strings, numbers, or booleans. Ensure columns are properly aligned across rows.

  • sheet_namestringObligatorio

    The name of the specific sheet within the spreadsheet to update.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Sheets spreadsheet to be updated.

  • valueInputOptionstringenum

    How input data is interpreted. 'USER_ENTERED': Values parsed as if typed by a user (e.g., strings may become numbers/dates, formulas are calculated); recommended for formulas. 'RAW': Values stored as-is without parsing (e.g., '123' stays string, '=SUM(A1:B1)' stays string).

    RAWUSER_ENTERED
  • first_cell_locationstring

    The starting cell for the update range, specified in A1 notation (e.g., 'A1', 'B2'). The update will extend from this cell to the right and down, based on the provided values. If omitted, values are appended to the sheet.

  • includeValuesInResponseboolean

    If set to True, the response will include the updated values from the spreadsheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Batch Update Values by Data FilterGOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTERAcción

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

Parámetros de entrada

  • dataobject[]Obligatorio

    The new values to apply to the spreadsheet. If more than one range is matched by the specified DataFilter the specified values are applied to all of those ranges.

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet to update.

  • valueInputOptionstringObligatorioenum

    How the input data should be interpreted.

    RAWUSER_ENTERED
  • includeValuesInResponseboolean

    Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values.

  • responseValueRenderOptionstringenum

    Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE.

    FORMATTED_VALUEUNFORMATTED_VALUEFORMULA
  • responseDateTimeRenderOptionstringenum

    Determines how dates, times, and durations in the response should be rendered. This is ignored if responseValueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.

    SERIAL_NUMBERFORMATTED_STRING

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Clear Basic FilterGOOGLESHEETS_CLEAR_BASIC_FILTERAcción

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.

Parámetros de entrada

  • sheet_idintegerObligatorio

    The ID of the sheet on which the basic filter should be cleared.

  • spreadsheet_idstringObligatorio

    The ID of the spreadsheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Clear spreadsheet valuesGOOGLESHEETS_CLEAR_VALUESAcción

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

Parámetros de entrada

  • rangestringObligatorio

    The A1 notation of the range to clear values from (e.g., 'Sheet1!A1:B2', 'MySheet!C:C', or 'A1:D5'). If the sheet name is omitted (e.g., 'A1:B2'), the operation applies to the first visible sheet.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet from which to clear values. This ID can be found in the URL of the spreadsheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create Chart in Google SheetsGOOGLESHEETS_CREATE_CHARTAcción

Create a chart in a google sheets spreadsheet using the specified data range and chart type.

Parámetros de entrada

  • titlestring

    Optional title for the chart.

  • sheet_idinteger

    The ID of the sheet within the spreadsheet where the chart will be created. Defaults to 0 (first sheet).

  • subtitlestring

    Optional subtitle for the chart.

  • chart_typestringObligatorio

    The type of chart to create. Supported types: BAR, LINE, AREA, COLUMN, SCATTER, COMBO, STEPPED_AREA.

  • data_rangestringObligatorio

    The range of data to use for the chart in A1 notation (e.g., 'A1:C10').

  • x_axis_titlestring

    Optional title for the X-axis.

  • y_axis_titlestring

    Optional title for the Y-axis.

  • background_rednumber

    Red component of chart background color (0.0-1.0). If not specified, uses default.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Sheets spreadsheet where the chart will be created.

  • background_bluenumber

    Blue component of chart background color (0.0-1.0). If not specified, uses default.

  • legend_positionstring

    Position of the chart legend. Options: BOTTOM_LEGEND, TOP_LEGEND, LEFT_LEGEND, RIGHT_LEGEND, NO_LEGEND.

  • background_greennumber

    Green component of chart background color (0.0-1.0). If not specified, uses default.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create a Google SheetGOOGLESHEETS_CREATE_GOOGLE_SHEET1Acción

Creates a new google spreadsheet in google drive using the provided title.

Parámetros de entrada

  • titlestringObligatorio

    The title for the new Google Sheet. This will be the name of the file in Google Drive.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create spreadsheet columnGOOGLESHEETS_CREATE_SPREADSHEET_COLUMNAcción

Creates a new column in a google spreadsheet, requiring a valid `spreadsheet id` and an existing `sheet id`; an out-of-bounds `insert index` may append/prepend the column.

Parámetros de entrada

  • sheet_idintegerObligatorio

    The numeric identifier of the specific sheet (tab) within the spreadsheet where the column will be added.

  • insert_indexinteger

    The 0-based index at which the new column will be inserted. For example, an index of 0 inserts the column before the current first column (A), and an index of 1 inserts it between the current columns A and B.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet where the column will be created.

  • inherit_from_beforeboolean

    If true, the new column inherits properties (e.g., formatting, width) from the column immediately to its left (the preceding column). If false (default), it inherits from the column immediately to its right (the succeeding column). This is ignored if there is no respective preceding or succeeding column.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create spreadsheet rowGOOGLESHEETS_CREATE_SPREADSHEET_ROWAcción

Inserts a new, empty row into a specified sheet of a google spreadsheet at a given index, optionally inheriting formatting from the row above.

Parámetros de entrada

  • sheet_idintegerObligatorio

    The numeric identifier of the sheet (tab) within the spreadsheet where the row will be inserted. This ID (gid) is found in the URL of the spreadsheet (e.g., '0' for the first sheet).

  • insert_indexinteger

    The 0-based index at which the new row should be inserted. For example, an index of 0 inserts the row at the beginning of the sheet. If the index is greater than the current number of rows, the row is appended.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet. This ID is found in the URL of the spreadsheet (e.g., '1qpyC0XzHc_-_d824s2VfopkHh7D0jW4aXCS1D_AlGA').

  • inherit_from_beforeboolean

    If True, the newly inserted row will inherit formatting and properties from the row immediately preceding its insertion point. If False, it will have default formatting.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Delete Dimension (Rows/Columns)GOOGLESHEETS_DELETE_DIMENSIONAcción

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.

Parámetros de entrada

  • spreadsheet_idstringObligatorio

    The ID of the spreadsheet.

  • response_rangesstring[]

    Limits the ranges of cells included in the response spreadsheet.

  • delete_dimension_requestobjectObligatorio

    The details for the delete dimension request object.

  • response_include_grid_databoolean

    True if grid data should be returned. This parameter is ignored if a field mask was set in the request.

  • include_spreadsheet_in_responseboolean

    Determines if the update response should include the spreadsheet resource.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Delete SheetGOOGLESHEETS_DELETE_SHEETAcción

Tool to delete a sheet (worksheet) from a spreadsheet. use when you need to remove a specific sheet from a google sheet document.

Parámetros de entrada

  • sheet_idintegerObligatorio

    The ID of the sheet to delete. If the sheet is of DATA_SOURCE type, the associated DataSource is also deleted.

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet from which to delete the sheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Execute SQL on SpreadsheetGOOGLESHEETS_EXECUTE_SQLAcción

Execute sql queries against google sheets tables. supports select, insert, update, and delete operations with familiar sql syntax. tables are automatically detected and mapped from the spreadsheet structure.

Parámetros de entrada

  • sqlstringObligatorio

    SQL query to execute. Supports SELECT, INSERT, UPDATE, DELETE operations.

  • dry_runboolean

    Preview changes without applying them (for write operations)

  • delete_methodstringenum

    For DELETE operations: 'clear' preserves row structure, 'remove_rows' shifts data up

    clearremove_rows
  • spreadsheet_idstringObligatorio

    Google Sheets ID

Parámetros de salida

  • dataobject[]

    Result data for SELECT queries

  • errorstring

    Error if any occurred during the execution of the action

  • messagestringObligatorio

    Human-readable result message

  • operationstringObligatorio

    SQL operation performed: SELECT, INSERT, UPDATE, or DELETE

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

  • table_schemaobject[]

    Schema for SELECT query results

  • affected_rowsintegerObligatorio

    Number of rows affected by the operation

Find worksheet by titleGOOGLESHEETS_FIND_WORKSHEET_BY_TITLEAcción

Finds a worksheet by its exact, case-sensitive title within a google spreadsheet; returns a boolean indicating if found and the complete metadata of the entire spreadsheet, regardless of whether the target worksheet is found.

Parámetros de entrada

  • titlestringObligatorio

    The exact, case-sensitive title of the worksheet (tab name) to find.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet. This ID is part of the spreadsheet's URL.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Format cellGOOGLESHEETS_FORMAT_CELLAcción

Applies text and background cell formatting to a specified range in a google sheets worksheet.

Parámetros de entrada

  • rednumber

    Red component of the background color (0.0-1.0).

  • bluenumber

    Blue component of the background color (0.0-1.0).

  • boldboolean

    Apply bold formatting.

  • greennumber

    Green component of the background color (0.0-1.0).

  • italicboolean

    Apply italic formatting.

  • fontSizeinteger

    Font size in points.

  • underlineboolean

    Apply underline formatting.

  • worksheet_idintegerObligatorio

    ID (sheetId) of the worksheet. Use `GOOGLESHEETS_GET_SPREADSHEET_INFO` to find this ID.

  • end_row_indexintegerObligatorio

    0-based index of the row *after* the last row in the range (exclusive); must be greater than `start_row_index`.

  • strikethroughboolean

    Apply strikethrough formatting.

  • spreadsheet_idstringObligatorio

    Identifier of the Google Sheets spreadsheet.

  • start_row_indexintegerObligatorio

    0-based index of the first row in the range.

  • end_column_indexintegerObligatorio

    0-based index of the column *after* the last column in the range (exclusive); must be greater than `start_column_index`.

  • start_column_indexintegerObligatorio

    0-based index of the first column in the range.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get sheet namesGOOGLESHEETS_GET_SHEET_NAMESAcción

Lists all worksheet names from a specified google spreadsheet (which must exist), useful for discovering sheets before further operations.

Parámetros de entrada

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet. This ID is typically found in the spreadsheet's URL.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Spreadsheet by Data FilterGOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTERAcción

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.

Parámetros de entrada

  • dataFiltersobject[]Obligatorio

    The DataFilters used to select which ranges to retrieve.

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet to request.

  • includeGridDataboolean

    True if grid data should be returned. Ignored if a field mask is set.

  • excludeTablesInBandedRangesboolean

    True if tables should be excluded in the banded ranges. False if not set.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get spreadsheet infoGOOGLESHEETS_GET_SPREADSHEET_INFOAcción

Retrieves comprehensive metadata for a google spreadsheet using its id, excluding cell data.

Parámetros de entrada

  • spreadsheet_idstringObligatorio

    Unique identifier of the Google Spreadsheet, typically found in its URL.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Table SchemaGOOGLESHEETS_GET_TABLE_SCHEMAAcción

This action is used to get the schema of a table in a google spreadsheet, call this action to get the schema of a table in a spreadsheet before you query the table. analyze table structure and infer column names, types, and constraints. uses statistical analysis of sample data to determine the most likely data type for each column. call this action after calling the list tables action to get the schema of a table in a spreadsheet.

Parámetros de entrada

  • sheet_namestring

    Sheet/tab name if table_name is ambiguous across multiple sheets

  • table_namestringObligatorio

    Specific table name from LIST_TABLES response (e.g., 'Sales_Data', 'Employee_List'). Use 'auto' to analyze the largest/most prominent table.

  • sample_sizeinteger

    Number of rows to sample for type inference

  • spreadsheet_idstringObligatorio

    Google Sheets ID

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Insert Dimension in Google SheetGOOGLESHEETS_INSERT_DIMENSIONAcción

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.

Parámetros de entrada

  • spreadsheet_idstringObligatorio

    The ID of the spreadsheet to update.

  • response_rangesstring[]

    Limits the ranges of the spreadsheet to include in the response.

  • insert_dimensionobjectObligatorio

    The details for the insert dimension request.

  • response_include_grid_databoolean

    True if grid data should be included in the response (if includeSpreadsheetInResponse is true).

  • include_spreadsheet_in_responseboolean

    True if the updated spreadsheet should be included in the response.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List Tables in SpreadsheetGOOGLESHEETS_LIST_TABLESAcción

This action is used to list all tables in a google spreadsheet, call this action to get the list of tables in a spreadsheet. discover all tables in a google spreadsheet by analyzing sheet structure and detecting data patterns. uses heuristic analysis to find header rows, data boundaries, and table structures.

Parámetros de entrada

  • min_rowsinteger

    Minimum number of data rows to consider a valid table

  • min_columnsinteger

    Minimum number of columns to consider a valid table

  • min_confidencenumber

    Minimum confidence score (0.0-1.0) to consider a valid table

  • spreadsheet_idstringObligatorio

    Google Sheets ID from the URL (e.g., '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms')

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Look up spreadsheet rowGOOGLESHEETS_LOOKUP_SPREADSHEET_ROWAcción

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

Parámetros de entrada

  • querystringObligatorio

    Exact text value to find; matches the entire content of a cell in a row.

  • rangestring

    A1 notation of the range to search (e.g., 'Sheet1!A1:D5', 'MySheet!A:Z', or 'Sheet1'). Defaults to the non-empty part of the first sheet. For multiple sheets, include sheet name (e.g., 'SheetName!A1:Z100').

  • case_sensitiveboolean

    If `True`, the query string search is case-sensitive.

  • spreadsheet_idstringObligatorio

    Identifier of the Google Spreadsheet to search.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Query Spreadsheet TableGOOGLESHEETS_QUERY_TABLEAcción

This action is used to query a table in a google spreadsheet, call this action to query a table in a spreadsheet. execute sql-like select queries against spreadsheet tables. supports where conditions, order by, limit clauses. call this action after calling the get table schema action to query a table in a spreadsheet.

Parámetros de entrada

  • sqlstringObligatorio

    SQL SELECT query. Supported: SELECT cols FROM table WHERE conditions ORDER BY col LIMIT n. Table names must be quoted if they contain spaces.

  • spreadsheet_idstringObligatorio

    Google Sheets ID

  • include_formulasboolean

    Whether to return formula text instead of calculated values for formula columns

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Search Developer MetadataGOOGLESHEETS_SEARCH_DEVELOPER_METADATAAcción

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

Parámetros de entrada

  • dataFiltersobject[]Obligatorio

    The data filters describing the criteria used to determine which DeveloperMetadata entries to return.

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet to retrieve metadata from.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Search SpreadsheetsGOOGLESHEETS_SEARCH_SPREADSHEETSAcción

Search for google spreadsheets using various filters including name, content, date ranges, and more.

Parámetros de entrada

  • querystring

    Search query to filter spreadsheets. Can search by name (name contains 'budget'), full text content (fullText contains 'sales'), or use complex queries with operators like 'and', 'or', 'not'. Leave empty to get all spreadsheets.

  • order_bystring

    Order results by field. Common options: 'modifiedTime desc', 'modifiedTime asc', 'name', 'createdTime desc'

  • max_resultsinteger

    Maximum number of spreadsheets to return (1-1000). Defaults to 10.

  • starred_onlyboolean

    Whether to return only starred spreadsheets. Defaults to False.

  • created_afterstring

    Return spreadsheets created after this date. Use RFC 3339 format like '2024-01-01T00:00:00Z'.

  • modified_afterstring

    Return spreadsheets modified after this date. Use RFC 3339 format like '2024-01-01T00:00:00Z'.

  • shared_with_meboolean

    Whether to return only spreadsheets shared with the current user. Defaults to False.

  • include_trashedboolean

    Whether to include spreadsheets in trash. Defaults to False.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Set Basic FilterGOOGLESHEETS_SET_BASIC_FILTERAcción

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

Parámetros de entrada

  • filterobjectObligatorio

    The filter to set.

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create sheet from JSONGOOGLESHEETS_SHEET_FROM_JSONAcción

Creates a new google spreadsheet and populates its first worksheet from `sheet json`, which must be non-empty as its first item's keys establish the headers.

Parámetros de entrada

  • titlestringObligatorio

    The desired title for the new Google Spreadsheet.

  • sheet_jsonobject[]Obligatorio

    A list of dictionaries representing the rows of the sheet. Each dictionary must have the same set of keys, which will form the header row. Values can be strings, numbers, booleans, or null (represented as empty cells).

  • sheet_namestringObligatorio

    The name for the first worksheet within the newly created spreadsheet. This name will appear as a tab at the bottom of the sheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Copy Sheet to Another SpreadsheetGOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TOAcción

Tool to copy a single sheet from a spreadsheet to another spreadsheet. use when you need to duplicate a sheet into a different spreadsheet.

Parámetros de entrada

  • sheet_idintegerObligatorio

    The ID of the sheet to copy.

  • spreadsheet_idstringObligatorio

    The ID of the spreadsheet containing the sheet to copy.

  • destination_spreadsheet_idstringObligatorio

    The ID of the spreadsheet to copy the sheet to.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Append Values to SpreadsheetGOOGLESHEETS_SPREADSHEETS_VALUES_APPENDAcción

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

Parámetros de entrada

  • rangestringObligatorio

    The A1 notation of a range to search for a logical table of data. Values are appended after the last row of the table.

  • valuesarray[]Obligatorio

    The data to be written. This is an array of arrays, the outer array representing all the data and each inner array representing a major dimension. Each item in the inner array corresponds with one cell.

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet to update.

  • majorDimensionstringenum

    The major dimension of the values. For output, if the spreadsheet data is: A1=1,B1=2,A2=3,B2=4, then requesting range=A1:B2,majorDimension=ROWS will return [[1,2],[3,4]], whereas requesting range=A1:B2,majorDimension=COLUMNS will return [[1,3],[2,4]].

    ROWSCOLUMNS
  • insertDataOptionstringenum

    How the input data should be inserted.

    OVERWRITEINSERT_ROWS
  • valueInputOptionstringObligatorioenum

    How the input data should be interpreted.

    RAWUSER_ENTERED
  • includeValuesInResponseboolean

    Determines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values.

  • responseValueRenderOptionstringenum

    Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE.

    FORMATTED_VALUEUNFORMATTED_VALUEFORMULA
  • responseDateTimeRenderOptionstringenum

    Determines how dates, times, and durations in the response should be rendered. This is ignored if responseValueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.

    SERIAL_NUMBERFORMATTED_STRING

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Batch Clear Spreadsheet ValuesGOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEARAcción

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

Parámetros de entrada

  • rangesstring[]Obligatorio

    The ranges to clear, in A1 notation or R1C1 notation.

  • spreadsheet_idstringObligatorio

    The ID of the spreadsheet to update.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Batch Clear Values By Data FilterGOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR_BY_DATA_FILTERAcción

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.

Parámetros de entrada

  • dataFiltersobject[]Obligatorio

    The DataFilters used to determine which ranges to clear.

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet to update.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Batch Get Spreadsheet Values by Data FilterGOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTERAcción

Tool 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 sheets or fixed ranges.

Parámetros de entrada

  • dataFiltersobject[]Obligatorio

    The data filters used to match the ranges of values to retrieve. Ranges that match any of the specified data filters are included in the response.

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet to retrieve data from.

  • majorDimensionstringenum

    The major dimension that results should use. For example, if the spreadsheet data is: A1=1,B1=2,A2=3,B2=4, then a request that selects that range and sets majorDimension=ROWS returns [[1,2],[3,4]], whereas a request that sets majorDimension=COLUMNS returns [[1,3],[2,4]].

    ROWSCOLUMNS
  • valueRenderOptionstringenum

    How values should be represented in the output. The default render option is FORMATTED_VALUE.

    FORMATTED_VALUEUNFORMATTED_VALUEFORMULA
  • dateTimeRenderOptionstringenum

    How dates, times, and durations should be represented in the output. This is ignored if valueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.

    SERIAL_NUMBERFORMATTED_STRING

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update Sheet PropertiesGOOGLESHEETS_UPDATE_SHEET_PROPERTIESAcción

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

Parámetros de entrada

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet containing the sheet to update.

  • updateSheetPropertiesobjectObligatorio

    The details of the sheet properties to update.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update Spreadsheet PropertiesGOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIESAcción

Tool to update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings. use when you need to modify the overall configuration of a google sheet.

Parámetros de entrada

  • fieldsstringObligatorio

    The fields that should be updated. Use '*' for all fields in 'properties' or a comma-separated list (e.g., 'title,locale,iterativeCalculationSettings.maxIterations'). The root 'properties' is implied.

  • propertiesobjectObligatorio

    The properties to update. At least one field within properties must be set.

  • spreadsheetIdstringObligatorio

    The ID of the spreadsheet to update.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Triggers (16)

Los triggers son eventos externos que pueden iniciar un flujo en tus agentes (ej: nuevo email, mensaje recibido, registro creado).

Aggregate Metric ChangedGOOGLESHEETS_AGGREGATE_METRIC_CHANGED_TRIGGERTrigger

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.

Configuración

  • case_sensitiveboolean

    Whether the search should be case-sensitive when filtering by search_column and search_value.

  • has_header_rowboolean

    Whether the first row contains column headers. If True, column names can be used for search_column and target_column.

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • operationstringObligatorio

    The mathematical operation to perform on the target column values. Supported operations: sum, average, count, min, max, percentage.

  • percentage_totalnumber

    For percentage operation, the total value to calculate percentage against. If not provided, uses sum of all values in target column.

  • search_columnstring

    The column to search in for filtering rows. Can be a letter (e.g., 'A', 'B') or column name from header row (e.g., 'Region', 'Department'). If not provided, all rows in the target column will be aggregated without filtering.

  • search_valuestring

    The exact value to search for in the search column. Case-sensitive by default. If not provided (or if search_column is not provided), all rows in the target column will be aggregated without filtering.

  • sheet_namestringObligatorio

    The name of the specific sheet within the spreadsheet to monitor. Matching is case-insensitive. If no exact match is found, partial matches will be attempted (e.g., 'overview' will match 'Overview 2025').

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Sheets spreadsheet to monitor. This is the long alphanumeric string found in the spreadsheet URL between '/d/' and '/edit'.

  • target_columnstringObligatorio

    The column to aggregate data from. Can be a letter (e.g., 'C', 'D') or column name from header row (e.g., 'Sales', 'Revenue').

Payload del evento

  • current_resultnumberObligatorio

    The current aggregate metric value

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • event_typestring

    Type of event that occurred

  • matching_rows_countintegerObligatorio

    Number of rows that matched the search condition

  • operationstringObligatorio

    The aggregation operation performed

  • previous_resultnumberObligatorio

    The previous aggregate metric value

  • processed_values_countintegerObligatorio

    Number of values that were processed in the aggregation

  • search_detailsobjectObligatorio

    Details of the search/filter used to select rows prior to aggregation

  • sheet_namestringObligatorio

    The sheet name

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

Instrucciones

**Aggregate Metric Changed in Google Sheets (Polling):** - Monitors an aggregate metric (SUM, COUNT, AVERAGE, MIN, MAX, PERCENTAGE) in a Google Sheet - Detects when the calculated aggregate value changes between polls - Configure spreadsheet ID, sheet name, target column, and operation type - Optionally filter rows using search_column and search_value before aggregation - Emits events with both previous and current aggregate values when changes are detected - Uses snapshot-based diffing to detect changes between polls - Useful for monitoring totals, counts, averages, or other aggregate calculations

Cell Range Values ChangedGOOGLESHEETS_CELL_RANGE_VALUES_CHANGED_TRIGGERTrigger

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.

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • rangestringObligatorio

    The A1 notation of the range to monitor for changes (can be a single cell or multi-cell range). If the sheet name contains spaces or special characters, wrap the sheet name in single quotes.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor. This is the long alphanumeric string found in the spreadsheet URL between '/d/' and '/edit'.

Payload del evento

  • current_valuesarray[]Obligatorio

    The current values in the range

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • event_typestring

    Type of event that occurred

  • previous_valuesarray[]Obligatorio

    The previous values in the range

  • rangestringObligatorio

    The A1 notation of the monitored range

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

Instrucciones

**Cell Range Values Changed in Google Sheets (Polling):** - Monitors a specific cell or range of cells in a Google Sheet for value changes - Detects any changes to the values in the specified range - Configure spreadsheet ID and the A1 notation range to monitor - Can monitor single cells (e.g., 'A1') or multi-cell ranges (e.g., 'A1:E10') - Emits events with both previous and current values when changes are detected - Uses snapshot-based diffing to detect changes between polls

Conditional Format Rule ChangedGOOGLESHEETS_CONDITIONAL_FORMAT_RULE_CHANGED_TRIGGERTrigger

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.

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • sheet_idinteger

    Optional filter: monitor only the sheet with this exact numeric sheetId. If not provided, monitors all sheets. If both sheet_title and sheet_id are provided, sheet_id takes precedence.

  • sheet_titlestring

    Optional filter: monitor only the sheet with this exact title. If not provided, monitors all sheets.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor for conditional formatting rule changes

Payload del evento

  • change_typestringObligatorio

    Type of change: 'added', 'updated', or 'removed'

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • rulesobject[]Obligatorio

    List of rules that changed

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

Instrucciones

**Conditional Format Rule Changed in Google Sheets (Polling):** - Monitors a specific Google Spreadsheet for changes to conditional formatting rules - Detects when rules are added, updated, or removed - Configure spreadsheet ID and optional sheet filters to scope the monitoring - Supports filtering by sheet title or sheet ID - Emits separate events for added, updated, and removed rules - Uses snapshot-based diffing to detect changes between polls - State is bounded to prevent unbounded growth

Data Validation Rule ChangedGOOGLESHEETS_DATA_VALIDATION_RULE_CHANGED_TRIGGERTrigger

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

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • rangesstring[]

    Optional list of A1 ranges to monitor. If omitted, the entire sheet(s) will be monitored.

  • sheet_idinteger

    Optional sheet ID to filter by. If omitted, all sheets will be monitored.

  • sheet_titlestring

    Optional sheet title to filter by. If omitted, all sheets will be monitored.

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor for data validation rule changes.

Payload del evento

  • change_typestringObligatorio

    Type of change: 'added', 'updated', or 'removed'

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • rulesobject[]Obligatorio

    List of validation rules that changed

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

Instrucciones

**Data Validation Rule Changed in Google Sheets (Polling):** - Monitors a specific Google Spreadsheet for changes to data validation rules - Detects when validation rules are added, updated, or removed - Configure spreadsheet ID and optional sheet title, sheet ID, or ranges to scope the monitoring - Emits separate events for added, updated, and removed validation rules - Uses snapshot-based diffing with rule content hashing to detect changes - State is bounded to prevent unbounded growth

Developer Metadata ChangedGOOGLESHEETS_DEVELOPER_METADATA_CHANGED_TRIGGERTrigger

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

Configuración

  • data_filtersobject[]

    The data filters describing the criteria used to determine which DeveloperMetadata entries to monitor. If not specified, monitors all developer metadata.

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor for developer metadata changes.

Payload del evento

  • change_typestringObligatorio

    Type of change: 'created', 'updated', or 'removed'

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • metadata_itemsobject[]Obligatorio

    List of metadata items that changed

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

Instrucciones

**Developer Metadata Changed in Google Sheets (Polling):** - Monitors a specific Google Spreadsheet for changes to developer metadata entries - Detects when metadata is created, updated, or removed - Configure spreadsheet ID and optional data filters to scope the monitoring - Supports filtering by metadata ID, A1 range, or grid range - Emits separate events for created, updated, and removed metadata entries - Uses snapshot-based diffing to detect changes between polls - State is bounded to prevent unbounded growth

Filtered Range Values ChangedGOOGLESHEETS_FILTERED_RANGE_VALUES_CHANGED_TRIGGERTrigger

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.

Configuración

  • data_filtersobject[]Obligatorio

    List of data filters specifying which ranges to monitor for changes. Each filter can specify either 'a1Range' (e.g., 'Sheet1!A1:B10') or 'gridRange'.

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • major_dimensionstringenum

    The major dimension that results should use. ROWS returns [[1,2],[3,4]], COLUMNS returns [[1,3],[2,4]]

    ROWSCOLUMNS
  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor

  • value_render_optionstringenum

    How values should be represented in the output

    FORMATTED_VALUEUNFORMATTED_VALUEFORMULA

Payload del evento

  • change_typestringObligatorioenum

    Type of change detected

    createdupdateddeleted
  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • new_valuesarray[]Obligatorio

    Current values in the range

  • old_valuesarray[]

    Previous values in the range (None if new)

  • range_identifierstringObligatorio

    The A1 notation or identifier of the range that changed

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

Instrucciones

**Filtered Range Values Changed (Polling):** - Monitors specific ranges in a Google Spreadsheet for value changes - Uses data filters to specify which ranges to monitor (A1 notation or grid ranges) - Detects created, updated, or deleted values in the monitored ranges - Returns the old and new values when changes are detected - Supports multiple ranges to monitor simultaneously - Perfect for triggering workflows when specific cells or ranges are modified

New Rows in Google SheetGOOGLESHEETS_NEW_ROWS_TRIGGERTrigger

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.

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • sheet_namestring

    The name of the specific sheet within the spreadsheet to monitor

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor

  • start_rowinteger

    The row number to start monitoring from (1-indexed, typically 2 to skip headers)

Payload del evento

  • detected_atstringObligatorio

    ISO timestamp when the row was detected

  • row_datastring[]Obligatorio

    Complete row data as list of strings

  • row_numberintegerObligatorio

    The row number in the sheet (1-indexed)

  • sheet_namestringObligatorio

    The sheet name

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

Instrucciones

**New Rows in Google Sheet (Polling):** - Monitors a Google Sheet for new rows added - Returns complete row data for each new entry detected - Configure sheet ID, sheet name, and starting row - Perfect for triggering workflows on new data entries - Set start_row to 2 if your sheet has headers

New Sheet Added in Google SpreadsheetGOOGLESHEETS_NEW_SHEET_ADDED_TRIGGERTrigger

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

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor

Payload del evento

  • detected_atstringObligatorio

    ISO timestamp when the new sheet was detected

  • sheet_namestringObligatorio

    The name of the new sheet added

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

Instrucciones

**New Sheet Added in Google Spreadsheet (Polling):** - Monitors a Google Spreadsheet for new worksheets added - Returns the name of each new sheet detected - Configure the spreadsheet ID to monitor - On the first run, the trigger initializes state without emitting any events

New Spreadsheet CreatedGOOGLESHEETS_NEW_SPREADSHEET_CREATED_TRIGGERTrigger

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.

Configuración

  • include_shared_drivesboolean

    Whether to include spreadsheets from shared drives you have access to. Defaults to True.

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • max_resultsinteger

    Maximum number of spreadsheets to check in each poll (1-1000)

  • querystring

    Optional search query to filter spreadsheets. Can search by name (name contains 'Budget'), full text content (fullText contains 'sales'), or use complex queries with operators. Leave empty to monitor all spreadsheets.

Payload del evento

  • event_typestring

    Type of event that occurred

  • spreadsheetobjectObligatorio

    The newly created Google Spreadsheet

Instrucciones

**Instructions for Setting Up the Trigger:** - This trigger monitors Google Drive for newly created spreadsheets. - You can optionally provide a search query to filter which spreadsheets to monitor. - The trigger will detect spreadsheets created after the trigger is set up. - Use max_results to control how many spreadsheets to check in each poll (default: 10). - Set include_shared_drives to include or exclude spreadsheets from shared/team drives. - Examples of search queries: - name contains 'Budget' - Monitor spreadsheets with 'Budget' in the name - fullText contains 'quarterly' - Monitor spreadsheets containing 'quarterly' - Leave query empty to monitor all new spreadsheets

Spreadsheet Metadata ChangedGOOGLESHEETS_SPREADSHEET_METADATA_CHANGED_TRIGGERTrigger

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.

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor for metadata changes

Payload del evento

  • changesobject[]Obligatorio

    List of metadata changes detected

  • current_metadataobjectObligatorio

    Current metadata snapshot

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

  • spreadsheet_urlstring

    URL to view the spreadsheet

Instrucciones

**Spreadsheet Metadata Changed (Polling):** - Monitors a specific Google Spreadsheet for any metadata changes - Detects changes to: properties (title, locale, timeZone, etc.), sheets, named ranges, developer metadata, data sources - Returns detailed information about which fields changed and their old/new values - Configure with the spreadsheet ID to monitor - On first run, initializes state without emitting events

Spreadsheet Properties ChangedGOOGLESHEETS_SPREADSHEET_PROPERTIES_CHANGED_TRIGGERTrigger

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

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor for property changes

Payload del evento

  • changed_propertiesobject[]Obligatorio

    List of properties that changed

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

  • spreadsheet_urlstring

    URL to view the spreadsheet

Instrucciones

**Spreadsheet Properties Changed (Polling):** - Monitors a specific Google Spreadsheet for changes to its top-level properties - Detects changes to: title, locale, timeZone, autoRecalc - Returns details of which properties changed and their old/new values - Configure with the spreadsheet ID to monitor - On first run, initializes state without emitting events

Spreadsheet Row ChangedGOOGLESHEETS_SPREADSHEET_ROW_CHANGED_TRIGGERTrigger

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.

Configuración

  • case_sensitiveboolean

    If `True`, the query string search is case-sensitive.

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • normalize_whitespaceboolean

    If `True`, strips leading and trailing whitespace from cell values before matching. This helps match cells like ' TOTAL ' or 'TOTAL ' when searching for 'TOTAL'.

  • querystringObligatorio

    Exact text value to find; matches the entire content of a cell in a row.

  • rangestring

    A1 notation range to search within. Supports cell ranges (e.g., 'Sheet1!A1:D5'), column-only ranges (e.g., 'Sheet1!A:Z'), and row-only ranges (e.g., 'Sheet1!1:1'). Defaults to the first sheet if omitted. IMPORTANT: Sheet names with spaces must be single-quoted (e.g., "'My Sheet'!A1:Z"). Bare sheet names without ranges (e.g., 'Sheet1') are not supported - always specify a range.

  • spreadsheet_idstringObligatorio

    Identifier of the Google Spreadsheet to monitor.

Payload del evento

  • change_typestringObligatorio

    Type of change: 'created' (row appeared), 'updated' (row values changed), or 'deleted' (row disappeared)

  • current_row_dataanyObligatorio

    The current row data (empty dict if row is not found now)

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • event_typestring

    Type of event that occurred

  • previous_row_dataanyObligatorio

    The previous row data (empty dict if row was not found before)

  • querystringObligatorio

    The query used to find the row

  • rangestring

    The A1 notation range that was searched

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

Instrucciones

**Spreadsheet Row Changed in Google Sheets (Polling):** - Monitors a specific row in a Google Sheet that is located by searching for a query value - Detects when the row's values change, when the row appears, or when the row disappears - Configure the spreadsheet ID, optional A1 notation range to search within, and the query to find the row - The trigger will search for rows where any cell exactly matches the query value - Emits events with both previous and current row data when changes are detected - Change types: - 'created': The row matching the query was not found before but is found now - 'updated': The row was found before and is found now, but the values have changed - 'deleted': The row was found before but is not found now - Uses snapshot-based diffing to detect changes between polls

Spreadsheet Search MatchGOOGLESHEETS_SPREADSHEET_SEARCH_MATCH_TRIGGERTrigger

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.

Configuración

  • created_afterstring

    Return spreadsheets created after this date. Use RFC 3339 format like '2024-01-01T00:00:00Z'.

  • include_shared_drivesboolean

    Whether to include spreadsheets from shared drives you have access to. Defaults to True.

  • include_trashedboolean

    Whether to include spreadsheets in trash. Defaults to False.

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • max_resultsinteger

    Maximum number of spreadsheets to check in each poll (1-100)

  • modified_afterstring

    Return spreadsheets modified after this date. Use RFC 3339 format like '2024-01-01T00:00:00Z'.

  • order_bystring

    Order results by field. Common options: 'modifiedTime desc', 'modifiedTime asc', 'name', 'createdTime desc'

  • querystring

    Search query to filter spreadsheets. Behavior depends on the 'search_type' parameter. For advanced searches, use Google Drive query syntax with fields like 'name contains', 'fullText contains', or boolean filters like 'sharedWithMe = true'. DO NOT use spreadsheet IDs as search terms. Leave empty to get all spreadsheets.

  • search_typestringenum

    How to search: 'name' searches filenames only (prefix matching from the START of filenames), 'content' uses fullText search which searches file content, name, description, and metadata, 'both' explicitly searches both name OR content with an OR condition.

    namecontentboth
  • shared_with_meboolean

    Whether to return only spreadsheets shared with the current user. Defaults to False.

  • starred_onlyboolean

    Whether to return only starred spreadsheets. Defaults to False.

Payload del evento

  • event_typestring

    Type of event that occurred

  • spreadsheetobjectObligatorio

    The spreadsheet that matches the search criteria

Instrucciones

**Instructions for Setting Up the Trigger:** - This trigger monitors Google Drive for spreadsheets that match a specific search query. - When a new spreadsheet appears that matches your search criteria, the trigger fires. - Configure the search using the 'query' and 'search_type' parameters. - The trigger detects spreadsheets that: 1. Are newly created and match the search criteria 2. Become visible to you (e.g., shared with you) and match the search criteria 3. Are modified to match the search criteria (e.g., renamed) - Use max_results to control how many spreadsheets to check in each poll (default: 10). - Set include_shared_drives to include or exclude spreadsheets from shared/team drives. - Examples of search queries: - query='Budget Report', search_type='name' - Monitor spreadsheets with 'Budget Report' in the name - query='quarterly sales', search_type='content' - Monitor spreadsheets containing 'quarterly sales' - query='name contains "Budget"' - Advanced: Monitor spreadsheets with 'Budget' in the name (prefix matching) - Leave query empty to monitor all spreadsheets

Table Query Result ChangedGOOGLESHEETS_TABLE_QUERY_RESULT_CHANGED_TRIGGERTrigger

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.

Configuración

  • include_formulasboolean

    Whether to return formula text instead of calculated values for formula columns

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to query. This is the long alphanumeric string found in the spreadsheet URL between '/d/' and '/edit'.

  • sqlstringObligatorio

    SQL SELECT query to execute. The table name is the Google Sheets tab/sheet name (visible at the bottom of the spreadsheet). Supported: SELECT cols FROM table WHERE conditions ORDER BY col LIMIT n. Table names must be quoted with double quotes if they contain spaces or are numeric-only (e.g., SELECT * FROM "My Sheet" or SELECT * FROM "415").

Payload del evento

  • changesobject[]Obligatorio

    List of detected changes

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • event_typestring

    Type of event that occurred

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

  • sqlstringObligatorio

    The SQL query that was executed

  • total_rows_afterintegerObligatorio

    Total number of rows after the change

  • total_rows_beforeintegerObligatorio

    Total number of rows before the change

Instrucciones

**Table Query Result Changed in Google Sheets (Polling):** - Monitors the result set of a SQL query against a Google Sheets table - Detects when rows are added, removed, or updated in the query output - Configure spreadsheet ID and SQL query to monitor - Uses snapshot-based diffing to detect changes between polls - Emits events with detailed change information (added/removed/updated rows) - The query should use LIMIT to bound the result set (recommended max: 100-200 rows) - Table names are the sheet/tab names visible at the bottom of the spreadsheet

Table Schema ChangedGOOGLESHEETS_TABLE_SCHEMA_CHANGED_TRIGGERTrigger

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.

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • sample_sizeinteger

    Number of rows to sample for type inference

  • sheet_namestring

    Sheet/tab name if table_name is ambiguous across multiple sheets

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor

  • table_namestringObligatorio

    Table name from LIST_TABLES response OR the visible Google Sheets tab name. Use 'auto' to monitor the largest/most prominent table.

Payload del evento

  • change_summarystringObligatorio

    Human-readable summary of the changes

  • column_changesobject[]Obligatorio

    List of column changes detected

  • current_column_countintegerObligatorio

    Number of columns in current schema

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • previous_column_countintegerObligatorio

    Number of columns in previous schema

  • sheet_namestringObligatorio

    Sheet name where table is located

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

  • table_namestringObligatorio

    Name of the table that changed

Instrucciones

**Table Schema Changed (Polling):** - Monitors a specific table in a Google Spreadsheet for schema changes - Detects changes to columns: additions, removals, renames, type changes, position changes - Uses snapshot-based diffing to compare full table schemas between polls - Configure with spreadsheet_id, table_name, and optionally sheet_name - On first run, initializes state without emitting events - Emits events when column structure or types change

Worksheet Names ChangedGOOGLESHEETS_WORKSHEET_NAMES_CHANGED_TRIGGERTrigger

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

Configuración

  • intervalnumber

    Periodic Interval to Check for Updates & Send a Trigger in Minutes

  • spreadsheet_idstringObligatorio

    The unique identifier of the Google Spreadsheet to monitor

Payload del evento

  • change_typestringObligatorio

    Type of change: 'added', 'deleted', or 'renamed'

  • current_namesstring[]Obligatorio

    Current list of all worksheet names after the change

  • detected_atstringObligatorio

    ISO timestamp when the change was detected

  • previous_namestring

    Previous name if worksheet was renamed (only for renamed events)

  • spreadsheet_idstringObligatorio

    The spreadsheet ID

  • worksheet_namestringObligatorio

    The name of the worksheet that was added, deleted, or involved in the change

Instrucciones

**Instructions for Setting Up the Trigger:** - This trigger monitors a Google Spreadsheet for changes to worksheet/tab names. - It detects when worksheets are added, deleted, or renamed. - Provide the spreadsheet_id of the spreadsheet you want to monitor. - The trigger uses snapshot-based diffing to detect all changes between polls. - On first run, it will initialize state without triggering events.