Google Sheets
Read, write, and update data
Configuration
Read Data
Operation
Read Data
Google Account*
Select Google account
Select Sheet
Select a spreadsheet
Spreadsheet ID
ID of the spreadsheet (from URL)
Range
Sheet name and cell range (e.g., Sheet1!A1:D10)
Read Data (
google_sheets_read)Read data from a Google Sheets spreadsheet
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The ID of the spreadsheet to read from |
range | string | No | The range of cells to read from |
Output
| Parameter | Type | Description |
|---|---|---|
data | json | Sheet data including range and cell values |
Write Data
Operation
Write Data
Google Account*
Select Google account
Select Sheet
Select a spreadsheet
Spreadsheet ID
ID of the spreadsheet (from URL)
Range
Sheet name and cell range (e.g., Sheet1!A1:D10)
Values*
Enter values as JSON array of arrays (e.g., [["A1", "B1"], ["A2", "B2"]]) or an array of objects (e.g., [{"name":"John", "age":30}, {"name":"Jane", "age":25}])
Value Input Option
Select...
Write Data (
google_sheets_write)Write data to a Google Sheets spreadsheet
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The ID of the spreadsheet to write to |
range | string | No | The range of cells to write to |
values | array | Yes | The data to write to the spreadsheet |
valueInputOption | string | No | The format of the data to write |
includeValuesInResponse | boolean | No | Whether to include the written values in the response |
Output
| Parameter | Type | Description |
|---|---|---|
updatedRange | string | Range of cells that were updated |
updatedRows | number | Number of rows updated |
updatedColumns | number | Number of columns updated |
updatedCells | number | Number of cells updated |
Update Data
Operation
Update Data
Google Account*
Select Google account
Select Sheet
Select a spreadsheet
Spreadsheet ID
ID of the spreadsheet (from URL)
Range
Sheet name and cell range (e.g., Sheet1!A1:D10)
Values*
Enter values as JSON array of arrays (e.g., [["A1", "B1"], ["A2", "B2"]]) or an array of objects (e.g., [{"name":"John", "age":30}, {"name":"Jane", "age":25}])
Value Input Option
Select...
Update Data (
google_sheets_update)Update data in a Google Sheets spreadsheet
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The ID of the spreadsheet to update |
range | string | No | The range of cells to update |
values | array | Yes | The data to update in the spreadsheet |
valueInputOption | string | No | The format of the data to update |
includeValuesInResponse | boolean | No | Whether to include the updated values in the response |
Output
| Parameter | Type | Description |
|---|---|---|
updatedRange | string | Range of cells that were updated |
updatedRows | number | Number of rows updated |
updatedColumns | number | Number of columns updated |
updatedCells | number | Number of cells updated |
Append Data
Operation
Append Data
Google Account*
Select Google account
Select Sheet
Select a spreadsheet
Spreadsheet ID
ID of the spreadsheet (from URL)
Range
Sheet name and cell range (e.g., Sheet1!A1:D10)
Values*
Enter values as JSON array of arrays (e.g., [["A1", "B1"], ["A2", "B2"]]) or an array of objects (e.g., [{"name":"John", "age":30}, {"name":"Jane", "age":25}])
Value Input Option
Select...
Insert Data Option
Select...
Append Data (
google_sheets_append)Append data to the end of a Google Sheets spreadsheet
Input
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The ID of the spreadsheet to append to |
range | string | No | The range of cells to append after |
values | array | Yes | The data to append to the spreadsheet |
valueInputOption | string | No | The format of the data to append |
insertDataOption | string | No | How to insert the data (OVERWRITE or INSERT_ROWS) |
includeValuesInResponse | boolean | No | Whether to include the appended values in the response |
Output
| Parameter | Type | Description |
|---|---|---|
tableRange | string | Range of the table where data was appended |
updatedRange | string | Range of cells that were updated |
updatedRows | number | Number of rows updated |
updatedColumns | number | Number of columns updated |
updatedCells | number | Number of cells updated |
Usage Instructions
Integrate Google Sheets into the workflow. Can read, write, append, and update data.
Notes
- Category:
tools - Type:
google_sheets