Skip to main content
Version: Current

Read Cell

Description​

Reads the value of a cell from a Google Sheet.

Unlike the Read Cell Formula activity, this activity returns the calculated or displayed value of the cell rather than the underlying formula.


Common Capabilities​

Process Data Support​

info

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

You can bind values from Agent Data, Workflow 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 cell 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 Address​

The cell whose value will be read.

info

For details about selecting spreadsheets, sheets, and cells, 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​

Value​

The value contained in the specified cell.

The returned value reflects the calculated or displayed value of the cell.

Metadata​

Additional information associated with the cell value.


Remarks​

  • The authenticated Google account must have access to the spreadsheet.
  • This activity returns the calculated or displayed value of the cell.
  • If the cell contains a formula, the evaluated result of the formula is returned.
  • Empty cells return an empty value.
  • To retrieve the underlying formula instead of the calculated value, use the Read Cell Formula activity.