What would be the best workflow to read data from a .CSV file, hosted on a Google Drive foler? I.e. which nodes should be used?
I have tried the Google Drive node, but I could find a way to read the file content, to process in a function? I have also looked into the Spreadsheet node, but couldn’t find a way to specify a .CSV file that is hosted on a Google Drive folder.
I would use the Google Drive node to download the file then use the Spreadsheet node to read the data downloaded. As a test I have used a CSV file from here: https://www.mockaroo.com/ and the workflow at the bottom which has resulted in…
