Question

How to add daily CSV export into Airtable

  • 10 August 2021
  • 1 reply
  • 632 views

Userlevel 1

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:

  1. 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. 
  2. Problem step: I’d like Zapier to read and parse the file so I can map fields to Airtable. 
  3. 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!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Chris Harring 

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.