Read Row

UiPath.GSuite.Activities.ReadRowConnections

Description

Reads all the cells that include content in a specified spreadsheet row.

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

Configuration

Input

• Add new connection - You must connect to Google Sheets to use this activity.
• Spreadsheet - The spreadsheet from which the row is read. 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 sheet that includes the row you want to read. This property supports String variables and string formatted values.
• Starting cell - The first cell of the row. All cells that contain content in the specified row are read. Also, all cells are read until the last completed cell. This property supports String variables and string formatted values.

Properties

• Result - Stores the value of the row in an output vairable.