Route purchase order approvals and budget alerts with Gmail, Slack and Sheets
Ready for 3.0What this workflow does
This workflow has 14 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Slack, Gmail and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Parse PO Payload (Code): runs custom JavaScript code
- Valid PO Request (If): checks a condition and branches into true / false
- Enrich & Classify PO (Edit Fields (Set)): sets 7 fields: poId, approvalTier, approverEmail…
- Alert Invalid Submission (Slack): uses Slack
- Route by Approval Tier (Switch): routes items into 3 branches
- Email Low-Tier Approver (Gmail): uses Gmail
- Email Mid-Tier Approver (Gmail): uses Gmail
- Email High-Tier Approver (Gmail): uses Gmail
- Read Department Budget (Google Sheets): lookup
- Budget Breach Check (If): checks a condition and branches into true / false
…plus 3 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 (8)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick Overview This workflow receives purchase order requests via webhook, validates and enriches them, emails the correct approver through Gmail based on spend tier, checks department budgets in Google Sheets, sends budget warnings to Slack, logs each PO to…