Read Column

Retrieve values from a column in a Google Sheet.

Options

Field	Definition	Type	Required
Use Spreadsheet ID?	Option to specify a Google Sheets spreadsheet by ID. If you select `No`, select a spreadsheet from the Spreadsheet dropdown and ignore the Spreadsheet ID field. If you select `Yes`, the list of spreadsheets from your account in the Spreadsheet dropdown will be depopulated; select `-- Enter Spreadsheet ID --` from the Spreadsheet dropdown and enter an ID in the Spreadsheet ID field. The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL `https://docs.google.com/spreadsheets/d/1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps/edit#gid=0`, the spreadsheet ID is `1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps`.	Dropdown	TRUE
Spreadsheet	List of spreadsheets in your Google Sheets account Due to an API limitation, a maximum of 100 spreadsheets are returned in a search. To search for a specific spreadsheet, use the Enter Spreadsheet ID option.	Dropdown	TRUE
Spreadsheet ID	Unique identifier for your selected spreadsheet.	String	FALSE
Worksheets	List of worksheet tabs in the spreadsheet.	Dropdown	TRUE
Column to Search	List of columns in the worksheet.	Dropdown	TRUE

Field	Definition	Type
Values in Column	List of values in the selected column.	List