Read All Rows

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


Field Definition Type Required

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


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