activities
latest
false
UiPath logo, featuring letters U and I in white
Productivity Activities
Last updated Nov 15, 2024

Read Row

UiPath.GSuite.Activities.ReadColumn

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 - 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
  • SheetName - The name of the sheet that includes the row you want to read. This property supports String variables and string formatted values. The default value is "Sheet1".
  • SpreadSheetID - The ID of the Spreadsheet that includes the sheet and row you want to read. This property supports String variables and string formatted values. When entering your value, use the exact File ID, or the output property variable from a previous Find Files And Folders or Create New SpreadSheet activity.
  • StartingCellAddress - The address of the first cell in the row. This property supports String variables and string formatted values. The default value is "A1". All cells that contain content in the row specified are read.
Misc
  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.
Output
  • Row - The contents of the row as an array of objects. This property supports Object array variables. You can use this variable as an input property value in other Google Workspace activities.
  • Description
  • Project compatibility
  • Configuration

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.