Automate payment gateway & database transaction reconciliation with Google Sheets
Code in JavaScript
Compare both transactions
comparedatasets
Finding Amount Difference
filter
Add missing transaction to Sheet
googleSheets
Adding Amount difference transactions
googleSheets
Transaction from Payment Gateway
googleSheets
Adding duplicate transactions
googleSheets
Finding duplicate transactions
Transactions from Local Database
googleSheets
Invalid transaction
googleSheets
Valid Transactions
googleSheets
Count valid transactions
summarize
Count invalid transactions
summarize
Count Number of Missing Transactions
summarize
Merge with all transactions count
Count Number of Amount Difference Transactions.
summarize
Adding the final count of transactions
googleSheets
Send report to reconciliation team
smtp
Schedule Trigger
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.