This node requires that you connect your account to the Integrations, or connect it directly in the configurations of the node

The Google Sheets - Read from Columns module allows you to read data from Google Sheets.

Google Sheets are processed by column; you must maintain the first row of the Google Sheets for the headers where each column represents a variable.

The Google Sheets - Read from Columns module has variable outputs:

  • Outputs: Each column header in the first row of the google sheets represents a variable output with a list composed of all the rows in each column.
  • Config: The Google Sheets file can be loaded with a link or via the Google Finder

Find below an example of how you can upload a Google Sheets: