Skip to main content

​
Overview

The Google Sheets block connects your workflows to Google Sheets. Use it to read data from spreadsheets as workflow inputs or append results back to sheets for reporting and data collection.

​
Configuration

​
Connect Google Account

Select the Google account connection to use. You can connect multiple Google accounts and choose which one to use for each block. To add a new connection:
  1. Click the connection dropdown
  2. Select “Add new connection”
  3. Sign in with your Google account and grant permissions

​
Select Spreadsheet

Choose the Google Sheets file to work with. Two ways to select:
  1. Browse: Search and select from your Google Drive
  2. Paste URL: Paste a Google Sheets URL directly

​
Select Sheet

Choose the specific sheet (tab) within your spreadsheet. Each spreadsheet can have multiple sheets.

​
Header Row

Indicate whether the first row contains column headers.
  • Yes: First row is treated as headers (data starts from row 2)
  • No: All rows are treated as data (data starts from row 1)
When enabled, column names from the header row are used in the output.

​
Action

Select the operation to perform. Options:
  • Read Spreadsheet: Retrieve data from the sheet
  • Append Spreadsheet: Add new rows to the sheet

​
Read Spreadsheet

Use this action to pull data from a Google Sheet into your workflow.

​
Row Range

Specify which rows to read. Format: Start row to end row
  • If header row is enabled, start from row 2 or higher
  • If header row is disabled, start from row 1 or higher
  • End row must be greater than or equal to start row
Example: Rows 2 to 100 reads rows 2 through 100. Leave empty to read all rows in the sheet.

​
Column Fields

Select which columns to include in the output. By default, the first 4 columns are selected. Click to add or remove columns from the output. Each column in the output includes:
  • Column number: Position in the sheet (A=1, B=2, etc.)
  • Column name: Header text if header row is enabled, or auto-generated name (Column A, Column B)

​
Read Output

The read action returns an array of row objects. Each object contains the selected column values. Example output with headers: 
[
  {
    "Name": "John Smith",
    "Email": "[email protected]",
    "Status": "Active"
  },
  {
    "Name": "Jane Doe",
    "Email": "[email protected]",
    "Status": "Pending"
  }
]
Access this data in subsequent blocks using {{step_n.output}} or loop through rows with {% for row in step_n.output %}.

​
Append Spreadsheet

Use this action to add new rows to a Google Sheet.

​
Data

Provide the data to append. This field supports placeholders to reference data from previous steps. Format: JSON array of arrays or array of objects Array of arrays example: 
[
  ["John Smith", "[email protected]", "Active"],
  ["Jane Doe", "[email protected]", "Pending"]
]
Array of objects example: 
[
  {"name": "John Smith", "email": "[email protected]", "status": "Active"},
  {"name": "Jane Doe", "email": "[email protected]", "status": "Pending"}
]
Use placeholders to reference previous step outputs: 
{{step_1.output}}

​
Column Mappings

Map your data fields to spreadsheet columns. For each column in your sheet, specify which data field should fill it. Example mapping:
Sheet ColumnData Field
Column A (Name){{current.columns[0]}} or {{current.columns.name}}
Column B (Email){{current.columns[1]}} or {{current.columns.email}}
Column C (Status){{current.columns[2]}} or {{current.columns.status}}
Use current.columns[index] for array data or current.columns.fieldName for object data.

​
Append Output

The append action returns the number of rows added. Example output: 
{
  "rowsAdded": 2
}

​
Error Handling

Define what happens if the Google Sheets block fails. Options:
  1. Terminate Workflow: Stop execution immediately
  2. Continue Execution: Proceed to next step despite error
Common errors:
  • Connection expired (re-authenticate your Google account)
  • Spreadsheet not found (check sharing permissions)
  • Invalid range (verify row/column selections)

​
Best Practices

  • Use header rows for easier data access with named fields
  • Set specific row ranges instead of reading entire sheets for large datasets
  • Validate data format before appending to avoid errors
  • Use column mappings to ensure data lands in correct columns
  • Test with a small dataset before running on large-scale workflows
  • Share spreadsheets with your connected Google account if owned by others

​
Common Use Cases

Use CaseConfiguration Tips
Import leads listRead action, select name/email columns, use in LLM for personalization
Export workflow resultsAppend action, map LLM outputs to columns
Data enrichmentRead source data, process with other blocks, append enriched data to new sheet
Report generationRead multiple sheets, combine data, append summary to report sheet
Batch content processingRead topics from sheet, loop through each, append generated content

​
What’s Next

Now that you understand the Google Sheets block: