Aggregate Collections to one Email

Hi, I am currently building a process which gets entries from a notion database. It iterates through the databases and compares release versions with installed versions, which I stored in the notion database. In the end I get informed if a version on a release page doesnt fit my entry in the notion database.
Everything works fine, however, I want to make one improvement which seems way more complicated than expected. Currently I am getting one Email for each module in the database. At the moment this is okay, but if I get 100 or more Emails each time it becomes bad.

I want Make.com to iterate through each entry of my database, go through the process but the email and than send an Email aggregating the results.

I am working with 3 different paths and filters, so I can set a variable each path with the corresponding text for the mail. However, I dont know if this is possible, since Make.com tries to complete a process before starting a new one.

Could somebody pleas give me a hint to the right direction?

Following - I’m having a very similar challenge building a similar solution.

Welcome to the Make community!

Try using a Text Aggregator?

Aggregators

Every result (item/record) from iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.

There are other types of aggregator modules, click the below links to find out more:

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

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

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.