{"product_id":"n8n-workflow-reconcile-google-sheets-sales-gmail-alerts","title":"n8n Workflow: Reconcile Google Sheets Sales \u0026 Gmail Alerts","description":"\u003ch3\u003eReconcile Google Sheets Sales totals and get instant Gmail alerts for discrepancies\u003c\/h3\u003e\n\u003cp\u003eIf your reported sales numbers and system-recorded totals ever drift, this n8n workflow automatically compares the two Google Sheets sources by store name and sends a Gmail email detailing any mismatches—so you can fix reporting issues before they become costly.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand\u003c\/strong\u003e: start the workflow manually in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads per-store sales from Google Sheets\u003c\/strong\u003e: pulls \u003cem\u003eReported Sales\u003c\/em\u003e from one worksheet (Store, Reported_Total).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads system-recorded sales from a second sheet\u003c\/strong\u003e: pulls \u003cem\u003eSystem Sales\u003c\/em\u003e from another worksheet (Store, System_Total).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches rows by Store\u003c\/strong\u003e: reconciles entries by the \u003cem\u003eStore\u003c\/em\u003e field across both sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates differences and applies a configurable tolerance\u003c\/strong\u003e: computes per-store and overall discrepancies, and flags any store outside the tolerance value.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail alert only when needed\u003c\/strong\u003e: if at least one mismatch is detected, it emails a discrepancy summary with store-level details and overall totals.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly sales verification\u003c\/strong\u003e: confirm that reported totals match system totals per store.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData quality checks\u003c\/strong\u003e: quickly identify stores with mismatched numbers due to syncing or entry errors.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOperations oversight for SaaS operators\u003c\/strong\u003e: reduce manual reconciliation time by automating the comparison and alerting.\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 and Gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: \u003cem\u003egoogle sheets\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e (tolerance + discrepancy calculation), \u003cem\u003eif\u003c\/em\u003e (mismatch detection), \u003cem\u003egmail\u003c\/em\u003e, plus a \u003cem\u003esticky note\u003c\/em\u003e for workflow guidance\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd \u003cstrong\u003eGoogle Sheets credentials\u003c\/strong\u003e and configure document ID + sheet name for both worksheets.\u003c\/li\u003e\n  \u003cli\u003eEnsure both sheets include the required columns: \u003cstrong\u003eReported Sales\u003c\/strong\u003e (Store, Reported_Total) and \u003cstrong\u003eSystem Sales\u003c\/strong\u003e (Store, System_Total).\u003c\/li\u003e\n  \u003cli\u003eAdd a \u003cstrong\u003eGmail credential\u003c\/strong\u003e and set the recipient address in the email node.\u003c\/li\u003e\n  \u003cli\u003eAdjust the \u003cstrong\u003etolerance value\u003c\/strong\u003e in the reconciliation code if small differences should be allowed.\u003c\/li\u003e\n  \u003cli\u003eRequires a Google account with Sheets and Gmail access enabled.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46072079089843,"sku":"N8N-19795","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/TwxO_nzINFtJCtIvx-aca_XKj5gDxo.png?v=1790068134","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-reconcile-google-sheets-sales-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}