Fetch Google Spreadsheets Rows

Fetches data from a spreadsheet.

Fetches data in table format from a given range or tab of a spreadsheet and converts it into the table_rows format. In almost all cases, you will want to use the Map Table Rows To Any node to convert it into useful data to be used inside the automation.

Input Fields

field
schema
explanation
example
spreadsheet_id
google_drive_file_id
Select a spreadsheet from the dropdown.
-
range
table_range
Enter a range manually or select a tab from the dropdown.
Sheet1 or Sheet1!A1:Z
dimension
google_sheets_spreadsheet_dimension
ROWS (default), COLUMNS
value_render_option
google_sheets_spreadsheet_value_render_option
UNFORMATTED_VALUE, FORMATTED_VALUE, FORMULA
date_time_render_option
google_sheets_spreadsheet_date_time_render_option
FORMATTED_STRING (default), SERIAL_NUMBER

Output Fields

field
schema
explanation
example
rows
table_rows
see below

Example:

[
  {
    "id": {
      "id": "1oHHAH5OnouNCFNnDNZYg70unu2aAn-XjKXNPK1oXaoY",
      "provider": "google_drive",
      "type": "file"
    },
    "range": "simple!A1:Z1",
    "columns": [
      "/first_name",
      "/last_name",
      "/twin_brother"
    ]
  },
  {
    "id": {
      "id": "1oHHAH5OnouNCFNnDNZYg70unu2aAn-XjKXNPK1oXaoY",
      "provider": "google_drive",
      "type": "file"
    },
    "range": "simple!A2:Z2",
    "columns": [
      "Simon",
      "Kreienbaum",
      "Martin"
    ]
  }
]
Did this answer your question?
😞
😐
🤩

Last updated on February 1, 2023