How to format tasks from Notion as a bulleted list to be sent out via email?

[nooaadams]

Hi everyone!
I have an automation to get tasks from a task database in Notion. I then want to categorize them in 2 ways:

1. The tasks get grouped by assignee via the aggregator. I now have a bundle with an array holding all tasks per assignee.
2. Next, I need to subdivide these tasks into tasks due today and overdue tasks. I do that with yet another iterator-aggregator. The output is looking good!
   There is one operation for each assignee, and each operation holds 2 bundles, one for overdue tasks and one for tasks due today. Now comes the million dollar question: How do I create a list with the task names that i can add to an email? Whenever I try to map the name, I only ever get the first task from the array. I also tried hard-coding the list to go through up to the fith array item, but thats not a sustainable solution and the code was incredibly long. I have been trying to use the map function because chatgpt claims that’s the way to go, but as you can see in the screenshots its not giving me the results i need. The optimal output would be text for every assignee that looks like this:

"Tasks due today:

• Task 1
• Task 2

Overdue Tasks:

• Task 3
• Task 4"

Any help is appreciated!

[Simo]

Hello Nooa,
It looks like you’re almost there. I have played around with this use case and here is a blueprint that achieves the final result, though the flow is slightly simplified (only 1 grouped aggregation instead of 2). You can try importing it into Make and see how it is set up. It doesn’t use any actual Notion module so it doesn’t require any authentication.

makeScenarioAggregateNotionDbItemsBulletList.json (123.6 KB)

[nooaadams]

@Simo Bless you, it is working! Like always, i tried overcomplicating things… Your solution was elegant and worked perfectly, thank you so much for the support!