(Tung) OCR发票提取到电子表格副本
高级
这是一个Finance, AI领域的自动化工作流，包含 25 个节点。主要使用 If, Set, Code, Wait, GoogleDrive 等节点，结合人工智能技术实现智能自动化。 自动发票和收据OCR到Google表格 - 支持云端硬盘、Gmail和Telegram触发
前置要求
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •Telegram Bot Token
使用的节点 (25)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "qClJP4aIscQySnQK",
"meta": {
"instanceId": "b3df22d2875c82e3ba1883c50049ed9cee0bcabf99d2b486961d2245a09e3964",
"templateCredsSetupCompleted": true
},
"name": "(Tung) OCR发票提取到电子表格副本",
"tags": [],
"nodes": [
{
"id": "ceb8fcc7-c733-4842-8988-2f19695658e4",
"name": "提示词",
"type": "n8n-nodes-base.set",
"position": [
2320,
-1340
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7bba23a4-9ff4-4c0f-9702-6de444b8701e",
"name": "将文件转换为base64字符串",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2020,
-1340
],
"parameters": {},
"typeVersion": 1
},
{
"id": "df138485-9a6a-4d3e-a1ca-1c9568b5e76f",
"name": "Gemini API",
"type": "n8n-nodes-base.httpRequest",
"position": [
2620,
-1340
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "e104546f-cf93-43c4-b5b4-5c66b046a72e",
"name": "JSON转字符串",
"type": "n8n-nodes-base.set",
"position": [
2900,
-1220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "182783f8-5285-4506-aa7b-d6f1fdbf5492",
"name": "解析字符串",
"type": "n8n-nodes-base.code",
"position": [
3200,
-1220
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ca6d6fc1-8fce-48da-9de5-2395ff4ee3e8",
"name": "添加到Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
3500,
-1220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "5b512370-b6e8-4cb7-b4d3-333ba15ac666",
"name": "Google Drive获取收据",
"type": "n8n-nodes-base.googleDrive",
"position": [
1720,
-1340
],
"parameters": {},
"typeVersion": 3
},
{
"id": "76c34c54-8666-4b3d-bb3f-ae79a6847cde",
"name": "Telegram触发图片",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
1060,
-60
],
"webhookId": "ef2f6b1f-b608-4e2f-9abe-02fe8ae0f085",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "9e8e821f-b6f7-4014-937e-9fe734c0e9c9",
"name": "Gmail 触发器",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
1060,
-720
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "d3a929a9-441f-4896-9a98-d32f374c8a83",
"name": "分离二进制文件",
"type": "n8n-nodes-base.code",
"position": [
1940,
-480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "db81d68b-d937-47bd-adfc-215bd4797754",
"name": "遍历附件",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2100,
-740
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2cbb56fc-eb6a-4f61-8204-bcde99c164c4",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
1640,
-620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "97c167d3-db62-48ae-b9ab-4add617e1258",
"name": "遍历邮件",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1400,
-720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c4c4193a-983b-4f46-9d61-03ecff3157be",
"name": "等待保存",
"type": "n8n-nodes-base.wait",
"position": [
3020,
-720
],
"webhookId": "a6742af7-28b5-469a-92d6-3f74845692fd",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "df28230d-7d7d-4817-8aba-615a9a266ad5",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1400,
-1360
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f3ee46f7-b3a8-4dfd-8b1f-da92613d5fe9",
"name": "创建文件名",
"type": "n8n-nodes-base.code",
"position": [
2420,
-720
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d7bde712-ece9-4613-9771-379f99a2300d",
"name": "为Telegram创建文件名",
"type": "n8n-nodes-base.code",
"position": [
1400,
-60
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f564d3b2-9be8-4119-9cc2-b4a61809af9f",
"name": "Google Drive触发新文件",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
1060,
-1360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3f4adb77-2ab4-4e7f-b9d4-4b030aaf1f68",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-800
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "8a9de5a7-0314-49d0-b87f-513bbb5e9531",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-140
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "7b9dc2de-464d-4c76-9ec0-44717bf29753",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-1460
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "56c7a141-3265-4528-9f5c-ad3326bcf84e",
"name": "Google保存文件2",
"type": "n8n-nodes-base.googleDrive",
"position": [
1740,
-60
],
"parameters": {},
"typeVersion": 3
},
{
"id": "e7b8fa1b-9510-450d-a35e-4a0338efa9f0",
"name": "Google Drive保存文件",
"type": "n8n-nodes-base.googleDrive",
"position": [
2720,
-720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "95dc537f-75c1-47dc-b929-838b63f97e25",
"name": "等待保存数据",
"type": "n8n-nodes-base.wait",
"position": [
3820,
-1220
],
"webhookId": "211ca61f-1915-4fb7-9ebf-8304c75d536e",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "d40ea975-5a33-485c-9811-7444181209ca",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
-1480
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
}
],
"active": true,
"pinData": {},
"settings": {
"errorWorkflow": "7XxwbKvr4yHpGpKg",
"executionOrder": "v1"
},
"versionId": "a6b663dd-a23e-4e18-abb8-65c23310056a",
"connections": {
"If": {
"main": [
[
{
"node": "Split Out Binary Files",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Emails",
"type": "main",
"index": 0
}
]
]
},
"Prompt": {
"main": [
[
{
"node": "Gemini API",
"type": "main",
"index": 0
}
]
]
},
"Gemini API": {
"main": [
[
{
"node": "JSON to string",
"type": "main",
"index": 0
}
]
]
},
"Parse string": {
"main": [
[
{
"node": "Add to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Gmail Trigger": {
"main": [
[
{
"node": "Loop Over Emails",
"type": "main",
"index": 0
}
]
]
},
"JSON to string": {
"main": [
[
{
"node": "Parse string",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Google Drive Get Receipt",
"type": "main",
"index": 0
}
]
]
},
"Wait For Saving": {
"main": [
[
{
"node": "Loop Over Attachments",
"type": "main",
"index": 0
}
]
]
},
"Create File Name": {
"main": [
[
{
"node": "Google Drive Save Files",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Emails": {
"main": [
[
{
"node": "Loop Over Attachments",
"type": "main",
"index": 0
}
],
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Add to Google Sheets": {
"main": [
[
{
"node": "Wait For Saving Data",
"type": "main",
"index": 0
}
]
]
},
"Wait For Saving Data": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Attachments": {
"main": [
[],
[
{
"node": "Create File Name",
"type": "main",
"index": 0
}
]
]
},
"Split Out Binary Files": {
"main": [
[
{
"node": "Loop Over Emails",
"type": "main",
"index": 0
}
]
]
},
"Telegram Trigger Image": {
"main": [
[
{
"node": "Create File Name For Telegram",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Save Files": {
"main": [
[
{
"node": "Wait For Saving",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Get Receipt": {
"main": [
[
{
"node": "Move file to base64 string",
"type": "main",
"index": 0
}
]
]
},
"Move file to base64 string": {
"main": [
[
{
"node": "Prompt",
"type": "main",
"index": 0
}
]
]
},
"Create File Name For Telegram": {
"main": [
[
{
"node": "Google Save Files 2",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Trigger New Files": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 财务, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AIAutomationPro终极RAG聊天机器人v1 n8n市场模板
多语言Telegram RAG聊天机器人，集成监督AI和自动化Google Drive流程
If
Set
Wait
+29
128 节点Daniel Ng
客服机器人
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
发票处理与验证 - n8n 模板
基于Gmail、Drive、表格和OCR AI的发票验证与确认
If
Set
Code
+13
47 节点Dhrumil Patel
财务
WordPress博客自动化专业版（SEO主题）v2
WordPress自动博客专业版 - SEO主题内容自动化机器
If
Set
Xml
+21
63 节点Daniel Ng
人工智能
WordPress博客自动化专业版（深度研究）v1
WordPress自动博客专业版 - 含深度研究的内容自动化机器
If
Set
Xml
+24
77 节点Daniel Ng
人工智能
工作流信息
难度等级
高级
节点数量25
分类2
节点类型13
作者
Daniel Ng
@danielngA Growth Hacker, Digital Marketer & AI Automation Builder with 10+ years of experience in Digital Marketing & Workflow Automation. Based in Helsinki, Finland. For questions about my templates and customization, contact me at: daniel@aiautomationpro.org
外部链接
在 n8n.io 查看 →
分享此工作流