{"product_id":"n8n-notion-risk-scoring-workflow-groq-slack-gmail-alerts","title":"n8n Notion Risk Scoring Workflow: Groq + Slack + Gmail Alerts","description":"\u003ch3\u003eAutomatically score and rank Notion sourcing initiatives—then alert your team\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Notion Risk Scoring Workflow\u003c\/strong\u003e runs every Monday morning to find unscored initiatives in \u003cstrong\u003eNotion\u003c\/strong\u003e, calculate a \u003cstrong\u003erisk-weighted priority score\u003c\/strong\u003e, optionally generate a \u003cstrong\u003eGroq\u003c\/strong\u003e-based rationale, update Notion, post a ranked report to \u003cstrong\u003eSlack\u003c\/strong\u003e, and send a \u003cstrong\u003eGmail\u003c\/strong\u003e alert if the top score is critical.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled run:\u003c\/strong\u003e Executes weekly on \u003cstrong\u003eMondays at 08:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePull unscored initiatives:\u003c\/strong\u003e Retrieves all pages in your target Notion database where \u003cem\u003e“Priority Score”\u003c\/em\u003e is empty, and maps key project metrics into a working structure.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculate a priority score:\u003c\/strong\u003e Computes a score using `Value`, `Urgency`, `Supplier Risk`, `Business Impact`, and `Effort` to produce a risk-weighted priority.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate AI rationale (Groq):\u003c\/strong\u003e For items with a \u003cstrong\u003epriority score of 20+\u003c\/strong\u003e, it uses \u003cstrong\u003eGroq\u003c\/strong\u003e to generate a \u003cstrong\u003e2-sentence procurement rationale\u003c\/strong\u003e. Items below 20 receive a \u003cstrong\u003edefault rationale\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdate Notion:\u003c\/strong\u003e Sorts initiatives by priority (highest first) and writes back \u003cem\u003e“Priority Score”\u003c\/em\u003e and \u003cem\u003e“AI Rationale”\u003c\/em\u003e to each Notion page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReport to Slack:\u003c\/strong\u003e Sends a single \u003cstrong\u003e“Weekly Sourcing Priority Report”\u003c\/strong\u003e message to your Slack channel with the ranked results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCritical Gmail alerts:\u003c\/strong\u003e Checks the highest score in the batch and emails via \u003cstrong\u003eGmail\u003c\/strong\u003e if it \u003cstrong\u003eexceeds 50\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProcurement teams need a \u003cstrong\u003eweekly sourcing prioritization\u003c\/strong\u003e system without manual scoring.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators want \u003cstrong\u003erisk-based visibility\u003c\/strong\u003e into suppliers and sourcing initiatives in Notion.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers require a practical \u003cstrong\u003eNotion + Groq + Slack\u003c\/strong\u003e pipeline with email escalation for high-risk items.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eNotion\u003c\/strong\u003e, \u003cstrong\u003eGroq\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eCore workflow logic\/nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esort\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eSetup requires: Notion database properties for \u003cstrong\u003eProject Name\u003c\/strong\u003e, \u003cstrong\u003eValue\u003c\/strong\u003e, \u003cstrong\u003eUrgency\u003c\/strong\u003e, \u003cstrong\u003eSupplier Risk\u003c\/strong\u003e, \u003cstrong\u003eBusiness Impact\u003c\/strong\u003e, \u003cstrong\u003eEffort\u003c\/strong\u003e, \u003cstrong\u003ePriority Score\u003c\/strong\u003e, and \u003cstrong\u003eAI Rationale\u003c\/strong\u003e, plus Groq credentials (Chat Model) for AI rationale generation.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45923043475635,"sku":"N8N-18895","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Ibs3lkTY4h4MwgtzrHmmp_wvUXh7AH.png?v=1788167208","url":"https:\/\/buyflowscripts.com\/products\/n8n-notion-risk-scoring-workflow-groq-slack-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}