Skip to content
FlowHub
FluxonLab
Google Sheets
Document AI & Extractionfree

Data comparison n8n

by Mohamed AbubakkarUpdated Aug 2026
RequiresGoogle SheetsGoogle SheetsEmail (SMTP)Email (SMTP)
Share Post Share
CoCode in JavaScriptCode in JavaScr…CDCompare both transactionsCompare both tr…FiFinding Amount DifferenceFinding Amount …Add missing transaction to SheetAdd missing tra…Adding Amount difference transactionsAdding Amount d…Transaction from Payment GatewayTransaction fro…Adding duplicate transactionsAdding duplicat…CoFinding duplicate transactionsFinding duplica…Transactions from Local DatabaseTransactions fr…Invalid transactionInvalid transac…Valid TransactionsValid Transacti…SuCount valid transactionsCount valid tra…SuCount invalid transactionsCount invalid t…SuCount Number of Missing TransactionsCount Number of…MeMerge with all transactions countMerge with all …SuCount Number of Amount Difference Transactions.Count Number of…Adding the final count of transactionsAdding the fina…ESSend report to reconciliation teamSend report to …ScSchedule Trigger12345678910111213141516171819202122
1/5
STEPS · 22
Runs on a schedule

On schedule, compares two datasets, writes the differences to Google Sheets, and emails a summary via SMTP.

Tags

croncomplexGoogle SheetsEmail (SMTP)Document Extractiondiscoveredpending-review
Connects
sheetsGoogle SheetsemailsmtpEmail (SMTP)
CategoryDocument AI & Extraction
Triggercron
Complexitycomplex
Nodes19
AddedJun 27, 2026