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