Question

Apify Table Data - Row-by-row instead of whole table

  • 6 February 2024
  • 4 replies
  • 34 views

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.

 


4 replies

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!

Userlevel 7
Badge +14

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 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:

 

Userlevel 7
Badge +6

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!

Reply