(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": {
"2cbb56fc-eb6a-4f61-8204-bcde99c164c4": {
"main": [
[
{
"node": "d3a929a9-441f-4896-9a98-d32f374c8a83",
"type": "main",
"index": 0
}
],
[
{
"node": "97c167d3-db62-48ae-b9ab-4add617e1258",
"type": "main",
"index": 0
}
]
]
},
"ceb8fcc7-c733-4842-8988-2f19695658e4": {
"main": [
[
{
"node": "df138485-9a6a-4d3e-a1ca-1c9568b5e76f",
"type": "main",
"index": 0
}
]
]
},
"df138485-9a6a-4d3e-a1ca-1c9568b5e76f": {
"main": [
[
{
"node": "e104546f-cf93-43c4-b5b4-5c66b046a72e",
"type": "main",
"index": 0
}
]
]
},
"182783f8-5285-4506-aa7b-d6f1fdbf5492": {
"main": [
[
{
"node": "ca6d6fc1-8fce-48da-9de5-2395ff4ee3e8",
"type": "main",
"index": 0
}
]
]
},
"9e8e821f-b6f7-4014-937e-9fe734c0e9c9": {
"main": [
[
{
"node": "97c167d3-db62-48ae-b9ab-4add617e1258",
"type": "main",
"index": 0
}
]
]
},
"e104546f-cf93-43c4-b5b4-5c66b046a72e": {
"main": [
[
{
"node": "182783f8-5285-4506-aa7b-d6f1fdbf5492",
"type": "main",
"index": 0
}
]
]
},
"df28230d-7d7d-4817-8aba-615a9a266ad5": {
"main": [
[],
[
{
"node": "5b512370-b6e8-4cb7-b4d3-333ba15ac666",
"type": "main",
"index": 0
}
]
]
},
"c4c4193a-983b-4f46-9d61-03ecff3157be": {
"main": [
[
{
"node": "db81d68b-d937-47bd-adfc-215bd4797754",
"type": "main",
"index": 0
}
]
]
},
"f3ee46f7-b3a8-4dfd-8b1f-da92613d5fe9": {
"main": [
[
{
"node": "e7b8fa1b-9510-450d-a35e-4a0338efa9f0",
"type": "main",
"index": 0
}
]
]
},
"97c167d3-db62-48ae-b9ab-4add617e1258": {
"main": [
[
{
"node": "db81d68b-d937-47bd-adfc-215bd4797754",
"type": "main",
"index": 0
}
],
[
{
"node": "2cbb56fc-eb6a-4f61-8204-bcde99c164c4",
"type": "main",
"index": 0
}
]
]
},
"ca6d6fc1-8fce-48da-9de5-2395ff4ee3e8": {
"main": [
[
{
"node": "95dc537f-75c1-47dc-b929-838b63f97e25",
"type": "main",
"index": 0
}
]
]
},
"95dc537f-75c1-47dc-b929-838b63f97e25": {
"main": [
[
{
"node": "df28230d-7d7d-4817-8aba-615a9a266ad5",
"type": "main",
"index": 0
}
]
]
},
"db81d68b-d937-47bd-adfc-215bd4797754": {
"main": [
[],
[
{
"node": "f3ee46f7-b3a8-4dfd-8b1f-da92613d5fe9",
"type": "main",
"index": 0
}
]
]
},
"d3a929a9-441f-4896-9a98-d32f374c8a83": {
"main": [
[
{
"node": "97c167d3-db62-48ae-b9ab-4add617e1258",
"type": "main",
"index": 0
}
]
]
},
"76c34c54-8666-4b3d-bb3f-ae79a6847cde": {
"main": [
[
{
"node": "d7bde712-ece9-4613-9771-379f99a2300d",
"type": "main",
"index": 0
}
]
]
},
"e7b8fa1b-9510-450d-a35e-4a0338efa9f0": {
"main": [
[
{
"node": "c4c4193a-983b-4f46-9d61-03ecff3157be",
"type": "main",
"index": 0
}
]
]
},
"5b512370-b6e8-4cb7-b4d3-333ba15ac666": {
"main": [
[
{
"node": "7bba23a4-9ff4-4c0f-9702-6de444b8701e",
"type": "main",
"index": 0
}
]
]
},
"7bba23a4-9ff4-4c0f-9702-6de444b8701e": {
"main": [
[
{
"node": "ceb8fcc7-c733-4842-8988-2f19695658e4",
"type": "main",
"index": 0
}
]
]
},
"d7bde712-ece9-4613-9771-379f99a2300d": {
"main": [
[
{
"node": "56c7a141-3265-4528-9f5c-ad3326bcf84e",
"type": "main",
"index": 0
}
]
]
},
"f564d3b2-9be8-4119-9cc2-b4a61809af9f": {
"main": [
[
{
"node": "df28230d-7d7d-4817-8aba-615a9a266ad5",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 财务, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
🐶 宠物店预约 AI 代理
🐶 宠物店预约 AI 代理
If
Set
Code
+
If
Set
Code
187 节点Bruno Dias
人工智能
发票处理与验证 - n8n 模板
基于Gmail、Drive、表格和OCR AI的发票验证与确认
If
Set
Code
+
If
Set
Code
47 节点Dhrumil Patel
财务
基于AI的MIS代理
基于AI的管理信息系统代理
If
Set
Code
+
If
Set
Code
129 节点Kumar Shivam
客户支持
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+
If
Set
Xml
125 节点Daniel Ng
内容创作
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+
If
N8n
Set
244 节点Amanda Benks
销售
AI 代理餐厅 [模板]
🤖 WhatsApp、Instagram 和 Messenger 的 AI 餐厅助手
If
N8n
Set
+
If
N8n
Set
239 节点Amanda Benks
其他
工作流信息
难度等级
高级
节点数量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 查看 →
分享此工作流