Automate Bank Statement and Invoice Reconciliation with GPT and Google Sheets — n8n 工作流
概览
🟢 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
使用的节点
Google SheetsCodeAI AgentOpenAI Chat Model
工作流预览
⚡
W
When clicking ‘Execute w…
Invoice Data
Bank Statements
OpenAI Chat Model
Process the Invoice Vs B…
M
Merge
Combine and Label Merged…
S
Switch
Matched
Possible Matches
I
If
Unmatched_Invoice
Unmatched-Bank Transaction
Summary
Clean and Format Data
Add Stream Label Filter
16 nodes16 edges
工作原理
- 1
触发器
工作流由 触发器 触发器启动。
- 2
处理
数据流经 16 个节点, connecting agent, code, googlesheets。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (16)
GO#1
Google Sheets
googleSheets
CO#2
Code
code
AI#3
AI Agent
n8n-nodes-langchain.agent
OP#4
OpenAI Chat Model
n8n-nodes-langchain.lmChatOpenAi
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例,依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
automate-bank-statement-and-invoice-reconciliation-with-gpt-and-google-sheets文件并点击导入。 - 4为每个服务节点配置 凭证(API 密钥、OAuth 等)。
- 5点击 测试工作流 验证一切正常,然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴:
{ "name": "Automate Bank Statement and Invoice Reconciliation with GPT and Google Sheets", "nodes": [...], ...}
集成
agentcodegooglesheetsiflmchatopenaimanualtriggermergeswitch
创建者
Chintan Prajapati
@satva-technolabs
标签
agentcodegooglesheetsiflmchatopenaimanualtriggermergeswitch