{"product_id":"reconcile-two-csv-exports-with-gemini-drift-diagnosis","title":"Reconcile Two CSV Exports with Gemini Drift Diagnosis","description":"\u003ch3\u003eReconcile two CSV exports and pinpoint Gemini drift causes in one n8n run\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow collects two CSV exports, matches them by a user-defined key and amount column, and—when differences appear—uses Google Gemini to diagnose the most likely systemic reasons for “drift,” returning either a balance confirmation or a downloadable Excel reconciliation workbook.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eAccepts an n8n form submission\u003c\/b\u003e where you describe the reconciliation, choose the \u003cb\u003elinking key\u003c\/b\u003e and \u003cb\u003eamount\u003c\/b\u003e columns, and upload \u003cb\u003etwo CSV files\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts and structures\u003c\/b\u003e both CSVs into comparable rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCompares datasets by the key column\u003c\/b\u003e to identify:\n    \u003cul\u003e\n      \u003cli\u003eagreements\u003c\/li\u003e\n      \u003cli\u003evalues that disagree\u003c\/li\u003e\n      \u003cli\u003erecords only in the “source of truth”\u003c\/li\u003e\n      \u003cli\u003erecords only in “your records”\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCalculates reconciliation metrics\u003c\/b\u003e including counts, totals, and the \u003cb\u003enet gap\u003c\/b\u003e from the grouped differences.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDiagnoses drift with Google Gemini\u003c\/b\u003e using the reconciliation summary and representative examples, then parses the result into a structured diagnosis with likely causes, checks, and materiality.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReturns results\u003c\/b\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf everything balances, it shows a completion page confirming there are no differences.\u003c\/li\u003e\n      \u003cli\u003eIf differences exist, it generates an \u003cb\u003eExcel workbook\u003c\/b\u003e starting with the diagnosis and listing every differing row by bucket, provided as a download from the form.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonthly reconciliation between two finance systems exported as CSV (bank vs. ledger, ERP vs. accounting).\u003c\/li\u003e\n  \u003cli\u003eSaaS operator drift checks after migrations, fee changes, or sync updates.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers validating data consistency across two independently exported reports.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Gemini (PaLM) API credential\u003c\/b\u003e for drift diagnosis.\u003c\/li\u003e\n  \u003cli\u003eUses n8n nodes including \u003cb\u003eform\u003c\/b\u003e, \u003cb\u003eform trigger\u003c\/b\u003e, \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, and supporting notes via \u003cb\u003esticky note\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cb\u003eIdeal for n8n automation\u003c\/b\u003e: turn messy CSV reconciliation into a structured, AI-assisted drift diagnosis workflow with an Excel reconciliation deliverable.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824201359539,"sku":"N8N-18178","price":65.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jv8_DsDWkrHwTjfjikoJs_Rqvgzite.png?v=1786612007","url":"https:\/\/buyflowscripts.com\/products\/reconcile-two-csv-exports-with-gemini-drift-diagnosis","provider":"N8N Commerce","version":"1.0","type":"link"}