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