I'm setting up a Zapier trigger to do something with the values of a new csv file in Google Drive, but I can't get it to actually read the content of the file. I can trigger on all kinds of metadata, but don't know how to parse the file itself. How does one read a (csv) file in Zapier?
A Google Drive add-on called Sheetgo has the ability to automate the import of new CSV files in your Google Drive into a Google Spreadsheet.
Once you set the automatic import, you can then set your Zapier trigger to listen to the Google Sheet rather than the CSV file.
Here is the link to the add-on: