Google Sheets nodes

Tools for creating, reading, updating, and deleting Google Sheets data.  These nodes are also served as MCP tools on the sheets MCP server. Back to the full node reference.

Google Sheets Add Data to Spreadsheet

sheets_add_data_to_spreadsheet · natural-language configurable · 1 credit on Cloud

Append rows of data to a Google Sheets spreadsheet.

Credential: Google Sheets (OAuth)

Parameters

Field	Type	Required	Description
data	array<array>	✓	Two-dimensional array of rows and cell values to append.
range	string	✓	A1 notation range to append data to (e.g. Sheet1!A1).
spreadsheetId	string	✓	Google Sheets spreadsheet identifier.
valueInputOption	enum		How input data should be interpreted by Google Sheets. One of: USER_ENTERED, RAW. Default: USER_ENTERED.

Output

Returns a list of records — reference fields downstream as $<node>.spreadsheetId.

Field	Type	Description
spreadsheetId	string	Identifier of the updated spreadsheet.
status	boolean	Whether the data was appended successfully.
updatedCells	integer	Number of cells updated.
updatedColumns	integer	Number of columns updated.
updatedRange	string	Range that was updated, in A1 notation.
updatedRows	integer	Number of rows updated.

Google Sheets Create Spreadsheet

sheets_create_spreadsheet · natural-language configurable · 1 credit on Cloud

Create a new Google Sheets spreadsheet with the given title.

Credential: Google Sheets (OAuth)

Parameters

Field	Type	Required	Description
title	string	✓	Title of the new spreadsheet.

Output

Returns a list of records — reference fields downstream as $<node>.id.

Field	Type	Description
id	string	Identifier of the created spreadsheet.
name	string	Name of the created spreadsheet.
status	boolean	Whether the spreadsheet was created successfully.
webViewLink	string	Web view link to open the spreadsheet.

Google Sheets Delete Spreadsheet

sheets_delete_spreadsheet · natural-language configurable · destructive · 1 credit on Cloud

Delete a Google Sheets spreadsheet by its identifier.

Credential: Google Sheets (OAuth)

Parameters

Field	Type	Required	Description
spreadsheetId	string	✓	Identifier of the Google Sheets spreadsheet to delete.

Output

Returns a list of records — reference fields downstream as $<node>.status.

Field	Type	Description
status	boolean	Whether the spreadsheet was deleted successfully.

Google Sheets Read Spreadsheet

sheets_read_spreadsheet · natural-language configurable · read-only · idempotent · 1 credit on Cloud

Read rows from a Google Sheets spreadsheet, optionally filtering and limiting results.

Credential: Google Sheets (OAuth)

Parameters

Field	Type	Required	Description
filterColumn	string		Column name used to filter returned rows.
filterValue	string		Value the filter column must match.
headerRow	number		Row number containing column headers; 0 means no header row. Default: 0.
limit	number		Maximum number of rows to return; 0 means no limit.
range	string		A1 notation range to read (e.g. A:Z). Default: A:Z.
spreadsheetId	string	✓	Identifier of the Google Sheets spreadsheet to read.

Output

Returns a list of records — reference fields downstream as $<node>.row_number.

Field	Type	Description
row_number	integer	Row index in the source spreadsheet.

Google Sheets Update Cell

sheets_update · natural-language configurable · destructive · 1 credit on Cloud

Update a single cell in a Google Sheets spreadsheet by row number and column.

Credential: Google Sheets (OAuth)

Parameters

Field	Type	Required	Description
column	string	✓	Column header name or column letter (e.g. "name" or "B").
newValue	string	✓	New cell value to write.
rowNumber	number	✓	1-based row number of the cell to update.
sheetId	string	✓	Identifier of the Google Sheets spreadsheet to update.

Output

Returns a list of records — reference fields downstream as $<node>.column.

Field	Type	Description
column	string	Column that was updated.
newValue	string	Value that was written to the cell.
rowNumber	integer	Row number that was updated.
sheetId	string	Identifier of the updated spreadsheet.
status	boolean	Whether the cell was updated successfully.
updatedCells	integer	Number of cells updated.
updatedRange	string	Range that was updated, in A1 notation.