{"product_id":"esg-supplier-diversity-n8n-workflow-google-sheets-groq-notion","title":"ESG Supplier Diversity n8n Workflow: Google Sheets, Groq \u0026 Notion","description":"\u003ch3\u003eAutomate ESG \u0026amp; Supplier Diversity Reporting—Every Monday\u003c\/h3\u003e\n\u003cp\u003eWith the \u003cstrong\u003eESG Supplier Diversity n8n Workflow: Google Sheets, Groq \u0026amp; Notion\u003c\/strong\u003e, your team can automatically calculate supplier diversity and ESG spend performance from Google Sheets, generate executive summaries and rebalancing recommendations using \u003cstrong\u003eGroq\u003c\/strong\u003e, publish a weekly \u003cstrong\u003eNotion\u003c\/strong\u003e scorecard, and email an HTML briefing via \u003cstrong\u003eGmail\u003c\/strong\u003e—on a Monday schedule.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly (every Monday)\u003c\/strong\u003e using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls data from Google Sheets\u003c\/strong\u003e: supplier master data, procurement transactions, and configured target thresholds (e.g., category targets).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and joins\u003c\/strong\u003e transactions to suppliers, then calculates:\n    \u003cul\u003e\n      \u003cli\u003eTotal spend\u003c\/li\u003e\n      \u003cli\u003eDiverse spend (women-owned, minority-owned)\u003c\/li\u003e\n      \u003cli\u003eESG-qualified spend\u003c\/li\u003e\n      \u003cli\u003eWhether configured targets are met\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eIf \u003cstrong\u003etargets are met\u003c\/strong\u003e (or there’s no qualifying spend data), it generates an \u003cstrong\u003eexecutive summary with Groq\u003c\/strong\u003e and \u003cstrong\u003eskips rebalancing\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf \u003cstrong\u003eany target is missed\u003c\/strong\u003e, it identifies category gaps and qualified low-risk diverse suppliers, then asks \u003cstrong\u003eGroq\u003c\/strong\u003e to propose \u003cstrong\u003eFROM → TO\u003c\/strong\u003e spend shifts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and caps recommendations\u003c\/strong\u003e against ESG, risk, and rebalancing limits.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes results to Notion\u003c\/strong\u003e by creating a database page with the weekly scorecard.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a formatted HTML email via Gmail\u003c\/strong\u003e, including a link to the Notion page when available.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly ESG reporting for procurement and supply chain teams using Google Sheets as the system of record.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a supplier diversity governance cadence with n8n + Notion publishing.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want consistent, auditable ESG scorecards and recommendations without manual analysis.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Sheets, Groq, Notion, Gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes\u003c\/strong\u003e include: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003enotion\u003c\/em\u003e, plus scheduling and email steps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup inputs\u003c\/strong\u003e: Google Sheets Spreadsheet ID and sheet\/tab names (Suppliers, Transcations, Targets), Groq API credentials, and Notion database ID + database property\/select options.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114724708531,"sku":"N8N-20001","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/JjVtUQYU16L81c_-5u_XE_90AzGu2s.png?v=1790587014","url":"https:\/\/buyflowscripts.com\/products\/esg-supplier-diversity-n8n-workflow-google-sheets-groq-notion","provider":"N8N Commerce","version":"1.0","type":"link"}