Automate Bank Statement and Invoice Reconciliation with GPT and Google Sheets β n8n Workflow
Overview
π’ Manual Trigger
Workflow starts manually to initiate the reconciliation process on demand.
π Fetch Invoices & Bank Statements
Retrieves invoice data and bank statement data from Google Sheets for comparison.
π Merge Data
Combines both datasets into a single structured dataset for processing.
π§© Format Payload for AI
Function node prepares and structures the merged data into a clean JSON payload for AI analysis.
π€ AI Reconciliation
AI Agent analyzes the invoice and bank statement data to
Nodes used
Workflow Preview
How it Works
- 1
Trigger
The workflow starts with a trigger trigger.
- 2
Process
Data flows through 16 nodes, connecting agent, code, googlesheets.
- 3
Output
The workflow completes its automation and delivers the result to the configured destination.
Node Details (16)
Google Sheets
googleSheets
Code
code
AI Agent
n8n-nodes-langchain.agent
OpenAI Chat Model
n8n-nodes-langchain.lmChatOpenAi
How to Import This Workflow
- 1Click Download JSON button on the right to save the workflow file.
- 2Open your n8n instance. Go to Workflows β New β Import from file.
- 3Select the downloaded
automate-bank-statement-and-invoice-reconciliation-with-gpt-and-google-sheetsfile and click Import. - 4Set up credentials for each service node (API keys, OAuth, etc.).
- 5Click Test Workflow to verify everything works, then activate it.
Or paste directly in n8n β Import from JSON:
Integrations
Created by
Chintan Prajapati
@satva-technolabs
Tags
New to n8n?
n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.
Get n8n Free β