{"product_id":"n8n-workflow-reconcile-csv-imports-in-google-sheets-drive-gmail","title":"n8n Workflow: Reconcile CSV Imports in Google Sheets + Drive + Gmail","description":"\u003ch3\u003eReconcile CSV imports against your Google Sheets master—then draft reviewer-ready Gmail updates\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow compares incoming CSV records with a Google Sheets “Master” before importing anything new. It validates each batch, captures reviewer decisions in Sheets, detects conflicts or changes, exports only approved new records to Google Drive, and prepares Gmail drafts so review outcomes are always ready to send.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a batch request\u003c\/strong\u003e (manual demo trigger or an n8n form submission) with a \u003cem\u003ebatch ID\u003c\/em\u003e and \u003cem\u003eGoogle Drive file ID\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads import context from Google Sheets\u003c\/strong\u003e by reading the \u003cem\u003e“Imports”\u003c\/em\u003e register and the \u003cem\u003e“Master”\u003c\/em\u003e sheet, then downloads the source CSV from Google Drive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and classifies records\u003c\/strong\u003e by checking required columns and formats, rejecting duplicate record IDs in the CSV, and comparing each row to the Master to determine whether it’s new, unchanged, conflicting, or invalid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites a case\/proposal back to “Imports”\u003c\/strong\u003e, including hashes and a detailed proposal summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates Gmail drafts\u003c\/strong\u003e that instruct reviewers to approve, reject, or request changes—keeping review communications consistent and ready.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits for a reviewer decision\u003c\/strong\u003e by polling the “Imports” sheet on an interval until a valid decision is recorded (including matching proposal hash and reviewer email) or the window times out.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRe-checks Master for staleness after approval\u003c\/strong\u003e by re-reading Master and marking the case stale if it changed since the proposal snapshot.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExports approved new records\u003c\/strong\u003e as a CSV to a private Google Drive folder, reusing an existing export if available, then records the final status and output file ID in “Imports”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates the final Gmail\u003c\/strong\u003e update once the workflow completes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePreventing duplicate or conflicting imports by reconciling CSV exports with a Sheets-based system of record.\u003c\/li\u003e\n  \u003cli\u003eFormal review workflows for SaaS data updates, with reviewer decisions tracked in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eControlled, auditable exports to Google Drive only after approval and “Master” change checks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads \u003cem\u003eImports\u003c\/em\u003e and \u003cem\u003eMaster\u003c\/em\u003e; writes reviewer cases, hashes, statuses, and output file IDs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e: downloads the source CSV and exports approved new-record CSVs to a private folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: drafts review requests and final outcomes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eno op\u003c\/em\u003e, \u003cem\u003ewait\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326520119475,"sku":"N8N-21831","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Mv0MnS1rvozQYiv_1r809_uEwp8OSQ.png?v=1793351284","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-reconcile-csv-imports-in-google-sheets-drive-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}