Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Hey everyone!

 

I’m attempting to create a Zap that will pull data from an Apify table (Actor - “YouTube Scraper”) and place the data in to newly created cards on Trello.

 

Everything is connected, but my issue is that when Zapier pulls the Apify table data, it places the individual columns data into a single, comma separated row. Here is an example of how it visualizes in Zapier and then the Trello card:

I’m trying to add the video upload date and then the video title. As you can see, it’s throwing all the table data on there, rather than a single DATE-TITLE. It’s doing DATE,DATE-TITLE,TITLE of all scraped data.

 

The text “Published Date” is one I entered, as well as “Title”. Hopefully the issue becomes more apparent with these images...I’ve had success achieving the same thing in Google Sheets, which leads me to believe it’s an Apify issue and that the formatting is somehow not compatible with Zapier. Here’s the output table (dummy data):

 

The ideal output to Trello would be:

Single date, single title.

 

Hi there @chcr951,

Welcome to the Community! 🎉

It looks like the data from Apify is being returned as a line item. Could you please try using the Utilities in Formatter by Zapier - Line Item to Text action? This will convert any line items to a text string.

You can learn more about the Line Item to Text function here: https://help.zapier.com/hc/en-us/articles/8496308258189-Convert-line-items-into-text-strings#h_01HKMBVMKFGSDTR622YHX1XD3K

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Hi there @chcr951,

Welcome to the Community! 🎉

It looks like the data from Apify is being returned as a line item. Could you please try using the Utilities in Formatter by Zapier - Line Item to Text action? This will convert any line items to a text string.

You can learn more about the Line Item to Text function here: https://help.zapier.com/hc/en-us/articles/8496308258189-Convert-line-items-into-text-strings#h_01HKMBVMKFGSDTR622YHX1XD3K

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Hey Ken!

 

This definitely seems to be the right path to go down 😃 Line Item To Text divided everything in to separated outputs. Thanks!!

 

My next question is, for the “Create Card In Trello” event, am I now required to add each of those Utilities outputs for it to create an individual Trello card for all? The “Output Items” below are the titles of individual YouTube videos I have scraped with Apify. Now looking to create unique Trello cards for each:

 

Hi @chcr951 

If you are trying to create individual Trello Cards from line items, then use the Looping app: https://zapier.com/apps/looping/help

Hi @chcr951 

If you are trying to create individual Trello Cards from line items, then use the Looping app: https://zapier.com/apps/looping/help

Thanks Troy! Looping seems to be the solution - I will tinker and see how I get on with it!

Reply


Terms & Conditions