activities
latest
false
UiPath logo, featuring letters U and I in white

Productivity Activities

Last updated Jun 4, 2025

PREVIEW
Read Column

UiPath.GSuite.Activities.ReadColumnConnections

Description

Reads all content filled cells in a column, indicated by the starting cell, from the 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

Configuration

Input

  • Add new connection - You must connect to Google Sheets to use this activity.
  • Spreadsheet - The spreadsheet from which the column 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 column you want to read. This property supports String variables and string formatted values.
  • Starting cell - The first cell in the column. All cells that contain content in the specified column 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 column in an output vairable.
  • 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-2025 UiPath. All rights reserved.