Automate payment gateway & database transaction reconciliation with Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 19 nodes and runs on a schedule (every day). Along the way it connects Google Sheets.
How it runs
Trigger: On a schedule (every day).
- Transactions from Local Database (Google Sheets): uses Google Sheets
- Transaction from Payment Gateway (Google Sheets): uses Google Sheets
- Compare both transactions (Compare Datasets): uses Compare Datasets
- Finding duplicate transactions (Code): runs custom JavaScript code
- Invalid transaction (Google Sheets): append or update
- Valid Transactions (Google Sheets): append or update
- Finding Amount Difference (Filter): keeps only the items that match a condition
- Add missing transaction to Sheet (Google Sheets): append or update
- Adding duplicate transactions (Google Sheets): append or update
- Count invalid transactions (Summarize): summarizes / groups the items
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Code
n8n-nodes-base.code - Compare Datasets
n8n-nodes-base.compareDatasets - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - Summarize
n8n-nodes-base.summarize - Merge
n8n-nodes-base.merge - Send Email
n8n-nodes-base.emailSend - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
How it works This workflow fully automates the reconciliation process between your Local Database transactions and Payment Gateway transactions. It compares both data sources, identifies mismatches, categorizes discrepancies, logs them into Google Sheets,…