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

​
Configuration

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:
If you want to reference a specific field from the created spreadsheet object, insert it from the variable picker after a test run:
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:
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