Skip to main content
Version: Current

Read Cell Range

Description​

Reads data from a range of cells in a Google Sheet and returns the data in a structured format.

The activity supports header-based column mapping, duplicate column handling, and data transposition.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

Design-Time Configuration​

Display Text​

A user-defined name for the activity, displayed on the workflow canvas to help identify its purpose.

Connection Name​

The configured Google Sheets connection used to access Google Sheets resources.

Spreadsheet​

The spreadsheet containing the data to read.

Sheet Name​

The name of the sheet where the operation will be performed.

If not specified, the currently active sheet is used.

Cell Range​

The range of cells to read.

Include Header​

Determines whether the first row of the selected range is treated as column headers.

When enabled, the first row is used to define column names and is excluded from the returned data rows.

Exclude Duplicate Columns​

Determines whether duplicate column names are excluded from the returned data.

When enabled, only unique column names are included in the output.

Transpose​

Determines whether rows and columns are exchanged in the returned data.

When enabled:

  • Rows become columns
  • Columns become rows
info

For details about selecting spreadsheets, sheets, and ranges, see Google Sheets Data Selection.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when:

  • Any incoming path completes, or
  • All relevant incoming paths complete before execution

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include:

  • Fault
  • Continue
  • Suspend
  • Retry

Learn more → Error Handling

Output​

Data​

The data read from the specified cell range in a structured tabular format.

The returned data can be used by subsequent activities for processing, filtering, transformation, or iteration.

Remarks​

  • The authenticated Google account must have access to the spreadsheet.
  • Only data within the specified range is returned.
  • When Include Header is enabled, the first row is treated as column names and is not returned as a data row.
  • When Exclude Duplicate Columns is enabled, duplicate column names are removed from the returned data structure.
  • When Transpose is enabled, rows and columns are exchanged before the data is returned.
  • Empty cells are included in the output as empty values.