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 or Update Values and pass the spreadsheet ID from the create step.

​
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