Google Sheets

Tools

Details

Installs

More than 1000

Actions

Triggers

Name	Description	Name & Description	Type
GOOGLESHEETS_ADD_SHEET	Adds a new sheet (worksheet) to a spreadsheet.	GOOGLESHEETS_ADD_SHEETAdds a new sheet (worksheet) to a spreadsheet.	action
GOOGLESHEETS_APPEND_DIMENSION	Tool to append new rows or columns to a sheet, increasing its size.	GOOGLESHEETS_APPEND_DIMENSIONTool to append new rows or columns to a sheet, increasing its size.	action
GOOGLESHEETS_BATCH_UPDATE	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.	GOOGLESHEETS_BATCH_UPDATEUpdates 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.	action
GOOGLESHEETS_CLEAR_BASIC_FILTER	Tool to clear the basic filter from a sheet.	GOOGLESHEETS_CLEAR_BASIC_FILTERTool to clear the basic filter from a sheet.	action
GOOGLESHEETS_DELETE_DIMENSION	Tool to delete specified rows or columns from a sheet in a google spreadsheet.	GOOGLESHEETS_DELETE_DIMENSIONTool to delete specified rows or columns from a sheet in a google spreadsheet.	action
GOOGLESHEETS_DELETE_SHEET	Tool to delete a sheet (worksheet) from a spreadsheet.	GOOGLESHEETS_DELETE_SHEETTool to delete a sheet (worksheet) from a spreadsheet.	action
GOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER	Returns the spreadsheet at the given id, filtered by the specified data filters.	GOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTERReturns the spreadsheet at the given id, filtered by the specified data filters.	action
GOOGLESHEETS_GET_SPREADSHEET_INFO	Retrieves comprehensive metadata for a google spreadsheet using its id, excluding cell data.	GOOGLESHEETS_GET_SPREADSHEET_INFORetrieves comprehensive metadata for a google spreadsheet using its id, excluding cell data.	action
GOOGLESHEETS_INSERT_DIMENSION	Tool to insert new rows or columns into a sheet at a specified location.	GOOGLESHEETS_INSERT_DIMENSIONTool to insert new rows or columns into a sheet at a specified location.	action
GOOGLESHEETS_SEARCH_DEVELOPER_METADATA	Tool to search for developer metadata in a spreadsheet.	GOOGLESHEETS_SEARCH_DEVELOPER_METADATATool to search for developer metadata in a spreadsheet.	action
GOOGLESHEETS_SET_BASIC_FILTER	Tool to set a basic filter on a sheet in a google spreadsheet.	GOOGLESHEETS_SET_BASIC_FILTERTool to set a basic filter on a sheet in a google spreadsheet.	action
GOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TO	Tool to copy a single sheet from a spreadsheet to another spreadsheet.	GOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TOTool to copy a single sheet from a spreadsheet to another spreadsheet.	action
GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND	Tool to append values to a spreadsheet.	GOOGLESHEETS_SPREADSHEETS_VALUES_APPENDTool to append values to a spreadsheet.	action
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR	Tool to clear one or more ranges of values from a spreadsheet.	GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEARTool to clear one or more ranges of values from a spreadsheet.	action
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR_BY_DATA_FILTER	Clears one or more ranges of values from a spreadsheet using data filters.	GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR_BY_DATA_FILTERClears one or more ranges of values from a spreadsheet using data filters.	action
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTER	Tool to return one or more ranges of values from a spreadsheet that match the specified data filters.	GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTERTool to return one or more ranges of values from a spreadsheet that match the specified data filters.	action
GOOGLESHEETS_UPDATE_SHEET_PROPERTIES	Tool to update properties of a sheet (worksheet) within a google spreadsheet, such as its title, index, visibility, tab color, or grid properties.	GOOGLESHEETS_UPDATE_SHEET_PROPERTIESTool to update properties of a sheet (worksheet) within a google spreadsheet, such as its title, index, visibility, tab color, or grid properties.	action
GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES	Tool to update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings.	GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIESTool to update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings.	action
GOOGLESHEETS_AGGREGATE_COLUMN_DATA	Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.	GOOGLESHEETS_AGGREGATE_COLUMN_DATASearches for rows where a specific column matches a value and performs mathematical operations on data from another column.	action
GOOGLESHEETS_BATCH_GET	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.	GOOGLESHEETS_BATCH_GETRetrieves 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.	action
GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER	Tool to update values in ranges matching data filters.	GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTERTool to update values in ranges matching data filters.	action
GOOGLESHEETS_CLEAR_VALUES	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.	GOOGLESHEETS_CLEAR_VALUESClears cell content (preserving formatting and notes) from a specified a1 notation range in a google spreadsheet; the range must correspond to an existing sheet and cells.	action
GOOGLESHEETS_CREATE_GOOGLE_SHEET1	Creates a new google spreadsheet in google drive using the provided title.	GOOGLESHEETS_CREATE_GOOGLE_SHEET1Creates a new google spreadsheet in google drive using the provided title.	action
GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN	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.	GOOGLESHEETS_CREATE_SPREADSHEET_COLUMNCreates 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.	action
GOOGLESHEETS_CREATE_SPREADSHEET_ROW	Inserts a new, empty row into a specified sheet of a google spreadsheet at a given index, optionally inheriting formatting from the row above.	GOOGLESHEETS_CREATE_SPREADSHEET_ROWInserts a new, empty row into a specified sheet of a google spreadsheet at a given index, optionally inheriting formatting from the row above.	action
GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE	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.	GOOGLESHEETS_FIND_WORKSHEET_BY_TITLEFinds 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.	action
GOOGLESHEETS_FORMAT_CELL	Applies text and background cell formatting to a specified range in a Google Sheets worksheet.	GOOGLESHEETS_FORMAT_CELLApplies text and background cell formatting to a specified range in a Google Sheets worksheet.	action
GOOGLESHEETS_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_NAMESLists all worksheet names from a specified google spreadsheet (which must exist), useful for discovering sheets before further operations.	action
GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW	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.	GOOGLESHEETS_LOOKUP_SPREADSHEET_ROWFinds the first row in a google spreadsheet where a cell's entire content exactly matches the query string, searching within a specified a1 notation range or the first sheet by default.	action
GOOGLESHEETS_SEARCH_SPREADSHEETS	Search for google spreadsheets using various filters including name, content, date ranges, and more.	GOOGLESHEETS_SEARCH_SPREADSHEETSSearch for google spreadsheets using various filters including name, content, date ranges, and more.	action
GOOGLESHEETS_SHEET_FROM_JSON	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.	GOOGLESHEETS_SHEET_FROM_JSONCreates 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.	action
GOOGLESHEETS_NEW_ROWS_TRIGGER	Simple polling trigger that monitors Google Sheets for new rows.	GOOGLESHEETS_NEW_ROWS_TRIGGERSimple polling trigger that monitors Google Sheets for new rows.	trigger