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.
|List of worksheet tabs in the spreadsheet.
|Column values associated with the row
|List of objects
|Location number of the row
|Cell content in the row (each cell represents a column)