Skip to main content

​
Append values

Action ID: tools.google_sheets.append_values Append rows to a Google Sheets range. Reference: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/append

​
Secrets

Optional secrets:
  • google_sheets_oauth: OAuth token GOOGLE_SHEETS_SERVICE_TOKEN.

​
Input fields

​
range
string
required
A1 notation range to append to.
​
spreadsheet_id
string
required
Target spreadsheet ID.
​
values
array[array[string | integer | number | boolean | null]]
required
Two-dimensional array of values to append.
​
include_values_in_response
boolean
Include the appended values in the response payload.Default: false.
​
insert_data_option
string
How the input data should be inserted.Default: "INSERT_ROWS".Allowed values: OVERWRITE, INSERT_ROWS.
​
major_dimension
string | null
Orientation of the values array.Default: null.
​
value_input_option
string
How input data should be interpreted.Default: "USER_ENTERED".Allowed values: RAW, USER_ENTERED.

​
Batch clear values

Action ID: tools.google_sheets.batch_clear_values Clear values from one or more ranges in a spreadsheet. Reference: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchClear

​
Secrets

Optional secrets:
  • google_sheets_oauth: OAuth token GOOGLE_SHEETS_SERVICE_TOKEN.

​
Input fields

​
ranges
array[string]
required
List of A1 notation ranges to clear.
​
spreadsheet_id
string
required
Spreadsheet ID to clear.

​
Batch get values

Action ID: tools.google_sheets.batch_get_values Retrieve values from multiple ranges in a spreadsheet. Reference: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchGet

​
Secrets

Optional secrets:
  • google_sheets_oauth: OAuth token GOOGLE_SHEETS_SERVICE_TOKEN.

​
Input fields

​
ranges
array[string]
required
A1 notation ranges to retrieve.
​
spreadsheet_id
string
required
Spreadsheet ID to read from.
​
date_time_render_option
string | null
How dates and times should be represented.Default: null.
​
major_dimension
string | null
Orientation of the returned values.Default: null.
​
value_render_option
string | null
How values should be rendered in the response.Default: null.

​
Batch update values

Action ID: tools.google_sheets.batch_update_values Update cell values across multiple ranges in one request. Reference: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate

​
Secrets

Optional secrets:
  • google_sheets_oauth: OAuth token GOOGLE_SHEETS_SERVICE_TOKEN.

​
Input fields

​
spreadsheet_id
string
required
Spreadsheet ID to update.
​
updates
array[object]
required
List of updates with range, values, and optional major_dimension per entry.
​
include_values_in_response
boolean
Include the updated values in the response payload.Default: false.
​
response_date_time_render_option
string | null
How dates and times should be represented in the response.Default: null.
​
response_value_render_option
string | null
How updated values should be rendered in the response.Default: null.
​
value_input_option
string
How input data should be interpreted.Default: "USER_ENTERED".Allowed values: RAW, USER_ENTERED.

​
Copy sheet

Action ID: tools.google_sheets.copy_sheet Copy a sheet to another spreadsheet. Reference: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.sheets/copyTo

​
Secrets

Optional secrets:
  • google_sheets_oauth: OAuth token GOOGLE_SHEETS_SERVICE_TOKEN.

​
Input fields

​
destination_spreadsheet_id
string
required
Destination spreadsheet ID.
​
sheet_id
integer
required
ID of the sheet to copy.
​
spreadsheet_id
string
required
Source spreadsheet ID.

​
Create spreadsheet

Action ID: tools.google_sheets.create_spreadsheet Create a new Google Spreadsheet with an optional set of sheets. Reference: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/create

​
Secrets

Optional secrets:
  • google_sheets_oauth: OAuth token GOOGLE_SHEETS_SERVICE_TOKEN.

​
Input fields

​
title
string
required
Spreadsheet title.
​
sheet_titles
array[string] | null
Optional list of sheet titles to create.Default: null.

​
Get spreadsheet

Action ID: tools.google_sheets.get_spreadsheet Retrieve spreadsheet metadata and optional grid data. Reference: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/get

​
Secrets

Optional secrets:
  • google_sheets_oauth: OAuth token GOOGLE_SHEETS_SERVICE_TOKEN.

​
Input fields

​
spreadsheet_id
string
required
Spreadsheet ID to fetch.
​
include_grid_data
boolean
Return grid data along with metadata.Default: false.
​
ranges
array[string] | null
Optional A1 notation ranges to include.Default: null.