{"product_id":"n8n-procurement-savings-analyzer-sheets-gpt-4o-mini-gmail","title":"n8n Procurement Savings Analyzer: Sheets + GPT-4o Mini + Gmail","description":"\u003ch3\u003eAutomatically find weekly procurement savings from your Google Sheets—then email a ranked top-5 with GPT\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Procurement Savings Analyzer\u003c\/strong\u003e workflow analyzes your procurement transactions every Monday, detects savings opportunities using structured rules, generates recommendations with \u003cstrong\u003eGPT-4o Mini\u003c\/strong\u003e, writes results back to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends a weekly \u003cstrong\u003etop-5 savings report\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e: executes every Monday at \u003cstrong\u003e8:00 AM\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads procurement data\u003c\/strong\u003e from your Google Sheets \u003cem\u003etransactions\u003c\/em\u003e tab (e.g., Category, Supplier, Item Description, Quantity, Unit Price, Total Spend, Contract Price, Preferred Supplier).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates spend\u003c\/strong\u003e by category and supplier, counts supplier occurrences per category, computes item-level price statistics, and compares \u003cstrong\u003epreferred vs non-preferred spend\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects savings opportunities\u003c\/strong\u003e using rules for:\n    \u003cul\u003e\n      \u003cli\u003esupplier fragmentation\u003c\/li\u003e\n      \u003cli\u003eprice variance\u003c\/li\u003e\n      \u003cli\u003emaverick spend\u003c\/li\u003e\n      \u003cli\u003econtract leakage\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates structured analysis\u003c\/strong\u003e with \u003cstrong\u003eOpenAI (GPT-4o Mini)\u003c\/strong\u003e, including savings estimates, effort levels, and recommended actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores and prioritizes\u003c\/strong\u003e opportunities by impact vs effort, classifies them (Strategic Initiative \/ Quick Win \/ Low Priority), and appends results to a second Google Sheets tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an HTML email\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e containing the \u003cstrong\u003etop 5\u003c\/strong\u003e opportunities ranked by priority score.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators and procurement teams who want \u003cstrong\u003eweekly savings insights\u003c\/strong\u003e without manual analysis.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a repeatable \u003cstrong\u003eprocurement analytics\u003c\/strong\u003e workflow in n8n.\u003c\/li\u003e\n  \u003cli\u003eOrganizations tracking preferred suppliers and contract adherence through \u003cstrong\u003eSheets-based transaction data\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes\u003c\/strong\u003e: code, sort, google sheets, gmail, sticky note, and \u003cstrong\u003en8nn8n-nodes-langchainagent\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eModel usage\u003c\/strong\u003e: \u003cstrong\u003eOpenAI GPT-4o Mini\u003c\/strong\u003e to produce structured savings recommendations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup\u003c\/strong\u003e: add Google Sheets OAuth credentials in n8n and configure the spreadsheet ID and the sheet tabs used for transactions and results.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45748945682611,"sku":"N8N-17688","price":8.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/c1XhLzHvdNOn6UdCWxCjb_BFnjqfHO.png?v=1785575479","url":"https:\/\/buyflowscripts.com\/products\/n8n-procurement-savings-analyzer-sheets-gpt-4o-mini-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}