Read All Rows

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


Field Definition Type Required
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
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

Workflow elements

Google Sheets API documentation