ReadAllRows

ReadAllRows

Gets the values in all of the rows of a Google Sheet, starting with row 2 (assuming column headers are in row 1).

Options

• Spreadsheet (dropdown list): a list of the Google Sheets to which the selected account has access
• Worksheets (dropdown list): a list of the different worksheets or tabs contained in the chosen spreadsheet.

Input Fields

None

Output Fields

• Rows: (a list of objects) Returns a list of row values, starting in row 2, where each row object includes “Row Number” (a number starting with 2) followed by “Columns” which subkeys for each column name in the format of a number (starting with 0 for column A) then a hyphen then the column header taken from the value in row 1. You can pass this list to any of the List functions to process it (e.g. Sort By or For Each).

Example

Here’s an example of the list that might be returned from a sheet with a couple of rows of data:

[
    {
        "Row Number": 2,
        "Columns": {
            "0-id": "123",
            "1-name": "Emily"
        }
    },
    {
        "Row Number": 3,
        "Columns": {
            "0-id": "172",
            "1-name": "Rahul"
        }
    }
]