Skip to main content

Read Cell

Description​

This activity reads a value from the specified spreadsheet cell and stores it in a variable.

note

This activity works only inside Google Context activity.

Properties​

Location​

  • Spreadsheet Path / Id - Specify the relative spreadsheet path or id in the drive.
  • Cell Address - Specify a cell address from which you want to read the value.

Misc​

  • DisplayName – Add a display name to your activity.
  • Private – Logs the variable and argument values at the Verbose level when unchecked.

Optional​

  • Sheet Name - It specifies the sheet's name from where you want to read the data. By default, it will fetch from the currently active sheet.
  • Continue On Error – Specifies if the automation should continue even when the Activity throws an error. This field only supports Boolean values (True, False). The default value is False.
    note

    Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.

Output​

  • Cell Value - Returns the value of the cell.

Example​

Download Example

Read Cell