Reconcile cash balances in Google Sheets with OpenAI explanations
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 AI workflow has 12 nodes and runs on a schedule (every minute). Along the way it connects Google Sheets and OpenAI.
How it runs
Trigger: On a schedule (every minute).
- Fetch Internal Balances (Google Sheets): uses Google Sheets
- Fetch Custodian Balances (Google Sheets): uses Google Sheets
- Edit Internal Fields (Edit Fields (Set)): sets 3 fields: account_id, currency, internal_balance
- Edit Custodian Fields (Edit Fields (Set)): sets 3 fields: account_id, currency, custodian_balance
- Match Accounts by Account ID (Merge): merges the data from its input branches
- Calculate Balance Difference (Code): runs custom JavaScript code
- Check for Balance Mismatch (If): checks a condition and branches into true / false
- Generate AI Mismatch Explanation (OpenAI): uses OpenAI
- Log Matched Records (Google Sheets): append
- Prepare Exception Record (Code): runs custom JavaScript code
…plus 1 more step. 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 (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi - Edit Fields (Set)
n8n-nodes-base.set
From the author
Cash Reconciliation Checker with Google Sheets, OpenAI & n8n This workflow automatically compares internal cash balances with custodian or bank balances using Google Sheets, detects mismatches by accountid, calculates balance differences, logs matched records…