{"product_id":"n8n-procurement-spend-analytics-kraljic-matrix-to-notion-sheets","title":"n8n Procurement Spend Analytics: Kraljic Matrix to Notion \u0026 Sheets","description":"\u003ch3\u003eTurn procurement spend into daily Kraljic Matrix insights—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every day at 9:30 AM to analyze procurement spend from Google Sheets, calculate category-level savings and risk metrics, use Groq (Llama 3.3) to generate Kraljic Matrix recommendations, then log results to Notion and send an HTML email report via Gmail.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily scheduled run:\u003c\/strong\u003e triggers automatically at \u003cem\u003e9:30 AM\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads spend data from Google Sheets:\u003c\/strong\u003e fetches procurement transactions and groups today’s rows by \u003cem\u003ecategory\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates savings \u0026amp; risk metrics:\u003c\/strong\u003e for each category, it computes total spend, supplier list\/count, filters to categories with \u003cem\u003eat least two suppliers\u003c\/em\u003e, then estimates savings, savings %, supplier dominance, risk score, and an optimization level.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates Kraljic Matrix insights with Groq:\u003c\/strong\u003e sends the calculated metrics to \u003cstrong\u003eGroq (Llama 3.3)\u003c\/strong\u003e to classify categories into Kraljic Matrix quadrants and produce issues, recommendations, insights, and \u003cem\u003eoptional\u003c\/em\u003e web search queries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses AI JSON output:\u003c\/strong\u003e merges the AI results back with the computed savings\/risk metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves results for reporting:\u003c\/strong\u003e writes enriched category records into a \u003cstrong\u003eNotion\u003c\/strong\u003e database and appends key metrics to a \u003cstrong\u003eGoogle Sheets dashboard\u003c\/strong\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an aggregated email:\u003c\/strong\u003e builds an HTML report that includes a Data Studio dashboard link and emails it 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\u003eProcurement and sourcing teams tracking \u003cstrong\u003esupplier dominance\u003c\/strong\u003e and \u003cstrong\u003erisk\u003c\/strong\u003e by category.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and automation engineers building a \u003cstrong\u003eprocurement spend analytics\u003c\/strong\u003e pipeline in n8n.\u003c\/li\u003e\n  \u003cli\u003eOrganizations that want consistent daily reporting with \u003cstrong\u003eNotion\u003c\/strong\u003e logging and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e dashboards.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduler:\u003c\/strong\u003e runs daily at \u003cstrong\u003e9:30 AM\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration:\u003c\/strong\u003e reads spend transactions; appends metrics to a dashboard sheet\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq + Llama 3.3:\u003c\/strong\u003e generates Kraljic Matrix quadrant classification and recommendations (JSON parsed back into the workflow)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotion:\u003c\/strong\u003e writes enriched category records to a database\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail + HTML:\u003c\/strong\u003e renders and sends an aggregated HTML email report\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes mentioned:\u003c\/strong\u003e \u003cem\u003eif, set, code, html, gmail, notion\u003c\/em\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup notes\u003c\/h3\u003e\n\u003cp\u003eConnect Google Sheets credentials, update spreadsheet and sheet references for both the input spend data and the dashboard append sheet, and add a Groq API credential for the \u003cstrong\u003eLlama-3.3-70b\u003c\/strong\u003e model used by this workflow.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865755246771,"sku":"N8N-18393","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/CRhsGaUmzmfsIblTS4v41_xBzHgCt3.png?v=1787043748","url":"https:\/\/buyflowscripts.com\/products\/n8n-procurement-spend-analytics-kraljic-matrix-to-notion-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}