Google Sheets
Read, write, and update data with sheet selection
Google Sheets is a powerful, cloud-based spreadsheet platform that allows teams and individuals to create, edit, and collaborate on spreadsheets in real-time. Widely used for data tracking, reporting, and lightweight database needs, Google Sheets seamlessly integrates with many tools and services to empower workflow automation and data-driven operations.
Google Sheets offers an extensive feature set for managing and analyzing tabular data, supporting everything from basic calculations to complex reporting and collaborative editing. Its robust API and integration capabilities enable automated access, updates, and reporting from agents and external services.
Key features of Google Sheets include:
- Real-Time Collaboration: Multiple users can edit and view spreadsheets simultaneously from anywhere.
- Rich Data Manipulation: Support for formulas, charts, pivots, and add-ons to analyze and visualize data.
- Easy Data Import/Export: Ability to connect and sync data from various sources using integrations and APIs.
- Powerful Permissions: Fine-grained sharing, access controls, and version history for team management.
In Sim, the Google Sheets integration empowers your agents to automate reading from, writing to, and updating specific sheets within spreadsheets. Agents can interact programmatically with Google Sheets to retrieve or modify data, manage collaborative documents, and automate reporting or record-keeping as part of your AI workflows. By connecting Sim with Google Sheets, you can build intelligent agents that manage, analyze, and update your data dynamically—streamlining operations, enhancing productivity, and ensuring up-to-date data access across your organization.
Integrate Google Sheets into the workflow with explicit sheet selection. Can read, write, append, update, clear data, create spreadsheets, get spreadsheet info, and copy sheets.
Read data from a specific sheet in 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 |
|---|
sheetName | string | Name of the sheet that was read |
range | string | The range of cells that was read |
values | array | The cell values as a 2D array |
metadata | json | Spreadsheet metadata including ID and URL |
↳ spreadsheetId | string | Google Sheets spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Write data to a specific sheet in 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. |
valueInputOption | string | No | The format of the data to write |
includeValuesInResponse | boolean | No | Whether to include the written values in the response |
| 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 |
↳ spreadsheetId | string | Google Sheets spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Update data in a specific sheet 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. |
valueInputOption | string | No | The format of the data to update |
includeValuesInResponse | boolean | No | Whether to include the updated values in the response |
| 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 |
↳ spreadsheetId | string | Google Sheets spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Append data to the end of a specific sheet in 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. |
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 |
| 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 |
↳ spreadsheetId | string | Google Sheets spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Clear values from a specific range in a Google Sheets spreadsheet
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet |
sheetName | string | Yes | The name of the sheet/tab to clear |
cellRange | string | No | The cell range to clear (e.g. "A1:D10"). Clears entire sheet if not specified. |
| Parameter | Type | Description |
|---|
clearedRange | string | The range that was cleared |
sheetName | string | Name of the sheet that was cleared |
metadata | json | Spreadsheet metadata including ID and URL |
↳ spreadsheetId | string | Google Sheets spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Get metadata about a Google Sheets spreadsheet including title and sheet list
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet |
includeGridData | boolean | No | Whether to include grid data (cell values). Defaults to false. |
| Parameter | Type | Description |
|---|
spreadsheetId | string | The spreadsheet ID |
title | string | The title of the spreadsheet |
locale | string | The locale of the spreadsheet |
timeZone | string | The time zone of the spreadsheet |
spreadsheetUrl | string | URL to the spreadsheet |
sheets | array | List of sheets in the spreadsheet |
↳ sheetId | number | The sheet ID |
↳ title | string | The sheet title/name |
↳ index | number | The sheet index (position) |
↳ rowCount | number | Number of rows in the sheet |
↳ columnCount | number | Number of columns in the sheet |
↳ hidden | boolean | Whether the sheet is hidden |
Create a new Google Sheets spreadsheet
| Parameter | Type | Required | Description |
|---|
title | string | Yes | The title of the new spreadsheet |
sheetTitles | json | No | Array of sheet names to create (e.g., ["Sheet1", "Data", "Summary"]). Defaults to a single "Sheet1". |
locale | string | No | The locale of the spreadsheet (e.g., "en_US") |
timeZone | string | No | The time zone of the spreadsheet (e.g., "America/New_York") |
| Parameter | Type | Description |
|---|
spreadsheetId | string | The ID of the created spreadsheet |
title | string | The title of the created spreadsheet |
spreadsheetUrl | string | URL to the created spreadsheet |
sheets | array | List of sheets created in the spreadsheet |
↳ sheetId | number | The sheet ID |
↳ title | string | The sheet title/name |
↳ index | number | The sheet index (position) |
Read multiple ranges from a Google Sheets spreadsheet in a single request
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet |
ranges | json | Yes | Array of ranges to read (e.g., ["Sheet1!A1:D10", "Sheet2!A1:B5"]). Each range should include sheet name. |
majorDimension | string | No | The major dimension of values: "ROWS" (default) or "COLUMNS" |
valueRenderOption | string | No | How values should be rendered: "FORMATTED_VALUE" (default), "UNFORMATTED_VALUE", or "FORMULA" |
| Parameter | Type | Description |
|---|
spreadsheetId | string | The spreadsheet ID |
valueRanges | array | Array of value ranges read from the spreadsheet |
↳ range | string | The range that was read |
↳ majorDimension | string | Major dimension (ROWS or COLUMNS) |
↳ values | array | The cell values as a 2D array |
metadata | json | Spreadsheet metadata including ID and URL |
↳ spreadsheetId | string | Google Sheets spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Update multiple ranges in a Google Sheets spreadsheet in a single request
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet |
data | json | Yes | Array of value ranges to update. Each item should have "range" (e.g., "Sheet1!A1:D10") and "values" (2D array). |
valueInputOption | string | No | How input data should be interpreted: "RAW" or "USER_ENTERED" (default). USER_ENTERED parses formulas. |
| Parameter | Type | Description |
|---|
spreadsheetId | string | The spreadsheet ID |
totalUpdatedRows | number | Total number of rows updated |
totalUpdatedColumns | number | Total number of columns updated |
totalUpdatedCells | number | Total number of cells updated |
totalUpdatedSheets | number | Total number of sheets updated |
responses | array | Array of update responses for each range |
↳ spreadsheetId | string | The spreadsheet ID |
↳ updatedRange | string | The range that was updated |
↳ updatedRows | number | Number of rows updated in this range |
↳ updatedColumns | number | Number of columns updated in this range |
↳ updatedCells | number | Number of cells updated in this range |
metadata | json | Spreadsheet metadata including ID and URL |
↳ spreadsheetId | string | Google Sheets spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Clear multiple ranges in a Google Sheets spreadsheet in a single request
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the spreadsheet |
ranges | json | Yes | Array of ranges to clear (e.g., ["Sheet1!A1:D10", "Sheet2!A1:B5"]). Each range should include sheet name. |
| Parameter | Type | Description |
|---|
spreadsheetId | string | The spreadsheet ID |
clearedRanges | array | Array of ranges that were cleared |
metadata | json | Spreadsheet metadata including ID and URL |
↳ spreadsheetId | string | Google Sheets spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Copy a sheet from one spreadsheet to another
| Parameter | Type | Required | Description |
|---|
sourceSpreadsheetId | string | Yes | The ID of the source spreadsheet |
sheetId | number | Yes | The ID of the sheet to copy (numeric ID, not the sheet name). Use Get Spreadsheet to find sheet IDs. |
destinationSpreadsheetId | string | Yes | The ID of the destination spreadsheet where the sheet will be copied |
| Parameter | Type | Description |
|---|
sheetId | number | The ID of the newly created sheet in the destination |
title | string | The title of the copied sheet |
index | number | The index (position) of the copied sheet |
sheetType | string | The type of the sheet (GRID, CHART, etc.) |
destinationSpreadsheetId | string | The ID of the destination spreadsheet |
destinationSpreadsheetUrl | string | URL to the destination spreadsheet |