Google Sheets API Operations Reference

productivity

48 operations

ActionGOOGLESHEETS_ADD_SHEET

Add Sheet to Existing Spreadsheet

Adds a new sheet to a spreadsheet.

6 input

ActionGOOGLESHEETS_AGGREGATE_COLUMN_DATA

Aggregate Column Data

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

10 input

ActionGOOGLESHEETS_APPEND_DIMENSION

Append Dimension

Tool to append new rows or columns to a sheet, increasing its size.

7 input

ActionGOOGLESHEETS_SPREADSHEETS_VALUES_APPEND

Append Values to Spreadsheet

Tool to append values to a spreadsheet.

9 input

ActionGOOGLESHEETS_AUTO_RESIZE_DIMENSIONS

Auto-Resize Rows or Columns

Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions.

6 input

ActionGOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR

Batch Clear Spreadsheet Values

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

2 input

ActionGOOGLESHEETS_BATCH_CLEAR_VALUES_BY_DATA_FILTER

Batch Clear Values By Data Filter

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

2 input

ActionGOOGLESHEETS_GET_BATCH_VALUES

Batch Get Spreadsheet Values (Deprecated)

DEPRECATED: Use GOOGLESHEETSBATCHGET instead.

5 input

ActionGOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTER

Batch Get Spreadsheet Values by Data Filter

Tool to return one or more ranges of values from a spreadsheet that match the specified data filters.

5 input

ActionGOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER

Batch Update Values by Data Filter

Tool to update values in ranges matching data filters.

6 input

ActionGOOGLESHEETS_BATCH_GET

Batch get spreadsheet

Retrieves data from specified cell ranges in a Google Spreadsheet.

6 input

ActionGOOGLESHEETS_BATCH_UPDATE

Batch update spreadsheet (Deprecated)

DEPRECATED: Use GOOGLESHEETSVALUESUPDATE instead.

6 input

ActionGOOGLESHEETS_UPDATE_VALUES_BATCH

Batch update spreadsheet values

Tool to set values in one or more ranges of a spreadsheet.

6 input

ActionGOOGLESHEETS_CLEAR_BASIC_FILTER

Clear Basic Filter

Tool to clear the basic filter from a sheet.

5 input

ActionGOOGLESHEETS_CLEAR_VALUES

Clear spreadsheet 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…

2 input

ActionGOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TO

Copy Sheet to Another Spreadsheet

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

3 input

ActionGOOGLESHEETS_CREATE_CHART

Create Chart in Google Sheets

Create a chart in a Google Sheets spreadsheet using the specified data range and chart type.

13 input

ActionGOOGLESHEETS_CREATE_GOOGLE_SHEET1

Create a Google Sheet

Creates a new Google Spreadsheet in Google Drive.

1 input

ActionGOOGLESHEETS_SHEET_FROM_JSON

Create sheet from JSON

DEPRECATED: Use GOOGLESHEETSCREATEGOOGLESHEET1 + GOOGLESHEETSUPDATEVALUESBATCH (or GOOGLESHEETSVALUESUPDATE / GOOGLESHEETSSPREADSHEETSVALUESAPPEND) instead.

3 input

ActionGOOGLESHEETS_CREATE_SPREADSHEET_COLUMN

Create spreadsheet column

Creates a new column in a Google Spreadsheet.

8 input

ActionGOOGLESHEETS_CREATE_SPREADSHEET_ROW

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.

8 input

ActionGOOGLESHEETS_DELETE_DIMENSION

Delete Dimension (Rows/Columns)

Tool to delete specified rows or columns from a sheet in a Google Spreadsheet.

10 input

ActionGOOGLESHEETS_DELETE_SHEET

Delete Sheet

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

5 input

ActionGOOGLESHEETS_EXECUTE_SQL

Execute SQL on Spreadsheet

DEPRECATED: Use direct Google Sheets actions instead: - GOOGLESHEETSVALUESGET / GOOGLESHEETSBATCHGET for reads - GOOGLESHEETSVALUESUPDATE /…

4 input

ActionGOOGLESHEETS_FIND_REPLACE

Find and Replace in Spreadsheet

Tool to find and replace text in a Google Spreadsheet.

16 input

ActionGOOGLESHEETS_FIND_WORKSHEET_BY_TITLE

Find worksheet by title (Deprecated)

DEPRECATED: Use GetSpreadsheetInfo instead.

2 input

ActionGOOGLESHEETS_FORMAT_CELL

Format cell

Applies text and background cell formatting to a specified range in a Google Sheets worksheet.

16 input

ActionGOOGLESHEETS_GET_DATA_VALIDATION_RULES

Get Data Validation Rules

Tool to extract data validation rules from a Google Sheets spreadsheet.

5 input

ActionGOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER

Get Spreadsheet by Data Filter

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

4 input

ActionGOOGLESHEETS_GET_TABLE_SCHEMA

Get Table Schema

DEPRECATED: Use GOOGLESHEETSGETSHEETNAMES and GOOGLESHEETSGETSPREADSHEETINFO for sheet structure metadata, and GOOGLESHEETSVALUESGET for direct range…

4 input

ActionGOOGLESHEETS_GET_CONDITIONAL_FORMAT_RULES

Get conditional format rules

List conditional formatting rules for each sheet (or a selected sheet) in a normalized, easy-to-edit form.

4 input

ActionGOOGLESHEETS_GET_SHEET_NAMES

Get sheet names

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

2 input

ActionGOOGLESHEETS_GET_SPREADSHEET_INFO

Get spreadsheet info

Retrieves comprehensive metadata for a Google Spreadsheet using its ID, excluding cell data.

4 input

ActionGOOGLESHEETS_VALUES_GET

Get spreadsheet values

Returns a range of values from a spreadsheet.

7 input

ActionGOOGLESHEETS_INSERT_DIMENSION

Insert Dimension in Google Sheet

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

5 input

ActionGOOGLESHEETS_LIST_TABLES

List Tables in Spreadsheet

DEPRECATED: Use GOOGLESHEETSGETSHEETNAMES for tab discovery and GOOGLESHEETSGETSPREADSHEETINFO for full sheet metadata.

4 input

ActionGOOGLESHEETS_LOOKUP_SPREADSHEET_ROW

Look up 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…

7 input

ActionGOOGLESHEETS_MUTATE_CONDITIONAL_FORMAT_RULES

Mutate conditional format rules

Add, update, delete, or reorder conditional format rules on a Google Sheet.

6 input

ActionGOOGLESHEETS_QUERY_TABLE

Query Spreadsheet Table

DEPRECATED: Use GOOGLESHEETSVALUESGET / GOOGLESHEETSBATCHGET for table reads and GOOGLESHEETSLOOKUPSPREADSHEETROW for row lookup/filter workflows.

3 input

ActionGOOGLESHEETS_SEARCH_DEVELOPER_METADATA

Search Developer Metadata

Tool to search for developer metadata in a spreadsheet.

2 input

ActionGOOGLESHEETS_SEARCH_SPREADSHEETS

Search Spreadsheets

Search for Google Spreadsheets using various filters including name, content, date ranges, and more.

11 input

ActionGOOGLESHEETS_SET_BASIC_FILTER

Set Basic Filter

Tool to set a basic filter on a sheet in a Google Spreadsheet.

5 input

ActionGOOGLESHEETS_SET_DATA_VALIDATION_RULE

Set Data Validation Rule

Tool to set or clear data validation rules (including dropdowns) on a range in Google Sheets.

16 input

ActionGOOGLESHEETS_UPDATE_DIMENSION_PROPERTIES

Update Dimension Properties (Hide/Unhide & Resize)

Tool to hide/unhide rows or columns and set row heights or column widths.

11 input

ActionGOOGLESHEETS_UPDATE_SHEET_PROPERTIES

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.

5 input

ActionGOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES

Update Spreadsheet Properties

Tool to update SPREADSHEET-LEVEL properties such as the spreadsheet's title, locale, time zone, or auto-recalculation settings.

6 input

ActionGOOGLESHEETS_VALUES_UPDATE

Update spreadsheet values

Tool to set values in a range of a Google Spreadsheet.

9 input

ActionGOOGLESHEETS_UPSERT_ROWS

Upsert Rows (Smart Update/Insert)

Upsert rows - update existing rows by key, append new ones.

9 input