Build an automation that runs on every week on Monday and fetches tasks from Notion, filters them into Past Due / Due This Week / Upcoming, groups them by assignee, and sends a personalized Slack message to each person with a clean, formatted summary

Questions
, , ,
1

:bullseye: What is your goal?

What I’m trying to do:
Build a Monday automation that fetches tasks from Notion, filters them into Past Due / Due This Week / Upcoming, groups them by assignee, and sends a personalized Slack message to each person with a clean, formatted summary.
Message format-

Total Task:
Past Due: (2)
Due This Week: (3)
Upcoming: (5)

Past Due:
1.Task Name
Client: [Client Name]
Project: [Project Name]
Due: [Date]

2.Task Name
Client: [Client Name]
Project: [Project Name]
Due: [Date]

Due This Week:
1.Task Name
Client: [Client Name]
Project: [Project Name]
Due: [Date]

2.Task Name
Client: [Client Name]
Project: [Project Name]
Due: [Date]

3.Task Name
Client: [Client Name]
Project: [Project Name]
Due: [Date]

Upcoming:

1.Task Name
Client: [Client Name]
Project: [Project Name]
Due: [Date]

2.Task Name
Client: [Client Name]
Project: [Project Name]
Due: [Date]

:thinking: What is the problem & what have you tried?

My current Make.com flow:
Notion module (Search Objects) → fetch all tasks from the database.
Router → three routes based on due date filters:
Past Due
Due This Week
Upcoming
Aggregator in each route → group tasks by assigned person email.
Iterator over aggregated bundles → process tasks per person.
Set Multiple Variables → store fields (task name, client, project, due date, URL, total number of task).
Text Aggregator → format tasks into the message structure for each category.
Text Parser → convert formatted text to plain text.
Set Multiple Variable again → store each category’s text output.
Fourth Router path → uses Get Multiple Variables to combine Past Due + Due This Week + Upcoming text for each assignee.
Slack → send the final compiled message to each person.

My Problem: I can’t access the variables set in Set Multiple Variables modules from all parts of the flow. Even though I set variables in each route (Past Due, Due This Week, Upcoming), when I try to retrieve them in a fourth route using Get Multiple Variables, some or all are empty or missing.

My Question:
:backhand_index_pointing_right: What am I doing wrong? Why are the variables not accessible across router paths?
:backhand_index_pointing_right: How can I restructure or improve this automation so that all three category outputs can be merged into one Slack message per person?
I want to understand the correct architecture and best practices for this type of scenario.

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

scenario.png
scenario.png1717×696 117 KB

3

Hey there,

what are you transforming here exactly with all those modules?

I dont think you need to iterate and then aggregate when its already aggregated, just do the final aggregation.

You don’t need the set variables, you can do that in the text aggregator directly.

You dont need to parse it, its not HTML its already plain text.

You dont need to set multiple variables, just one with the text output.

And on the final route, there is nothing to aggregate, you dont need that text aggregator at all.

Notion → router with the 3 checks → text aggregator → set variable

and on the final route → get multiple variables → Send slack message.