Read All Rows

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

Options

  • Spreadsheet(drop-down): list of spreadsheets in your Google Sheets account

  • Worksheet (drop-down): list of worksheet tabs in the spreadsheet

Output

  • Rows(list of objects): column values associated with the row

    • Row Number(number): location number of the row

    • Columns(object): cell content in the row (each cell represents a column)