{"product_id":"n8n-procurement-inflation-risk-dashboard-groq-world-bank","title":"n8n Procurement Inflation Risk Dashboard (Groq + World Bank)","description":"\u003ch3\u003eSpot procurement inflation risk every week—automatically\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003en8n Procurement Inflation Risk Dashboard (Groq + World Bank)\u003c\/strong\u003e workflow automatically combines your procurement spend and category budgets from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with \u003cstrong\u003eWorld Bank US CPI inflation\u003c\/strong\u003e data and \u003cstrong\u003eUSD\/INR FX rates\u003c\/strong\u003e. It then generates plain-English risk narratives with \u003cstrong\u003eGroq (gpt-oss-120b)\u003c\/strong\u003e, updates your dashboard, emails category updates via \u003cstrong\u003eGmail\u003c\/strong\u003e, and sends urgent \u003cstrong\u003eSlack\u003c\/strong\u003e alerts when thresholds are breached.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly\u003c\/strong\u003e on a schedule to keep your procurement risk view current.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls data\u003c\/strong\u003e: reads historical spend and category budgets from Google Sheets, fetches latest US CPI inflation from the \u003cstrong\u003eWorld Bank API\u003c\/strong\u003e, and retrieves live USD\/INR rates from \u003cstrong\u003eopen.er-api.com\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges and standardizes\u003c\/strong\u003e the datasets by procurement category and processes categories in batches for scalability.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates inflation-adjusted spend\u003c\/strong\u003e, converts it to local currency using USD\/INR, then computes \u003cstrong\u003ebudget variance\u003c\/strong\u003e and \u003cstrong\u003emargin-leakage risk\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Groq for action-ready reporting\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf a category is \u003cstrong\u003eover budget\u003c\/strong\u003e, Groq produces a \u003cem\u003eplain-English margin impact analysis\u003c\/em\u003e.\u003c\/li\u003e\n      \u003cli\u003eIf a category \u003cstrong\u003ebreaches the inflation threshold\u003c\/strong\u003e, Groq proposes \u003cem\u003eimmediate supply-chain mitigation actions\u003c\/em\u003e and posts an \u003cstrong\u003eurgent Slack alert\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates outputs\u003c\/strong\u003e: formats the status report, updates the matching category row in the Google Sheets \u003cstrong\u003edashboard\u003c\/strong\u003e, and sends a per-category email via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly monitoring of \u003cstrong\u003eprocurement category\u003c\/strong\u003e budget variance and inflation-driven margin leakage.\u003c\/li\u003e\n  \u003cli\u003eFast escalation for teams when \u003cstrong\u003einflation thresholds\u003c\/strong\u003e are crossed (Slack + email).\u003c\/li\u003e\n  \u003cli\u003eOperational reporting for SaaS operators and automation engineers maintaining a procurement risk dashboard in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tech stack\u003c\/strong\u003e: if, set, code, gmail, merge, slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPIs\u003c\/strong\u003e: World Bank API (US CPI inflation) and open.er-api.com (USD\/INR FX).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI engine\u003c\/strong\u003e: Groq using \u003cstrong\u003eopenai gpt-oss-120b\u003c\/strong\u003e to generate narratives and mitigation actions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eSetup note:\u003c\/em\u003e add Google Sheets credentials and update spreadsheet IDs, sheet names, and the matching column (category) used for spend, budget, and dashboard update steps.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45899947147443,"sku":"N8N-18718","price":21.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/oBGzbTPn2kxmVV_2ka5kd_EFauXIIY.png?v=1787735092","url":"https:\/\/buyflowscripts.com\/products\/n8n-procurement-inflation-risk-dashboard-groq-world-bank","provider":"N8N Commerce","version":"1.0","type":"link"}