Read All Rows
Read all non-header rows from a worksheet and return them as a collection.
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.
|Worksheet||List of worksheet tabs in the spreadsheet||Dropdown||TRUE|
|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|