Read All Rows

Read all non-header rows from a worksheet and return them as a collection.

Options

Field Definition Type Required
Spreadsheet

List of spreadsheets in your Google Sheets account

Caution

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
Worksheet List of worksheet tabs in the spreadsheet Dropdown TRUE

Output

Field Definition Type
Rows Column values associated with the row List of objects
Row Number Location number of the row Number
Columns Cell content in the row (each cell represents a column) Object

Related topics

Google Sheets connector

About the elements of Okta Workflows

Google Sheets API documentation