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 |