Google Sheets
Read and edit Google Sheets spreadsheets from the agent.
Google Sheets
Lets the agent read, write and manage the tabs and cell ranges of Google Sheets spreadsheets. It requires a Google Sheets connection configured in the workspace.
The available operations
When you add this tool, choose which operations the agent is allowed to perform.
List the tabs
Returns a spreadsheet's tabs (sheets) and their properties.
| Parameter | Required | Default | What it is |
|---|---|---|---|
| Spreadsheet ID | Yes | — | The Google Sheets spreadsheet's ID (it is in the URL: docs.google.com/spreadsheets/d/{ID}/) |
Add a tab
Creates a new tab in an existing spreadsheet.
| Parameter | Required | Default | What it is |
|---|---|---|---|
| Spreadsheet ID | Yes | — | The spreadsheet to create the tab in |
| Title | Yes | — | The new tab's name |
| Position | No | — | The tab's position (zero-based). Omitted, it goes at the end |
| Number of rows | No | 1000 | The new tab's row count |
| Number of columns | No | 26 | The new tab's column count |
Delete a tab
Removes a tab from a spreadsheet.
| Parameter | Required | Default | What it is |
|---|---|---|---|
| Spreadsheet ID | Yes | — | The spreadsheet holding the tab |
| Tab ID | Yes | — | The numeric ID of the tab to delete (from "List the tabs") |
Read a range
Reads the values of a range of cells.
| Parameter | Required | Default | What it is |
|---|---|---|---|
| Spreadsheet ID | Yes | — | The spreadsheet |
| Range | Yes | — | The range in A1 notation (e.g. Sheet1!A1:D10, A1:C5, Sheet1!A:A). Include the tab's name to be precise |
Update a range
Replaces the values of a range of cells with the ones you give.
| Parameter | Required | Default | What it is |
|---|---|---|---|
| Spreadsheet ID | Yes | — | The spreadsheet |
| Range | Yes | — | The range in A1 notation (e.g. Sheet1!A1:C3) |
| Values | Yes | — | A two-dimensional array of values (rows × columns). E.g. [["Name", "Age"], ["João", 30]] |
| Input mode | No | USER_ENTERED | How the values are read: USER_ENTERED (formulas and types are interpreted) or RAW (literal text) |
Clear a range
Removes the values from a range of cells without touching the formatting.
| Parameter | Required | Default | What it is |
|---|---|---|---|
| Spreadsheet ID | Yes | — | The spreadsheet |
| Range | Yes | — | The range to clear, in A1 notation (e.g. Sheet1!A1:D10, A:C) |
Add rows
Adds new rows at the end of a range or table.
| Parameter | Required | Default | What it is |
|---|---|---|---|
| Spreadsheet ID | Yes | — | The spreadsheet |
| Reference range | Yes | — | The range used to locate the table the rows go into (e.g. Sheet1!A1) |
| Values | Yes | — | The rows to add, as a two-dimensional array. E.g. [["João", 30, "SP"], ["Maria", 25, "RJ"]] |
| Input mode | No | USER_ENTERED | How the values are read: USER_ENTERED or RAW |
| Insert mode | No | INSERT_ROWS | How the data goes in: INSERT_ROWS (new rows are inserted) or OVERWRITE |