About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Have Data as Multiple Rows in Airtable

  • 18 January 2023
  • 8 replies
  • 174 views
F

I have created the Zap below which:

  1. Takes data from phantom buster
  2. Splits one text field using the formatter
  3. Splits a second text field using the formatter
  4. Passes the results into Airtable

The issue I am having is that I want each value passed as a separate row in airtable but they are being passed into a single row under the respective columns.

1.

  1.  

  4.  

icon

Best answer by Troy Tessalone 20 January 2023, 16:55

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

8 replies

chanelle
Userlevel 7
Badge +8

Hi @fergusga have you considered using our Transfer feature? From my understanding on what you are trying to do, I believe this may be a great solution for you!

 

Here’s some more info: 

Community article with tutorial

Help Center Transfer breakdown

Troy Tessalone
Userlevel 7
Badge +14

Hi @chanelle 

Good question.

Options:

  1. Action: Airtable - Create Record(s)
    1. Line Items supported
  2. Looping by Zapier: https://zapier.com/apps/looping/help

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
F

I did try the line support but as the source has more than 10 records it was throwing an error

Troy Tessalone
Userlevel 7
Badge +14

@fergusga

Use Looping by Zapier: https://zapier.com/apps/looping/help

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
F

Thank you so much. One follow up question, using the loop I see there is a limit to 500 loops, if the data source has more than 500 records how does this get handled?

Troy Tessalone
Userlevel 7
Badge +14

@fergusga 

If you need to handle more data then try Transfer by Zapier: https://transfer.zapier.com/new

 

For Looping, it will either not process records 501+ or it will error at record 501.

Best to chunk the data into sets of 500 or less.

 

What is the maximum number of loops I can use?

You can set your looping step to run up to 500 times. If you want your Zap to loop more than 500 times, contact Zapier support to be added to the feature request.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
F

Thanks, unfortunately my source (Phantom buster) isn’t one of the available sources so this would mean exporting to sheets etc.

I have managed to get phantombuster to only export 450 results at a time so not to break the loop but the next issue I have is that Phantombuster sends all the results (more than 450) including previous runs.

A couple of potential solutions:

  1. I can have Phantombuster create a new export file each time but the name will change and therefore break the zap which is looking for a specific file
  2. Or is there a way to filter the data before it is passed to the loop to only include those from the last run within Zapier. I have a timestamp field but I would need this to be dynamic otherwise I am going to have to manually edit daily or specifiy the last x number of records
Troy Tessalone
Userlevel 7
Badge +14

@fergusga 

I can have Phantombuster create a new export file each time but the name will change and therefore break the zap which is looking for a specific file

We’d need to see screenshots with how your Zap steps are configured to have context about this.

 

Maybe consider a different approach.

If you can export data from PhantomBuster to a CSV file, then you could drop that CSV file into a cloud storage drive folder to trigger a Zap. (e.g. new file in folder)

If needed, you can use the Formatter > Utilities > Import CSV option to help handle the CSV file contents.

Then continue with the Zap.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions