Read all rows (starting at 2, 1 begin the header row) from a worksheet and return them as a collection.

Options

  • Spreadsheet (dropdown): A list of all the spreadsheets you have access to within your Google Sheets account
  • Worksheet (dropdown): A list of all the worksheet tabs within your selected spreadsheet.

Input Fields

There no input fields for this card.

Output Fields

  • Outputs
    • Rows (a list of object) : The output returned by this card will be the column values associated with the row.
      • Row Number (number) : The rows number. This number is located on the left side of the sheet.
      • Columns (object) : The list of cell located in the row, each representing a column.