Getting every record in one record in AirTable from CSV + manage almost empty column

  • 3 March 2022
  • 1 reply


I am trying to automate a CSV file into AirTable after it was dropped into a Google Drive folder.

The first and last part are OK (It finds the file in the folder, and updates the AirTable table) but I am getting every observation on the same record for each field.

Everything looks ok in Zapier, it’s when it exports to AirTable:


Also, I have a field that is empty on the first 50 records (which is, from what I understood, what Zapier tests the action on). I have tried to replace the default value when empty, split the text with a comma, run a Python code with a try/except… I feel like i’ve tried everything :’)



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 @Pierre 

FYI: Airtable has an CSV Import app:


Please post screenshots with how your Zap steps are configured for us to have context, thanks.

Make sure you are using these steps in your Zaps.


Zap Steps

  1. Trigger: GDrive - New File in Folder
  2. Action: Formatter > Utilities > Import CSV:
  3. Action: Looping:
    1. NOTE: There is a 500 record limit
  4. Action: Airtable - Create Record