# Google Sheets

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

Category: Productivity. Connect from any Rakazo bot at https://rakazo.com/integrations/googlesheets/.

## Actions

- **Add Sheet to Spreadsheet**: Adds a new sheet (worksheet) to a spreadsheet.
- **Append Dimension**: Append new rows or columns to a sheet, increasing its size.
- **Batch Clear Spreadsheet Values**: Clear one or more ranges of values from a spreadsheet.
- **Batch Clear Values By Data Filter**: Clears one or more ranges of values from a spreadsheet using data filters.
- **Batch get spreadsheet** (read-only): Retrieves data from specified cell ranges in a google spreadsheet.
- **Batch Get Spreadsheet Values by Data Filter**: Return one or more ranges of values from a spreadsheet that match the specified data filters.
- **Batch update spreadsheet**: Updates a specified range in a google sheet with given values, or appends them as new rows if first cell location is omitted.
- **Clear Basic Filter**: Clear the basic filter from a sheet.
- **Copy Sheet to Another Spreadsheet**: Copy a single sheet from a spreadsheet to another spreadsheet.
- **Create a Google Sheet**: Creates 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.
- **Delete Sheet**: Delete a sheet (worksheet) from a spreadsheet.
- **Get Spreadsheet by Data Filter**: Returns the spreadsheet at the given id, filtered by the specified data filters.
- **Get spreadsheet info** (read-only): Retrieves comprehensive metadata for a google spreadsheet using its id, excluding cell data.
- **Insert Dimension in Google Sheet**: Insert new rows or columns into a sheet at a specified location.
- **Search Developer Metadata**: Search for developer metadata in a spreadsheet.
- **Search Spreadsheets** (read-only): Search for google spreadsheets using various filters including name, content, date ranges, and more.
- **Set Basic Filter**: Set a basic filter on a sheet in a google spreadsheet.
- **Update Sheet Properties**: Update properties of a sheet (worksheet) within a google spreadsheet, such as its title, index, visibility, tab color, or grid properties.
- **Update Spreadsheet Properties**: Update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings.
- **Aggregate Column Data** (read-only): Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
- **Append Values to Spreadsheet**: Append values to a spreadsheet.
- **Batch Update Values by Data Filter**: Update values in ranges matching data filters.
- **Clear spreadsheet values**: Clears cell content (preserving formatting and notes) from a specified a1 notation range in a google spreadsheet.
- **Create Chart in Google Sheets**: Create a chart in a google sheets spreadsheet using the specified data range and chart type.
- **Create 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…
- **Create spreadsheet column**: Creates a new column in a google spreadsheet, requiring a valid spreadsheet id and an existing sheet id.
- **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…
- **Execute SQL on Spreadsheet**: Execute sql queries against google sheets tables.
- **Find worksheet by title** (read-only): Finds a worksheet by its exact, case-sensitive title within a google spreadsheet.
- **Format cell**: Applies text and background cell formatting to a specified range in a google sheets worksheet.
- **Get sheet names** (read-only): Lists all worksheet names from a specified google spreadsheet (which must exist), useful for discovering sheets before further operations.
- **Get Table Schema** (read-only): 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…
- **List Tables in Spreadsheet** (read-only): This 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 row** (read-only): Finds the first row in a google spreadsheet where a cell's entire content exactly matches the query string, searching within a specified…
- **Query Spreadsheet Table** (read-only): This action is used to query a table in a google spreadsheet, call this action to query a table in a spreadsheet.