Google Sheets
Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps
36 actionsSign in with Google Sheets
What your bot can do in Google Sheets
Looks up
- Batch get spreadsheetRetrieves data from specified cell ranges in a google spreadsheet.
- Get spreadsheet infoRetrieves comprehensive metadata for a google spreadsheet using its id, excluding cell data.
- Search SpreadsheetsSearch for google spreadsheets using various filters including name, content, date ranges, and more.
- Aggregate Column DataSearches for rows where a specific column matches a value and performs mathematical operations on data from another column.
- Find worksheet by titleFinds a worksheet by its exact, case-sensitive title within a google spreadsheet.
- Get sheet namesLists all worksheet names from a specified google spreadsheet (which must exist), useful for discovering sheets before further operations.
- Get Table SchemaThis 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…
- List Tables in SpreadsheetThis action is used to list all tables in a google spreadsheet, call this action to get the list of tables in a spreadsheet.
- Look up spreadsheet rowFinds the first row in a google spreadsheet where a cell's entire content exactly matches the query string, searching within a specified…
- Query Spreadsheet TableThis action is used to query a table in a google spreadsheet, call this action to query a table in a spreadsheet.
Takes action
- Add Sheet to SpreadsheetAdds a new sheet (worksheet) to a spreadsheet.
- Append DimensionAppend new rows or columns to a sheet, increasing its size.
- Batch Clear Spreadsheet ValuesClear one or more ranges of values from a spreadsheet.
- Batch Clear Values By Data FilterClears one or more ranges of values from a spreadsheet using data filters.
- Batch Get Spreadsheet Values by Data FilterReturn one or more ranges of values from a spreadsheet that match the specified data filters.
- Batch update spreadsheetUpdates a specified range in a google sheet with given values, or appends them as new rows if first cell location is omitted.
- Clear Basic FilterClear the basic filter from a sheet.
- Copy Sheet to Another SpreadsheetCopy a single sheet from a spreadsheet to another spreadsheet.
- Create a Google SheetCreates a new google spreadsheet in google drive using the provided title.
- Delete Dimension (Rows/Columns)Delete specified rows or columns from a sheet in a google spreadsheet.
Show 16 more
- Delete SheetDelete a sheet (worksheet) from a spreadsheet.
- Get Spreadsheet by Data FilterReturns the spreadsheet at the given id, filtered by the specified data filters.
- Insert Dimension in Google SheetInsert new rows or columns into a sheet at a specified location.
- Search Developer MetadataSearch for developer metadata in a spreadsheet.
- Set Basic FilterSet a basic filter on a sheet in a google spreadsheet.
- Update Sheet PropertiesUpdate properties of a sheet (worksheet) within a google spreadsheet, such as its title, index, visibility, tab color, or grid properties.
- Update Spreadsheet PropertiesUpdate properties of a spreadsheet, such as its title, locale, or auto-recalculation settings.
- Append Values to SpreadsheetAppend values to a spreadsheet.
- Batch Update Values by Data FilterUpdate values in ranges matching data filters.
- Clear spreadsheet valuesClears cell content (preserving formatting and notes) from a specified a1 notation range in a google spreadsheet.
- Create Chart in Google SheetsCreate a chart in a google sheets spreadsheet using the specified data range and chart type.
- Create 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…
- Create spreadsheet columnCreates a new column in a google spreadsheet, requiring a valid spreadsheet id and an existing sheet id.
- 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…
- Execute SQL on SpreadsheetExecute sql queries against google sheets tables.
- Format cellApplies text and background cell formatting to a specified range in a google sheets worksheet.
