Read Cell

UiPath.GSuite.Activities.ReadCell

Description

Reads the value from a specified cell in a Google spreadsheet.

Scopes

This activity requires the following scopes:

• https://www.googleapis.com/auth/drive.readonly

OR

• https://www.googleapis.com/auth/spreadsheets.readonly

OR

• https://www.googleapis.com/auth/spreadsheets

OR

• https://www.googleapis.com/auth/drive

Project compatibility

Windows - Legacy | Windows

Configuration

In the Body of the Activity

• Spreadsheet - A reference to a Google Spreadsheet from which to read the data. Typically obtained via the Use Google Spreadsheet activity. This property supports IGoogleSheetTarget variables.
• Sheet - The name of the sheet that includes the cell you want to read. This property supports String variables and string formatted values. The default value is "Sheet1".
• Cell - The cell to read from. The default value is "A1". This property supports String variables and string formatted values.
• Save to - The variable into which the read value will be saved. This property supports String variables and string formatted values.

Properties Panel

Common

• ContinueOnError - If set, the remaining activities are executed if the current activity fails. This field supports Boolean values.
• DisplayName - The display name of the activity. This property supports String variables and string formatted values.

Input

• CellAddress - See Cell in the body of the activity.
• Spreadsheet - See Spreadsheet in the body of the activity.
• SheetName - See Sheet in the body of the activity.
• SpreadsheetID - The ID of the spreadsheet file to use.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.

Output

• CellValue - See Save to in the body of the activity.