{"product_id":"n8n-invoice-3-way-match-google-sheets-groq-llama-notion","title":"n8n Invoice 3-Way Match: Google Sheets + Groq Llama + Notion","description":"\u003ch3\u003eAutomatically three-way match invoices in Google Sheets—using AI when needed\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow performs daily 3-way matching for invoices against Purchase Orders and Goods Receipts stored in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, approving confident matches, rejecting uncertain ones with \u003cstrong\u003eGmail\u003c\/strong\u003e alerts, and escalating borderline cases to a \u003cstrong\u003eNotion-backed AI audit\u003c\/strong\u003e powered by \u003cstrong\u003eGroq Llama 3.3\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: triggers every day to pull \u003cem\u003ePurchase Order\u003c\/em\u003e, \u003cem\u003eGoods Receipt\u003c\/em\u003e, and \u003cem\u003eInvoice\u003c\/em\u003e rows from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTargets only actionable invoices\u003c\/strong\u003e: processes invoices where \u003cstrong\u003estatus is pending\u003c\/strong\u003e and \u003cstrong\u003einvoice amount \u0026gt; 0\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes item descriptions\u003c\/strong\u003e, then finds the best PO\/GRN combination for the same vendor.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates match score\u003c\/strong\u003e using hybrid token similarity + \u003cstrong\u003eLevenshtein\u003c\/strong\u003e similarity, with a \u003cstrong\u003e5% amount tolerance\u003c\/strong\u003e check.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApproves automatically\u003c\/strong\u003e when scores are high: updates status and match score in Google Sheets and logs the approval to a \u003cstrong\u003eNotion\u003c\/strong\u003e database.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRejects automatically\u003c\/strong\u003e when scores are low: updates Google Sheets, sends a \u003cstrong\u003erejection email\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e (including score and reason), and archives the case to Notion.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI confirms mid-range matches\u003c\/strong\u003e: uses \u003cstrong\u003eGroq Llama 3.3\u003c\/strong\u003e semantic checks to confirm whether items refer to the same product—either approving or escalating.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalated AI audit\u003c\/strong\u003e: retrieves past approved transactions for the vendor from Notion, asks Llama 3.3 for a \u003cstrong\u003eJSON decision\u003c\/strong\u003e (approved\/review\/rejected), syncs the final status back to Google Sheets, and archives the decision to Notion.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce manual AP workload by automatically matching invoices to PO\/GRN data in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSend standardized rejection emails when item\/amount mismatches fall below acceptable thresholds.\u003c\/li\u003e\n  \u003cli\u003eUse AI review for ambiguous product descriptions while keeping a Notion audit trail.\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: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003enotion\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore systems\u003c\/strong\u003e: Google Sheets (data in\/out), Gmail (rejection alerts), Notion (logging + vendor history), Groq Llama 3.3 (semantic confirmation + JSON audit decision).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirement\u003c\/strong\u003e: add \u003cstrong\u003eGoogle Sheets OAuth credentials\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45872784244915,"sku":"N8N-18493","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FCafxeLganU0lAixvGl4f_n17xTdf0.png?v=1787216542","url":"https:\/\/buyflowscripts.com\/products\/n8n-invoice-3-way-match-google-sheets-groq-llama-notion","provider":"N8N Commerce","version":"1.0","type":"link"}