Track supplier compliance and send AI-generated alerts with Notion, Groq, Gmail and Slack
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs on a schedule (every day at 08:00). Along the way it connects Notion, Groq Chat Model, Gmail and Slack.
How it runs
Trigger: On a schedule (every day at 08:00).
- Fetch Supplier Database (Notion): get many (database page)
- Calculate Expiry Timelines (Code): runs custom JavaScript code
- Loop Supplier Records (Loop Over Items (Split in Batches)): loops over the items in batches
- Format Routing Data (Edit Fields (Set)): sets 12 fields: emailBody, slackMessage, email…
- Prepare AI Prompt Data (Edit Fields (Set)): sets 10 fields: id, name, property_contact_email…
- Urgency Routing Engine (Switch): routes items into 4 branches
- Stamp Last Alert Date (Notion): update (database page)
- Standard Renewal Notice (Gmail): uses Gmail
- Routine Internal Alert (Slack): uses Slack
- Prepare Escalation Data (Edit Fields (Set)): sets 5 fields: emailBody, slackMessage, email…
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Notion
n8n-nodes-base.notion - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Wait
n8n-nodes-base.wait - Switch
n8n-nodes-base.switch - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow runs daily to audit a Notion supplier compliance database, calculates certification expiry urgency, uses Groq (Llama 3.3 via LangChain) to generate supplier emails and internal Slack messages, and then sends notifications through…