Read Column

Scopes

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

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

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

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

• 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.

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