# Google Sheets

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:

```json
[
  { "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](https://docs.fetchhive.com/your-workspace/integrations), [Creating and Editing](https://docs.fetchhive.com/workflows/creating-and-editing), and [Testing and Iteration](https://docs.fetchhive.com/workflows/testing-and-iteration)