Google Sheets - Read from Columns
Peeks into your Google Spreadsheets and grabs the data you need for analysis or reports.
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: