Write Cell

UiPath.GSuite.Activities.WriteCell

Description

Writes a value into a specified cell in a Google spreadsheet.

Scopes

This activity requires the following scopes:

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

OR

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

Project compatibility

Windows - Legacy | Windows

Configuration

In the Body of the Activity

• Spreadsheet - A reference to a Google Spreadsheet where the cell is to be written. 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 write in. This property supports String variables and string formatted values. The default value is "Sheet1".
• Cell - The address of the cell that you want to write in. This property supports String variables and string formatted values. The default value is "A1".
• Value - The content you want to write. 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

• Cell address - See Cell in the body of the activity.
• Google spreadsheet - See Spreadsheet in the body of the activity.
• Sheet name - See Sheet in the body of the activity.
• Spreadsheet ID - The ID of the spreadsheet file to use. This property supports String variables and string formatted values.
• Value - See Value in the body of the activity.

Misc

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