RSS Feed (2ops) to GSheet (2ops), how to aggregate the google sheet result into one operation

Hi I am really new here.

I am trying to build a RSS feed to generate 2 feed for recent news, then update a google sheet with the following columns: title, URL, Date created. Next, search google sheet rows for the new entries, aggregate them together send one email with the recent 2 news (title & URL). However, when I use array aggregator it only combine title & URL for each operation (ie. each news). What am I doing wrong here? What I want to achieve is to have all the news item aggregated like this within one bundle rather than 2 operations:

  1. title
    URL

  2. title
    URL





If anyone could point me to the right direction, that would be much appreciated. I am so lost :woman_facepalming:.

Cheers

1 Like

Instead of an Array Aggregator, use a Text Aggregator with a “New Row” delimiter.

Next, set the “Source Module” of the Text Aggregator to the trigger module.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

4 Likes

Cool, it worked, text aggregator after RSS. Here is how it look - the result is sent through an email, however, one more question on that, in the text aggregator, how do you put a line inbetween the bundle 1 and 2 combined in the text aggregator?

Thank you so much :grin:

insert a newline in the Text Aggregator perhaps?

How do I do that? in the Text box, using HTML language? Sorry, still a newbie :woman_facepalming:

Hi @Phoebe_He
You can add another <br> tag after the URL. The <br> tag serves as a line break in HTML.
Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation

1 Like

It worked, perfect. Thank you so much :grin:

1 Like