How to gather several items from a Notion database into a single mail

[mlarrory]

Hello everyone,
I’m a newbie on Make and i’m stuck in the middle of my first scenario.
i’m trying to make a scenario to get several items from a Notion database to gather some of its fields (title, summary, url …) in a single mail but it’s not working as expected. I get the information from only one article in the body of my mail.
What am I doing wrong?
Can anyone help me build my scenario?

I thank you in advance.
Michel (from France)

[Simo]

Hi Michel,
It sounds like you could use a “Search objects” module followed by an Array/Text aggregator to group multiple database item fields together, which you can then map into the email. How does that sound? Feel free to share screenshots/scenario blueprints if needed

[mlarrory]

Hi Simo,
Thank you for your reply.
Here is a screenshot of my scenario for a start.

[Simo]

One question that comes to mind is: why use an Iterator after the Array Aggregator? Maybe you could map directly the content from the Aggregator

[mlarrory]

I have deleted the iterator and tested the scenario again. Here’s what I get :

I still get only one item in my mail. I guess I there’s something wrong with compose a string since I lose one item in its output.

[Simo]

I think you could directly use a “text aggregator” module (found under “Tools”) after the trigger. This allows you to compose your HTML text. Your “Source module” will be the trigger (Watch database items).

[mlarrory]

Thank you so much Simo for your reply and your precious help. It’s a very simple solution (much simpler than mine) that’s working perfectly.

Thanks again for your help.
Best wishes from France.
Michel