Read CSV file from Google Drive

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.

Any ideas?

Hey @go4cas,

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…

Perfect! Thanks, @jon! That worked 100%!

1 Like