Automation library · Chat assistants

Rerank PM priorities every 2 hours with OpenAI and Notion

Started by a clock, and works across Notion and Slack. It hands the judgement calls to OpenAI. 40 steps, 2 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
40 stepsLarge: read it before trusting it with anything live
2Branches: places the flow splits
1Loop or waits
2Services it connects to

The flow

Starts it 1Model 3Logic 25Service 11

The steps in the order they run, from what starts it.

  1. 1Rerank TriggerSchedule triggerStarts it
  2. 2Read SettingsNotionService
  3. 3Check Demo ModeIfLogic
  4. 4Get Open PrioritiesNotionService
  5. 5Get Recent SignalsNotionService
  6. 6Get Meeting DecisionsNotionService
  7. 7Get Urgent EmailsNotionService
  8. 8Get Blocked ActionsNotionService
  9. 9Sort PrioritiesSortLogic
  10. 10Filter High SignalsFilterLogic
  11. 11Normalize MeetingsCodeLogic
  12. 12Filter Urgent EmailsFilterLogic
  13. 13Filter Overdue ActionsFilterLogic
  14. 14Limit Top 20LimitLogic
  15. 15Normalize SignalsCodeLogic
  16. 16Merge ContextMergeLogic
  17. 17Normalize EmailsCodeLogic
  18. 18Normalize BlockersCodeLogic
  19. 19Normalize PrioritiesCodeLogic
  20. 20Build Priority MatrixCodeLogic
  21. 21Remove DuplicatesRemove DuplicatesLogic
  22. 22AI Pass 1 - ImpactOpen AiModel
  23. 23Parse ImpactCodeLogic
  24. 24Set Impact ScoresSetLogic
  25. 25AI Pass 2 - UrgencyOpen AiModel
  26. 26Parse UrgencyCodeLogic
  27. 27Set Urgency ScoresSetLogic
  28. 28AI Pass 3 - Final RankOpen AiModel
  29. 29Parse RankingCodeLogic
  30. 30Compare RankingsCompare DatasetsService
  31. 31Any ChangesIfLogic
  32. 32Build Change SummaryCodeLogic
  33. 33Prepare Update BatchCodeLogic
  34. 34No ChangesNo OpLogic
  35. 35Format Slack UpdateCodeLogic
  36. 36Batch UpdatesSplit In BatchesLogic
  37. 37Slack No ChangesSlackService
  38. 38Post Ranking ChangeSlackService
  39. 39Update Notion PriorityNotionService
  40. 40Create Audit LogNotionService

How it's built

Starts on
A clock
Steps
40, with 2 branches, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Notion, Slack
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Notion and Slack accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 40 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 40 steps before you point it at anything that matters.