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