Skip to main content
Question

How do I split an email CSV into separate Airtable rows using Zapier?

  • 18 June 2024
  • 3 replies
  • 21 views

Hello, I am trying to create a Zap, and it is not working as intended. My goal is to have an email automatically sent to zapier each day containing a CSV file that lists properties.their ID numbers, and more information. Zapier would then use this information to update a spreadsheet in airtable daily. 

The way the zap currently is working, it just puts all info into one line in airtable. Meaning, every single property does not have a line, they are all just listed in one, giant data field on a single line. same goes for each other column type. 

My zap currently uses utility formatter, which detects format automatically, then it is meant to find the table in airtable with search field/value being the unit ID that is unique to each property/line, and update accordingly. 

 

What do I need to change so it updates with each property details in their own line in airtable?

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

3 replies

Userlevel 7
Badge +14

Hi @Lux Management 

Try using the Looping app to handle the rows of the CSV: https://zapier.com/apps/looping/help

OR

Files by Zapier: https://zapier.com/apps/files-by-zapier/integrations#triggers-and-actions

 

the files function does not fix my problem, I am going to try the looping option.

Userlevel 7
Badge +14

@Lux Management 

fyi...Files by Zapier allows you to trigger another Zap for each row of a CSV