Tools
Google Sheets
Read, write, and update data
Integrate Google Sheets into the workflow. Can read, write, append, and update data.
Read data from a Google Sheets spreadsheet
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet (found in the URL: docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit). |
range | string | No | The A1 notation range to read (e.g. "Sheet1!A1:D10", "A1:B5"). Defaults to first sheet A1:Z1000 if not specified. |
| Parameter | Type | Description |
|---|
data | json | Sheet data including range and cell values |
metadata | json | Spreadsheet metadata including ID and URL |
Write data to a Google Sheets spreadsheet
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet |
range | string | No | The A1 notation range to write to (e.g. "Sheet1!A1:D10", "A1:B5") |
values | array | Yes | The data to write as a 2D array (e.g. [["Name", "Age"], ["Alice", 30], ["Bob", 25]]) or array of objects. |
| 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 |
metadata | json | Spreadsheet metadata including ID and URL |
Update data in a Google Sheets spreadsheet
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet to update |
range | string | No | The A1 notation range to update (e.g. "Sheet1!A1:D10", "A1:B5") |
values | array | Yes | The data to update as a 2D array (e.g. [["Name", "Age"], ["Alice", 30]]) or array of objects. |
| 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 |
metadata | json | Spreadsheet metadata including ID and URL |
Append data to the end of a Google Sheets spreadsheet
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet to append to |
range | string | No | The A1 notation range to append after (e.g. "Sheet1", "Sheet1!A:D") |
values | array | Yes | The data to append as a 2D array (e.g. [["Alice", 30], ["Bob", 25]]) or array of objects. |
| 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 |
metadata | json | Spreadsheet metadata including ID and URL |
- Category:
tools
- Type:
google_sheets
