Skip to main content
Use Google Sheets when you want a workflow step to create a spreadsheet, search existing files, read sheet data, or append and update values in a connected account.

​
Configuration

Before you configure this step, connect Google Sheets in Integrations for your workspace using the OAuth flow. If no active connection is available, the step shows a warning with a link to Integrations instead of the account selector.

​
Arguments form

When you select an action, the Arguments section automatically renders a form driven by the action’s input schema. Each field includes:
  • A label and description from the action’s schema.
  • An Insert Variable button next to eligible fields that injects references like {{step_1.output.id}} at the cursor position.
  • Validation feedback inline if a required field is left empty.
Switch to the Raw JSON tab for power users or when you prefer to write the full arguments object by hand. Changes in either tab stay in sync.

​
Common actions

Destructive actions such as clearing ranges or deleting sheets are not exposed in the workflow action picker.

​
Output

This step stores the Google Sheets API response as the step output. The shape of the response depends on the action. Use the full output reference in later steps:
For example, after a Create Spreadsheet step you might reference the returned spreadsheet ID:
Use the variable picker after a test run to confirm the exact keys available in your workflow.

​
Example

  1. Open Integrations and connect Google Sheets if you have not already done that.
  2. Add a Google Sheets step to your workflow.
  3. Select a connected account in Authentication.
  4. Choose Create Spreadsheet in Action.
  5. In the Arguments form, fill in the title. Use Insert Variable to reference an earlier step’s output for any field value.
  6. Click Run in the step header to test the action, then review the returned payload in Output.
To write rows after creating a spreadsheet, add a second Google Sheets step that uses Append Values, Update Values, or Upsert Rows, and pass the spreadsheet ID from the create step.

​
Populate a new sheet from another step

The usual path is create a spreadsheet, then fill it with a large dataset from an earlier step such as AI Keyword Data Search or Extract from File.
  1. Add a Data Transform step and choose Objects to Grid. Set Source Value to an array of objects. For Extract from File, use {{step_1.output}}. For AI Keyword Data Search, use {{step_1.output.items}}. Leave Headers blank unless you want a specific column order.
  2. Add a Google Sheets Create Spreadsheet step and set the title.
  3. Add a Google Sheets Upsert Rows step:
    • Set Spreadsheet Id to the Create Spreadsheet step output, for example {{step_3.output.spreadsheetId}}.
    • Set Sheet Name to Sheet1 (Create Spreadsheet adds this default tab).
    • Set Headers to the Data Transform output, for example {{step_2.output.headers}}.
    • Set Rows to the Data Transform output, for example {{step_2.output.rows}}.
You do not need to calculate A1 ranges or enter one cell at a time. Use Insert Variable on the Headers and Rows fields, or paste the placeholders in the Raw JSON tab. Create Spreadsheet adds a default Sheet1 tab. If you need a different tab name, add a Google Sheets Add Sheet step before Upsert Rows.

​
Notes

  • This step depends on a connected Google Sheets integration in your workspace.
  • The workflow action picker shows a curated subset of spreadsheet actions. Agents with the Google Sheets tool can access additional safe actions.
  • OAuth may show third-party authorization branding during the connect flow.
  • If a previous connection stops working, reconnect Google Sheets in Integrations, then select the new account in Authentication.

​
Using Google Sheets as an Agent Tool

You can also add Google Sheets as a tool in the Agent Editor. Open the agent, click Add tool, and select Google Sheets. In the tool settings panel, choose the connected account the agent should use. The agent will call Google Sheets actions automatically during conversations when relevant. See also: Integrations, Creating and Editing, and Testing and Iteration