n8n Procurement Inflation Risk Dashboard (Groq + World Bank)

Spot procurement inflation risk every week—automatically

The n8n Procurement Inflation Risk Dashboard (Groq + World Bank) workflow automatically combines your procurement spend and category budgets from Google Sheets with World Bank US CPI inflation data and USD/INR FX rates. It then generates plain-English risk narratives with Groq (gpt-oss-120b), updates your dashboard, emails category updates via Gmail, and sends urgent Slack alerts when thresholds are breached.

What this workflow does

• Runs weekly on a schedule to keep your procurement risk view current.
• Pulls data: reads historical spend and category budgets from Google Sheets, fetches latest US CPI inflation from the World Bank API, and retrieves live USD/INR rates from open.er-api.com.
• Merges and standardizes the datasets by procurement category and processes categories in batches for scalability.
• Calculates inflation-adjusted spend, converts it to local currency using USD/INR, then computes budget variance and margin-leakage risk.
• Uses Groq for action-ready reporting:
  • If a category is over budget, Groq produces a plain-English margin impact analysis.
  • If a category breaches the inflation threshold, Groq proposes immediate supply-chain mitigation actions and posts an urgent Slack alert.
• Updates outputs: formats the status report, updates the matching category row in the Google Sheets dashboard, and sends a per-category email via Gmail.

Use cases

• Weekly monitoring of procurement category budget variance and inflation-driven margin leakage.
• Fast escalation for teams when inflation thresholds are crossed (Slack + email).
• Operational reporting for SaaS operators and automation engineers maintaining a procurement risk dashboard in Google Sheets.

Technical details

• n8n nodes/tech stack: if, set, code, gmail, merge, slack.
• APIs: World Bank API (US CPI inflation) and open.er-api.com (USD/INR FX).
• AI engine: Groq using openai gpt-oss-120b to generate narratives and mitigation actions.

Setup note: add Google Sheets credentials and update spreadsheet IDs, sheet names, and the matching column (category) used for spend, budget, and dashboard update steps.