# Read Column

> `UiPath.GSuite.Activities.ReadColumn`

`UiPath.GSuite.Activities.ReadColumn`

## Description

Reads all content filled cells in a column (indicated by the starting cell) from the Spreadsheet.
:::note
This classic activity is in maintenance mode. Instead, use the modern equivalent, the [Read Column](https://docs.uipath.com/activities/other/latest/productivity/google-workspace-read-column-google) activity.
:::

### 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 column 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 sheets 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](https://docs.uipath.com/activities/other/latest/productivity/gsuite-find-files) or [Create New SpreadSheet](https://docs.uipath.com/activities/other/latest/productivity/gsuite-create-new-spreadsheet) activity.
* **StartingCellAddress** - The address of the first cell in the column. This property supports `String` variables and string formatted values. The default value is "A1". All cells that contain content in the specified column 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

* **Column** - The contents of the column 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.