{"product_id":"n8n-workflow-clean-deduplicate-supplier-data-w-groq","title":"n8n Workflow: Clean \u0026 Deduplicate Supplier Data w\/ Groq","description":"\u003ch3\u003eAutomatically clean and deduplicate your supplier master data with n8n + Groq\u003c\/h3\u003e\n\u003cp\u003eThis scheduled n8n workflow scans supplier and item master data in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, detects duplicate suppliers, uses \u003cstrong\u003eGroq\u003c\/strong\u003e (via a LangChain agent) to generate a short merge justification, and then updates your sheets with an auditable MASTER\/MERGED\/ACTIVE status—plus an email alert for recorded auto-merges.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily on a schedule\u003c\/strong\u003e and reads supplier and item master data from your connected Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCombines and normalizes data\u003c\/strong\u003e by standardizing supplier names into a lowercase, trimmed field and removing exact duplicates based on the normalized name.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects potential duplicate suppliers\u003c\/strong\u003e by comparing supplier pairs using custom matching rules, producing a \u003cstrong\u003econfidence score\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to high-confidence matches\u003c\/strong\u003e and sends the candidate pair details to \u003cstrong\u003eGroq\u003c\/strong\u003e to generate a \u003cstrong\u003eshort merge justification\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates an auto-merge record\u003c\/strong\u003e, appends a merge audit entry to a designated Google Sheets audit tab, and generates a supplier status mapping (MASTER\/MERGED\/ACTIVE).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e with merge status and master-supplier references for the full supplier list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail notification\u003c\/strong\u003e whenever an auto-merge is recorded.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep supplier records consistent when multiple entries exist due to spelling differences (e.g., punctuation or casing changes).\u003c\/li\u003e\n  \u003cli\u003eReduce duplicate supplier IDs in a SaaS ops workflow by automatically reconciling masters and merges.\u003c\/li\u003e\n  \u003cli\u003eOperational audits: maintain a clear, sheet-based merge log for governance and review.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule:\u003c\/strong\u003e daily run\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData source:\u003c\/strong\u003e Google Sheets (supplier, item, and audit tabs)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogic nodes:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLLM integration:\u003c\/strong\u003e Groq via a \u003cem\u003eLangChain agent\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifications:\u003c\/strong\u003e Gmail merge alert emails\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotes:\u003c\/strong\u003e \u003cem\u003esticky note\u003c\/em\u003e elements included for workflow clarity\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConnect Google Sheets credentials and configure the correct spreadsheet and sheet tabs.\u003c\/li\u003e\n  \u003cli\u003eEnsure your supplier sheet has columns such as \u003cstrong\u003esupplier_name\u003c\/strong\u003e, \u003cstrong\u003emerge_status\u003c\/strong\u003e, and \u003cstrong\u003emaster_supplier\u003c\/strong\u003e, and that your audit sheet contains the defined audit column(s).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46029620248755,"sku":"N8N-19562","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/U4qjsCfSgPcUPXkFHsmOo_H1cZKo0M.png?v=1789464420","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-clean-deduplicate-supplier-data-w-groq","provider":"N8N Commerce","version":"1.0","type":"link"}