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 settings
Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.
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.
For details about selecting spreadsheets, sheets, and cells, see Google Sheets Data Selection.
Execution settings
Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.
Output
Result
A ReadCellDto containing:
| Field | Type | Description |
|---|---|---|
| CellValue | String | Formatted/calculated value returned for the cell; empty string when no value is returned. |
| RawResult | Object | Response details: Range, MajorDimension, Values, and ETag. |
Bind Result → CellValue when the next activity needs text. Use Read Cell Formula when the formula expression is required.
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.
Example: Read a total
Set Sheet Name to Orders and Cell Address to D10. Bind Result → CellValue to a downstream text field. If D10 contains a formula, this activity returns its formatted result.