Integrations
Google Sheets
25 actions for Google Sheets.
Google Sheet Retriever#
Get the content of your Google sheet.
Plans: Trial, Pro, Premium, Enterprise · Type: GoogleSheetsRetriever
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a spreadsheet from Google Drive. |
| Document ID | Text | No | (empty) | The Google Sheets document ID or URL (can be passed from upstream flow). |
| Sheets | Choice | Yes | — | The sheet to retrieve from the document. |
Outputs#
| Output | Type |
|---|---|
| Data | Any |
| Row Count | Any |
| Column Count | Any |
| Columns | Any |
| Document Id | Any |
| Sheet Id | Any |
Use as an agent tool#
Tool name: google_sheets_retriever
Retrieve and read the content of a Google Sheets document
Add Column in Google Sheets#
Adds a new column in an existing Google Sheets document, populated with values provided by the user.
Plans: Trial, Pro, Premium, Enterprise · Type: SheetsAddColumn
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheets | Choice | Yes | — | The sheet to retrieve from the document. |
| Column Name | Text | No | (empty) | The name of the new column to be added. |
| Column Value | Text | No | (empty) | Values to populate the new column; can be a comma-separated string. |
| Separator | Text | No | , | Separator for column values. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Column Name | Text |
| Result | Text |
Use as an agent tool#
Tool name: google_sheets_add_column
Add a new column to an existing Google Sheet with values
Add Row in Google Sheets#
Adds a new row in an existing Google Sheets given by document ID.
Plans: Trial, Pro, Premium, Enterprise · Type: SheetsAddRow
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheets | Choice | Yes | — | The sheet to retrieve from the document. |
| Data | List | No | — | Data to be added. Each key of the data corresponds to a column. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Result | Text |
Use as an agent tool#
Tool name: google_sheets_add_row
Add a new row to an existing Google Sheet
Clear Cell in Google Sheets#
Clears the content of a specific cell in a Google Sheet (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsClearCell
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet to operate on. |
| Cell Reference | Text | No | (empty) | Cell in A1 notation, e.g. ‘B3’. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Cell Reference | Text |
| Cleared | Yes/No |
Use as an agent tool#
Tool name: google_sheets_clear_cell
Clear the content of a specific cell in a Google Sheet
Clear Rows in Google Sheets#
Clears the content of a row range in a Google Sheet (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsClearRows
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet to operate on. |
| Start Row | Text | No | 1 | 1-based start row. |
| End Row | Text | No | 1 | 1-based end row (inclusive). |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Cleared Count | Number |
Use as an agent tool#
Tool name: google_sheets_clear_rows
Clear the content of a row range in a Google Sheet
Copy Spreadsheet in Google Sheets#
Creates a copy of an entire Google Sheets spreadsheet.
Plans: Trial, Pro, Premium, Enterprise · Type: SheetsCopySpreadsheet
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select the spreadsheet to copy from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document to copy. |
| New Name | Text | No | (empty) | Name for the copied spreadsheet (optional). |
Outputs#
| Output | Type |
|---|---|
| Source Document Id | Text |
| New Document Id | Text |
| Url | Text |
Use as an agent tool#
Tool name: google_sheets_copy_spreadsheet
Copy an entire Google Sheets spreadsheet
Copy Worksheet in Google Sheets#
Copies a worksheet from one spreadsheet to another (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsCopyWorksheet
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Source Document | Google Drive file | No | (empty) | Select the source spreadsheet from Google Drive. |
| Source Document ID | Text | No | (empty) | The ID of the source Google Sheet document. |
| Source Sheet | Choice | Yes | — | The sheet (tab) to copy. |
| Destination Document ID | Text | No | (empty) | The ID of the destination spreadsheet. |
Outputs#
| Output | Type |
|---|---|
| Source Document Id | Text |
| Destination Document Id | Text |
| New Sheet Id | Any |
| Title | Any |
Use as an agent tool#
Tool name: google_sheets_copy_worksheet
Copy a worksheet from one Google Sheets spreadsheet to another
Create Google Sheet#
Creates a Google Sheet from List of Data object(s) in a flow.
Plans: Trial, Pro, Premium, Enterprise · Type: SheetsCreate
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| File Name | Text | No | (empty) | The name of the file to be created in Google Spreadsheet. |
| Data | List | No | — | Data or List of Data to be added as rows to SpreadSheet. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Document Name | Text |
Use as an agent tool#
Tool name: google_sheets_create
Create a new Google Sheet from data
Create Worksheet in Google Sheets#
Creates a new worksheet (tab) in an existing spreadsheet (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsCreateWorksheet
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Worksheet Title | Text | No | (empty) | The name for the new worksheet tab. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Sheet Id | Any |
| Title | Any |
Use as an agent tool#
Tool name: google_sheets_create_worksheet
Create a new worksheet tab in an existing Google Sheets spreadsheet
Delete Row in Google Sheets#
Deletes the first row matching a lookup value in a specified column.
Plans: Trial, Pro, Premium, Enterprise · Type: SheetsDeleteRow
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet to operate on. |
| Lookup Column | Text | No | (empty) | The column name to search in. |
| Lookup Value | Text | No | (empty) | The value to match in the lookup column. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Deleted | Yes/No |
| Row Index | Any |
| Row Data | Object |
Use as an agent tool#
Tool name: google_sheets_delete_row
Delete the first row matching a lookup value in a Google Sheet column
Delete Rows in Google Sheets#
Deletes a range of rows from a Google Sheet (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsDeleteRows
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet to operate on. |
| Start Row | Text | No | 1 | 1-based row index to start deleting from (excludes header). |
| End Row | Text | No | 1 | 1-based row index to stop deleting at (inclusive). |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Deleted Count | Number |
Use as an agent tool#
Tool name: google_sheets_delete_rows
Delete a range of rows from a Google Sheet
Delete Worksheet in Google Sheets#
Deletes a worksheet (tab) from a spreadsheet (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsDeleteWorksheet
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The worksheet (tab) to delete. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Deleted Sheet Id | Number |
Use as an agent tool#
Tool name: google_sheets_delete_worksheet
Delete a worksheet tab from a Google Sheets spreadsheet
Find Row in Google Sheets#
Finds the first row matching a lookup value and returns its data and index.
Plans: Trial, Pro, Premium, Enterprise · Type: SheetsFindRow
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet to search in. |
| Lookup Column | Text | No | (empty) | The column name to search in. |
| Lookup Value | Text | No | (empty) | The value to match in the lookup column. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Found | Yes/No |
| Row Index | Any |
| Row Data | Object |
Use as an agent tool#
Tool name: google_sheets_find_row
Find the first row matching a lookup value in a Google Sheet
Get Cell from Google Sheets#
Gets the value of a specific cell in a Google Sheet (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsGetCell
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet to read from. |
| Cell Reference | Text | No | (empty) | Cell in A1 notation, e.g. ‘B3’. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Cell Reference | Text |
| Value | Text |
Use as an agent tool#
Tool name: google_sheets_get_cell
Get the value of a specific cell in a Google Sheet
Get Range from Google Sheets#
Gets values from a range of cells in a Google Sheet (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsGetRange
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet to read from. |
| Range | Text | No | (empty) | Range in A1 notation, e.g. ‘A1:D10’. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Range | Text |
| Row Count | Number |
| Rows | List |
Use as an agent tool#
Tool name: google_sheets_get_range
Get values from an A1-notation range in a Google Sheet
Get Spreadsheet Info from Google Sheets#
Gets metadata for a spreadsheet including title and list of sheets (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsGetSpreadsheetInfo
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
Outputs#
| Output | Type |
|---|---|
| Spreadsheet Id | Text |
| Title | Any |
| Locale | Any |
| Sheets | List |
Use as an agent tool#
Tool name: google_sheets_get_spreadsheet_info
Get metadata for a Google Sheets spreadsheet
Insert Comment in Google Sheets#
Adds a comment to a Google Sheets spreadsheet via Drive API (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsInsertComment
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Comment Text | Text | No | (empty) | The comment content to add. |
| Cell Reference (optional) | Text | No | (empty) | Optional cell anchor in A1 notation, e.g. ‘B3’. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Comment Id | Any |
| Content | Any |
Use as an agent tool#
Tool name: google_sheets_insert_comment
Add a comment to a Google Sheets spreadsheet
Insert Note in Google Sheets#
Adds a note to a specific cell in a Google Sheet (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsInsertNote
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet containing the target cell. |
| Cell Reference | Text | No | (empty) | Cell in A1 notation, e.g. ‘B3’. |
| Note Text | Text | No | (empty) | The note content to add to the cell. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Cell Reference | Text |
| Note Added | Yes/No |
Use as an agent tool#
Tool name: google_sheets_insert_note
Add a note to a specific cell in a Google Sheet
List Worksheets in Google Sheets#
Lists all worksheets (tabs) in a Google Sheets spreadsheet (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsListWorksheets
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Worksheets | List |
| Count | Number |
Use as an agent tool#
Tool name: google_sheets_list_worksheets
List all worksheets in a Google Sheets spreadsheet
Request Google Sheets File Access#
Requests the user to grant file-level access to a Google Sheets document. Use when the agent encounters a 404 or permission error accessing a spreadsheet.
Plans: Pro, Premium, Enterprise · Type: SheetsRequestFileAccess
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document ID | Text | No | (empty) | The ID of the Google Sheet document that needs access. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Document Type | Text |
| Access Requested | Yes/No |
| Message | Any |
Use as an agent tool#
Tool name: google_sheets_request_file_access
Request the user to grant file-level access to a Google Sheets document. Call this tool when a Google Sheets operation fails with a 404 error or permission/access denied error, which usually means the app does not have access to the specific file.
Update Cell in Google Sheets#
Updates the value of a specific cell in a Google Sheet (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsUpdateCell
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet to operate on. |
| Cell Reference | Text | No | (empty) | Cell in A1 notation, e.g. ‘B3’. |
| Value | Text | No | (empty) | The new value to write into the cell. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Cell Reference | Text |
| Value | Text |
Use as an agent tool#
Tool name: google_sheets_update_cell
Update the value of a specific cell in a Google Sheet
Update Column in Google Sheets#
Updates an existing column’s values in a Google Sheet.
Plans: Trial, Pro, Premium, Enterprise · Type: SheetsUpdateColumn
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet to operate on. |
| Column Name | Text | No | (empty) | The name of the column to update (must already exist). |
| Column Values | Text | No | (empty) | Values to write into the column; can be separator-delimited. |
| Separator | Text | No | , | Separator used to split column values. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Column Name | Text |
| Result | Text |
Use as an agent tool#
Tool name: google_sheets_update_column
Update an existing column’s values in a Google Sheet
Update Formatting in Google Sheets#
Applies formatting (bold, color, font size, etc.) to a cell range (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsUpdateFormatting
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet containing the range to format. |
| Range | Text | No | (empty) | Range in A1 notation, e.g. ‘A1:D5’. |
| Formatting Options | Object | No | — | JSON object with formatting keys: bold, italic, font_size, bg_color (#RRGGBB), text_color (#RRGGBB), horizontal_alignment (LEFT/CENTER/RIGHT), number_format. It must be between quotation marks, like this: ’’ (for example: ‘#RRGGBB’). |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Range | Text |
| Formatted | Yes/No |
Use as an agent tool#
Tool name: google_sheets_update_formatting
Apply formatting to a range of cells in a Google Sheet
Update Multiple Rows in Google Sheets#
Updates multiple rows starting at a specified row index (Premium).
Plans: Pro, Premium, Enterprise · Type: SheetsUpdateMultipleRows
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheet | Choice | Yes | — | The sheet to operate on. |
| Start Row | Text | No | 1 | 1-based data row index to start writing at. |
| Data | List | No | — | List of row dicts to write. Keys must match column headers. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Updated Count | Number |
Use as an agent tool#
Tool name: google_sheets_update_multiple_rows
Update multiple rows in a Google Sheet starting at a given row index
Update Row in Google Sheets#
Updates a row in an existing Google Sheets given by document ID.
Plans: Trial, Pro, Premium, Enterprise · Type: SheetsUpdateRow
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Document | Google Drive file | No | (empty) | Select a google sheet from Google Drive. |
| Document ID | Text | No | (empty) | The ID of the Google Sheet document. |
| Sheets | Choice | Yes | — | The sheet to retrieve from the document. |
| Row Index | Text | No | (empty) | The index of the row to be updated. |
| Data | List | No | — | Data to update. Each key of the data corresponds to a column. |
Outputs#
| Output | Type |
|---|---|
| Document Id | Text |
| Row Index | Number |
| Result | Text |
Use as an agent tool#
Tool name: google_sheets_update_row
Update an existing row in a Google Sheet