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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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

Apify web scrape results into Airtable (or any spreadsheet).

RV Shepherd
Userlevel 1
Badge

I’m trying to get the results from Apify web scraping function into my AirTable. 

I can get the data to move but it keeps it all in one row. I need the data to separate into different rows (like when importing a CSV format). 

The Apify data is comma separated, but nothing I do will get it separate based on the comma when importing to AirTable. The Zapier function doesn’t seem to have an option. I can tell when I test the trigger that every item has its own row. But, when I go to import to AirTable (or Google sheets), it does not separate.

Here is a Loom video of me describing what I’m trying to do. 

 

icon

Best answer by Troy Tessalone 5 June 2023, 16:53

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.

11 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @RV Shepherd 

Good question.

Try using the Looping app to handle arrays of line items.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
RV Shepherd
Userlevel 1
Badge

Any thoughts on where to put the loop?  I just tried a couple of place and continue to get the same unacceptable results. 

Here is an update loom video of what I’m seeing. 

 

Troy Tessalone
Userlevel 7
Badge +14

@RV Shepherd 

We’d need to see detailed screenshots with how your Looping step is configured with the variables mapped from Step 1.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
RV Shepherd
Userlevel 1
Badge

Here are more details in this video.

 

ken.a
Userlevel 7
Badge +6

Hi there @RV Shepherd,

I’m jumping in to see if I can help!

Thanks for the loom videos they’re really helpful!

Could you please try setting your Zap like this:

  1. Trigger: Apify
  2. Action: Utilities in Formatter by Zapier - Text to Line-item
  3. Action: Looping by Zapier (Create Loop From Line Items) - In the “Values to Loop” field kindly map the output of the Formatter step to the 2nd column of that field.
  4. Action: Airtable (Create Record) - Kindly map the “Title” data from the Looping by Zapier step to the “Title” field in Airtable.

After that, kindly publish the Zap and trigger the Zap to see if it’ll work.

Please give that a try, and keep us posted! 😊

RV Shepherd
Userlevel 1
Badge

Still striking out @ken.a   I appreciate you and @Troy Tessalone’s help.   

Here is an update video. Let me know if I didn’t follow your instructions correctly. 

 

Troy Tessalone
Userlevel 7
Badge +14

Hi @RV Shepherd 

I don’t think you’ll need the Formatter step as the data from the Zap trigger in Step 1 already returns an array of line items.

 

For the Looping step, try mapping the “url” desired data point from Step 1 to the “Values to Loop” URL.

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
RV Shepherd
Userlevel 1
Badge

Well...no success on that method.  Updated loom here:

 

 

Troy Tessalone
Userlevel 7
Badge +14

@RV Shepherd 

Try changing to this Looping option and set the delimiter to be a comma.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
RV Shepherd
Userlevel 1
Badge

Thanks for sticking with me @Troy Tessalone   Looks like that worked. Funny, as I’m pretty sure I tried it before with mixed results. 

 

Here it is in action if you want to see. 

 

 

Troy Tessalone
Userlevel 7
Badge +14

@RV Shepherd 

 

 

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