Get Cell Color

UiPath.GSuite.Activities.GetCellColor

Description

Reads the value of a cell from 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

Properties

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 - The address of the cell that you want to get the color from. This property supports String variables and string formatted values. The default value is "A1".
• SheetName - The name of the sheet that includes the cell that you want to get the color from. This property supports String variables and string formatted values. The default value is "Sheet1".
• SpreadSheetID - The ID of the spreadsheet that you want to retrieve information from. This property supports String variables and string formatted values. When entering your value, use the exact ID, or the output property variable from a previous Find Files and Folders or Create New Spreadsheet activity.

Misc

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

Output

• Color - The color of the cell returned as a RGBA value. This property supports Color variables.
• HexColor - The color of the cell returned as a HEX value. This property supports String variables.