Hello! I’ve tried a few solutions from the community here, but haven’t had any luck so I’m posting as a unique question. I use a closed system which allows me to export a CSV of applicant records daily and I’d like to use that file to upload data to our Airtable workspace.
Here’s the workflow:
- Daily, at midnight, the system generates a CSV of all records (existing and new) and loads it to file storage (currently Google Drive, but can be Box or Dropbox). It overwrites the previous file.
- Problem step: I’d like Zapier to read and parse the file so I can map fields to Airtable.
- From there, I’m super-comfortable with Airtable workflows -- it’s really just cracking the CSV so I can use the fields.
I’ve tried Formatter with both Box and Drive, but I keep having an issue with Line Items showing up blank.
Any feedback or direction would be awesome! Thank yoU!
Check out this help article about using CSVs: https://zapier.com/help/create/format/import-csv-files-into-zaps
Also try using Looping to handle the CSV line items: https://zapier.com/apps/looping/integrations
Perhaps you can post screenshots of how your Zap steps are configured.