Google Sheets

Configure a workflow step that creates a Google Sheet from structured workflow data using a connected Google account

Use Google Sheets when you want a workflow step to create a spreadsheet from structured workflow data.

Configuration

Option	Required	Description
Name	No	Label for the step in the workflow canvas.
Integration Authorization	Yes	The connected Google account selected in Authentication.
Action	Yes	The Google Sheets action. The current editor shows Create Spreadsheet.
Title	Yes	Value entered in Title.
JSON Data	Yes	Value entered in JSON Data (Array of Objects).
When the step fails	No	Controls whether the workflow should Terminate Workflow or Continue if this step fails.
Before you configure this step, connect Google in Integrations for your workspace. If no active Google Sheets connection is available, the step shows a warning with a link to Integrations.

Use the Insert Variable button next to Title and JSON Data (Array of Objects) if those values should come from start inputs or earlier workflow steps.

The editor describes the expected input format directly: each object becomes a row, and keys become column headers.

Output

This step stores the created Google Sheets spreadsheet object as the step output.

Use the full output reference in later steps:

{{STEP_IDENTIFIER.output}}

If you want to reference a specific field from the created spreadsheet object, insert it from the variable picker after a test run:

{{step_2.output.spreadsheet_id}}

The exact keys depend on the returned Google Sheets response shown in your workflow output.

Example

Open Integrations and connect Google if needed.

Add Google Sheets to your workflow and choose the account in Authentication.

Keep Action set to Create Spreadsheet.

Enter a spreadsheet name in Title.

In JSON Data (Array of Objects), pass structured data such as:

[
  { "Name": "John", "Age": 20 },
  { "Name": "Jane", "Age": 30 }
]

When the step runs, Fetch Hive creates a spreadsheet, uses the object keys as column headers, and writes each object as a row.

Notes

• The current editor exposes one Google Sheets action: Create Spreadsheet.

• The UI is optimized for a JSON array of objects, but the backend can still process other input formats.

• Test the step once before wiring nested output fields into later steps so you can confirm the returned response shape.

See also: Integrations, Creating and Editing, and Testing and Iteration