Google Sheets Toolkit

The Google Sheets Toolkit is a workflow node. Its tools include Insert Row, Insert Multiple Rows, Delete Row, and Update Row, plus 10 more listed below. Connect a Google Sheets account before you use any of these tools. Type @ in a field when the value should come from an earlier step.

Authentication

Every Google Sheets tool needs a connected account before it can run. On the node, open Google Sheets Account.

1. Choose Use my Google Sheets account or Use team account.
2. If no personal account is connected, click Connect Google Sheets Account and finish sign-in.
3. For a team account, choose Use team account and pick one from Team account. The list shows accounts already connected for the project.

Tools

Insert Row

Runs the insert row tool.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Include Team Drives	No	Include spreadsheets from Team Drives in the spreadsheet selection dropdown. Default is false.
Sheet ID	Yes	Sheet within the spreadsheet.
As String	No	Inserted values that are dates and formulas will be entered as strings and have no effect. Default is false.
First Row Headers	No	Does the first row contain headers? Default is true.
Values	Yes	Row of values to insert (JSON object with column labels as keys when first_row_headers is true, or JSON array when false). Type @ to select a variable.

Insert Multiple Rows

Runs the insert multiple rows tool.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Include Team Drives	No	Include spreadsheets from Team Drives in the spreadsheet selection dropdown. Default is false.
Sheet ID	Yes	Sheet within the spreadsheet.
As String	No	Inserted values that are dates and formulas will be entered as strings and have no effect. Default is false.
Values	Yes	JSON array of row objects to insert. Each row is a JSON object with column labels as keys (e.g., [{"A": "val1", "B": "val2"}, ...]). Type @ to select a variable.

Delete Row

Deletes row.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Include Team Drives	No	Include spreadsheets from Team Drives in the spreadsheet selection dropdown. Default is false.
Sheet ID	Yes	Sheet within the spreadsheet.
Row ID	Yes	The row number to remove (1-indexed).

Update Row

Updates row.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Include Team Drives	No	Include spreadsheets from Team Drives in the spreadsheet selection dropdown. Default is false.
Sheet ID	Yes	Sheet within the spreadsheet.
Row ID	Yes	The row number to update (1-indexed).
First Row Headers	No	Does the first row contain headers? Default is true.
Values	Yes	Values to update (JSON object with column labels as keys when first_row_headers is true, or JSON array when false). Type @ to select a variable.

Find Rows

Finds rows.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Include Team Drives	No	Include spreadsheets from Team Drives in the spreadsheet selection dropdown. Default is false.
Sheet ID	Yes	Sheet within the spreadsheet.
Column Name	Yes	The column letter to search in (e.g., 'A', 'B', 'C'). Type @ to select a variable.
Search Value	No	The value to search for. If left empty, all rows will be returned. Default is ``. Type @ to select a variable.
Match Case	No	Whether to choose the rows with exact match or choose the rows that contain the search value. Default is false.
Starting Row	No	The row number to start searching from. Default is 1.
Number Of Rows	No	The number of matching rows to return. Default is 1.

Clear Sheet

Runs the clear sheet tool.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Include Team Drives	No	Include spreadsheets from Team Drives in the spreadsheet selection dropdown. Default is false.
Sheet ID	Yes	Sheet within the spreadsheet.
Is First Row Headers	No	If true, the first row (headers) will be preserved when clearing. Default is true.

Get Row By Number

Retrieves row by number.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Include Team Drives	No	Include spreadsheets from Team Drives in the spreadsheet selection dropdown. Default is false.
Sheet ID	Yes	Sheet within the spreadsheet.
Row Number	Yes	The row number to get from the sheet (1-indexed).

Read Sheet

Reads sheet.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Range Name	Yes	Range to read (e.g., 'Sheet1!A1:D10'). Type @ to select a variable.
Value Render Option	No	How values should be rendered: 'FORMATTED_VALUE', 'UNFORMATTED_VALUE', 'FORMULA'. Default is FORMATTED_VALUE. Type @ to select a variable.

Update Sheet

Updates sheet.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Range Name	Yes	Range to update (e.g., 'Sheet1!A1:D10'). Type @ to select a variable.
Values	Yes	2D array of values to write. Type @ to select a variable.
Value Input Option	No	How input data should be interpreted: 'RAW', 'USER_ENTERED'. Default is USER_ENTERED. Type @ to select a variable.

Append Row

Runs the append row tool.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Range Name	Yes	Range to append to (e.g., 'Sheet1!A:D'). Type @ to select a variable.
Values	Yes	Row of values to append (JSON array of cell values, or a JSON string thereof). Type @ to select a variable.
Value Input Option	No	How input data should be interpreted: 'RAW', 'USER_ENTERED'. Default is USER_ENTERED. Type @ to select a variable.

Get Sheet Metadata

Retrieves sheet metadata.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.

Search Sheets

Searches sheets.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Query	Yes	Search query for Google Drive. Type @ to select a variable.
Max Results	No	Maximum number of results to return. Default is 10.

Create Sheet

Creates sheet.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Title	Yes	Title of the new spreadsheet. Type @ to select a variable.
Headers	No	Optional headers for the first row. Default is null.

Duplicate Sheet

Runs the duplicate sheet tool.

Field	Required	Description
Google Sheets Account	Yes	Select your personal or team Google Sheets account.
Spreadsheet ID	Yes	Google Sheets spreadsheet ID. Type @ to select a variable.
Include Team Drives	No	Include spreadsheets from Team Drives in the spreadsheet selection dropdown. Default is false.
Sheet ID	Yes	Sheet tab to duplicate.
New Sheet Name	No	Name for the duplicated sheet. If omitted, Google auto-names it (e.g., 'Copy of Sheet1'). Default is null. Type @ to select a variable.

Related

Agents can use this integration from chat. See Google Sheets.

See all integrations on the toolkits overview.