n8n Workflow: Reconcile Google Sheets Sales & Gmail Alerts

Reconcile Google Sheets Sales totals and get instant Gmail alerts for discrepancies

If 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.

What this workflow does

• Runs on demand: start the workflow manually in n8n.
• Reads per-store sales from Google Sheets: pulls Reported Sales from one worksheet (Store, Reported_Total).
• Reads system-recorded sales from a second sheet: pulls System Sales from another worksheet (Store, System_Total).
• Matches rows by Store: reconciles entries by the Store field across both sheets.
• Calculates differences and applies a configurable tolerance: computes per-store and overall discrepancies, and flags any store outside the tolerance value.
• Sends a Gmail alert only when needed: if at least one mismatch is detected, it emails a discrepancy summary with store-level details and overall totals.

Use cases

• Weekly sales verification: confirm that reported totals match system totals per store.
• Data quality checks: quickly identify stores with mismatched numbers due to syncing or entry errors.
• Operations oversight for SaaS operators: reduce manual reconciliation time by automating the comparison and alerting.

Technical details

• Integrations: Google Sheets and Gmail
• n8n nodes/logic: google sheets, merge, code (tolerance + discrepancy calculation), if (mismatch detection), gmail, plus a sticky note for workflow guidance

Setup requirements

• Add Google Sheets credentials and configure document ID + sheet name for both worksheets.
• Ensure both sheets include the required columns: Reported Sales (Store, Reported_Total) and System Sales (Store, System_Total).
• Add a Gmail credential and set the recipient address in the email node.
• Adjust the tolerance value in the reconciliation code if small differences should be allowed.
• Requires a Google account with Sheets and Gmail access enabled.