Google Sheets is a 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 integrates with many tools and services.
With the Google Sheets integration in AACFlow.io, you can:
- Read data: Retrieve cell values from specific ranges in a spreadsheet
- Write data: Write values to specific cell ranges
- Update data: Modify existing cell values in a spreadsheet
- Append rows: Add new rows of data to the end of a sheet
- Clear ranges: Remove data from specific cell ranges
- Manage spreadsheets: Create new spreadsheets or retrieve metadata about existing ones
- Batch operations: Perform batch read, update, and clear operations across multiple ranges
- Copy sheets: Duplicate sheets within or between spreadsheets
In AACFlow.io, the Google Sheets integration enables your agents to read from, write to, and manage spreadsheets as part of automated workflows. This is ideal for automated reporting, data synchronization, record-keeping, and building data pipelines that use spreadsheets as a collaborative data layer.
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 | Google Sheets spreadsheet ID |
sheetName | string | Yes | The name of the sheet/tab to read from |
cellRange | string | No | The cell range to read (e.g. "A1:D10"). Defaults to "A1:Z1000" if not specified. |
filterColumn | string | No | Column name (from the header row) to filter on. Filtering is applied to the rows returned by the read range (the default is A1:Z1000), not the entire sheet. If not provided, no filtering is applied. |
filterValue | string | No | Value to match against the filter column. |
filterMatchType | string | No | How to match the filter value. Text: "contains", "not_contains", "exact", "not_equals", "starts_with", "ends_with". Numeric/ordering: "gt", "gte", "lt", "lte" (numeric when both values are numbers, otherwise lexicographic). Defaults to "contains". |
| 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 | Google Sheets spreadsheet ID |
sheetName | string | Yes | The name of the sheet/tab to write to |
cellRange | string | No | The cell range to write to (e.g. "A1:D10", "A1"). Defaults to "A1" if not specified. |
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 | Google Sheets spreadsheet ID |
sheetName | string | Yes | The name of the sheet/tab to update |
cellRange | string | No | The cell range to update (e.g. "A1:D10", "A1"). Defaults to "A1" if not specified. |
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 | Google Sheets spreadsheet ID |
sheetName | string | Yes | The name of the sheet/tab to append to |
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 | Google Sheets spreadsheet ID |
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 | Google Sheets spreadsheet ID |
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 | Google Sheets spreadsheet ID |
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 | Google Sheets spreadsheet ID |
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 | Google Sheets spreadsheet ID |
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 | Source Google Sheets spreadsheet ID |
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 |
Delete rows from a sheet in a Google Sheets spreadsheet
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | Google Sheets spreadsheet ID |
sheetId | number | Yes | The numeric ID of the sheet/tab (not the sheet name). Use Get Spreadsheet to find sheet IDs. |
startIndex | number | Yes | The start row index (0-based, inclusive) of the rows to delete |
endIndex | number | Yes | The end row index (0-based, exclusive) of the rows to delete |
| Parameter | Type | Description |
|---|
spreadsheetId | string | Google Sheets spreadsheet ID |
sheetId | number | The numeric ID of the sheet |
deletedRowRange | string | Description of the deleted row range |
metadata | json | Spreadsheet metadata including ID and URL |
↳ spreadsheetId | string | Google Sheets spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Delete a sheet/tab from a Google Sheets spreadsheet
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | Google Sheets spreadsheet ID |
sheetId | number | Yes | The numeric ID of the sheet/tab to delete (not the sheet name). Use Get Spreadsheet to find sheet IDs. |
| Parameter | Type | Description |
|---|
spreadsheetId | string | Google Sheets spreadsheet ID |
deletedSheetId | number | The numeric ID of the deleted sheet |
metadata | json | Spreadsheet metadata including ID and URL |
↳ spreadsheetId | string | Google Sheets spreadsheet ID |
↳ spreadsheetUrl | string | Spreadsheet URL |
Permanently delete a Google Sheets spreadsheet using the Google Drive API
| Parameter | Type | Required | Description |
|---|
spreadsheetId | string | Yes | The ID of the Google Sheets spreadsheet to delete |
| Parameter | Type | Description |
|---|
spreadsheetId | string | The ID of the deleted spreadsheet |
deleted | boolean | Whether the spreadsheet was successfully deleted |
A Trigger is a block that starts a workflow when an event happens in this service.
These run on a schedule (polling-based) — they check for new data rather than receiving push notifications.
Triggers when new rows are added to a Google Sheet
| Parameter | Type | Required | Description |
|---|
triggerCredentials | string | Yes | Connect your Google account to access Google Sheets. |
spreadsheetId | file-selector | Yes | The spreadsheet to monitor for new rows. |
manualSpreadsheetId | string | Yes | The spreadsheet to monitor for new rows. |
sheetName | sheet-selector | Yes | The sheet tab to monitor for new rows. |
manualSheetName | string | Yes | The sheet tab to monitor for new rows. |
valueRenderOption | string | No | How values are rendered. Formatted returns display strings, Unformatted returns raw numbers/booleans, Formula returns the formula text. |
dateTimeRenderOption | string | No | How dates and times are rendered. Only applies when Value Render is not |
| Parameter | Type | Description |
|---|
row | json | Row data mapped to column headers from row 1 |
rawRow | json | Raw row values as an array |
headers | json | Column headers from row 1 |
rowNumber | number | The 1-based row number of the new row |
spreadsheetId | string | The spreadsheet ID |
sheetName | string | The sheet tab name |
timestamp | string | Event timestamp in ISO format |