Google Sheets

Create chart

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

Create google sheet1

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

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.

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.

Delete dimension

Tool to delete specified rows or columns from a sheet in a google spreadsheet.

Delete sheet

Tool to delete a sheet (worksheet) from a spreadsheet.

Execute sql

Execute sql queries against google sheets tables.

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…

Format cell

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

Get sheet names

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

Get spreadsheet by data filter

Returns the spreadsheet at the given id, filtered by the specified data filters.

Get spreadsheet info

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

Get table schema

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.

Insert dimension

Tool to insert new rows or columns into a sheet at a specified location.

List tables

This action is used to list all tables in a google spreadsheet, call this action to get the list of tables in a spreadsheet.

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.

Query table

This action is used to query a table in a google spreadsheet, call this action to query a table in a spreadsheet.

Search developer metadata

Tool to search for developer metadata in a spreadsheet.

Search spreadsheets

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

Set basic filter

Tool to set a basic filter on a sheet in a google spreadsheet.

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.

Spreadsheets sheets copy to

Tool to copy a single sheet from a spreadsheet to another spreadsheet.

Spreadsheets values append

Tool to append values to a spreadsheet.

Spreadsheets values batch clear

Tool to clear one or more ranges of values from a spreadsheet.

Spreadsheets values batch clear by data filter

Clears one or more ranges of values from a spreadsheet using data filters.

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.

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.

Update spreadsheet properties

Tool to update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings.