Productivity activities

Get Cell Color

Description​

Scopes​

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

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

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

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

Project compatibility​

Configuration​

Input​

• Add new connection - You must connect to Google Sheets to use this activity.
• Spreadsheet - The spreadsheet where the autocomplete will be performed. This property supports String variables and string formatted values.
• Spreadsheet sample - Select a file with the same range and column structure as the variable file. This field becomes visible when you select the Use spreadsheet template option.
• Sheet name - The name of the new sheet that includes the cell that you want to get the color from. If left blank, Google Sheets determines the name of the new sheet. This property supports String variables and string formatted values.
• Cell - The cell that you want to read in order to get the color from. Leave the cell empty if a named range is selected in Sheet or named range. This property supports String variables and string formatted values.

Output​

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