通过Telegram OCR从YAPE收据提取数据并存储到Google表格
高级
这是一个Finance, AI领域的自动化工作流，包含 35 个节点。主要使用 Code, Switch, Telegram, GoogleDrive, GoogleSheets 等节点，结合人工智能技术实现智能自动化。 通过Telegram OCR从YAPE收据提取数据并存储到Google表格
前置要求
- •Telegram Bot Token
- •Google Drive API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (35)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "1Pv5C6tDnHKLP42m",
"meta": {
"instanceId": "776aed41e1386255bdcc5feb11ff26417e83dd7ef78fc4f1d04858678b48a66f",
"templateCredsSetupCompleted": true
},
"name": "通过Telegram OCR从YAPE收据提取数据并存储到Google Sheets",
"tags": [
{
"id": "xZhfVLCNfp6aB2RH",
"name": "Agente",
"createdAt": "2025-03-04T07:58:57.181Z",
"updatedAt": "2025-03-04T07:58:57.181Z"
}
],
"nodes": [
{
"id": "556d84c0-06f4-487d-8ae5-9b95e2405168",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
-340
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "77d801b4-01b0-404d-8c8d-5a6631c5dcfd",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
-340
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "96ee5290-a18a-4f06-900f-76e18cf5d01e",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
-340
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "2432598f-f665-4af2-b4c5-1436fa3ac4fa",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-340
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "d4d83da2-6ea4-462a-999c-6acb76045e41",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
400
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "cdf5c835-2e62-4e43-a133-d06b3deb6261",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
40
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "f7e07754-7daa-4eb0-9988-f0c410cdd909",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1520,
-340
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "2c0d137c-d9cf-4f6a-a17c-b6406940f21c",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1920,
-340
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "0bb7d6ee-53a7-4774-bf67-503d38b54fee",
"name": "## 为什么选择 4o 模型？👆",
"type": "n8n-nodes-base.stickyNote",
"position": [
2460,
-340
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "7d08bb2e-19f7-4e09-9057-9ec595eca07b",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
1520,
140
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "c80b2310-3cd4-42fe-826a-af0498339f2a",
"name": "🛎️Telegram监听器",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-300,
-160
],
"webhookId": "d618052b-6fbf-41eb-8f5d-94ec3d1e52a3",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "7eec866f-c414-4039-b2d6-c71e8be0e84a",
"name": "🔀 消息分类器",
"type": "n8n-nodes-base.switch",
"position": [
-60,
-160
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "1c3196df-9e55-4740-bc3d-dad52b4c42a1",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
140
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "04b483a8-4dd1-457c-b986-a1be02c1a3ea",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-340,
-180
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "65bcfc3a-6c2f-4854-b06b-b97b81a1671b",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-180
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "0f553483-1028-49a3-8909-af240c61e350",
"name": "便签 14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-360,
-320
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "c8574753-3971-4b46-819e-a93cb43868ec",
"name": "🔀 开始命令处理",
"type": "n8n-nodes-base.switch",
"position": [
260,
-240
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "8dfcb5c5-0a3a-4be1-835d-43ae8058529c",
"name": "✉️ 发送欢迎消息",
"type": "n8n-nodes-base.telegram",
"position": [
500,
-240
],
"webhookId": "6166a70a-dfc2-49f3-816d-40f9f43771e4",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "cdfc4a26-f699-41a9-8139-ef8b46c0abb4",
"name": "便签 15",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
680
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "4e81ffe0-53f5-41c2-a9bd-2121791631bd",
"name": "便签16",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-60
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "fab3c3d3-49f8-42f2-82e8-c9b7532c3f3a",
"name": "🗂️选择最佳质量图片",
"type": "n8n-nodes-base.code",
"notes": "Process the message to get the file_id of the image",
"position": [
240,
500
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "05bac483-aaf3-494b-8cf6-629d2379cf62",
"name": "便签17",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
300
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "cf8f52ca-ba7f-4645-af92-f35cf568e5c4",
"name": "🖼️获取图片附件",
"type": "n8n-nodes-base.telegram",
"position": [
380,
120
],
"webhookId": "f0ac13cf-72df-4bb8-8a80-b6baba880b06",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "d89cb70a-e043-4273-8a64-e4e820a30193",
"name": "🖼️下载高质量图片",
"type": "n8n-nodes-base.telegram",
"position": [
480,
500
],
"webhookId": "f0ac13cf-72df-4bb8-8a80-b6baba880b06",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c50cdead-3d99-4cb5-ad69-852f869bb2d5",
"name": "📄 使用OCR提取文本",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
840,
-180
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "31c8539d-9947-4ff4-abf8-c219134a8737",
"name": "🤖 AI数据处理器",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1140,
-180
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "8b78d2f1-5045-470d-9e0c-8e77a1553573",
"name": "🧠 用于处理的AI模型",
"type": "@n8n/n8n-nodes-langchain.lmChatDeepSeek",
"position": [
1100,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e6fec2a6-adaa-4d10-a485-10309843e4f6",
"name": "便签18",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
140
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "1c9d91e4-c891-46ca-97c1-9d1304ca2cd7",
"name": "🔍 在Drive中查找Google Sheet",
"type": "n8n-nodes-base.googleDrive",
"position": [
1640,
-120
],
"parameters": {},
"typeVersion": 3,
"alwaysOutputData": false
},
{
"id": "098a5510-3385-46bf-831e-5983d3971fa1",
"name": "🔄 准备插入数据",
"type": "n8n-nodes-base.code",
"position": [
2000,
-120
],
"parameters": {},
"typeVersion": 2
},
{
"id": "332f9c11-a32a-45c7-8837-18a6ff1f9f70",
"name": "📑 将数据插入Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2240,
-120
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "3165b063-3271-4ca8-a2a9-7a06c58fea01",
"name": "便签19",
"type": "n8n-nodes-base.stickyNote",
"position": [
2460,
140
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "d534f380-0059-4064-9560-d2a6a9f1ebe0",
"name": "✉️ 向用户发送分析结果",
"type": "n8n-nodes-base.telegram",
"position": [
2580,
-200
],
"webhookId": "6f98701d-3b50-4920-904a-2dfae8b5817e",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "eddd1ab0-a4f7-45d7-8694-d064081b4c1d",
"name": "便签20",
"type": "n8n-nodes-base.stickyNote",
"position": [
1920,
140
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "271694c5-f43e-45a7-8e16-635fe1d888a3",
"name": "便签21",
"type": "n8n-nodes-base.stickyNote",
"position": [
2740,
-200
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "c1cb5829-a6b3-45a8-91da-3bc257f50a4d",
"connections": {
"🤖 AI Data Processor": {
"main": [
[
{
"node": "🔍 Find Google Sheet in Drive",
"type": "main",
"index": 0
}
]
]
},
"🔀 Message Classifier": {
"main": [
[
{
"node": "🔀 Start Command Handle",
"type": "main",
"index": 0
}
],
[
{
"node": "🖼️Retrieve Image Attachment",
"type": "main",
"index": 0
}
],
[
{
"node": "🗂️Select Best Quality Image",
"type": "main",
"index": 0
}
]
]
},
"🛎️Telegram Listener": {
"main": [
[
{
"node": "🔀 Message Classifier",
"type": "main",
"index": 0
}
]
]
},
"🔀 Start Command Handle": {
"main": [
[
{
"node": "✉️ Send Welcome Message",
"type": "main",
"index": 0
}
]
]
},
"📄 Extract Text with OCR": {
"main": [
[
{
"node": "🤖 AI Data Processor",
"type": "main",
"index": 0
}
]
]
},
"🧠 AI Model for Processing": {
"ai_languageModel": [
[
{
"node": "🤖 AI Data Processor",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"🔄 Prepare Data for Insertion": {
"main": [
[
{
"node": "📑 Insert Data into Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"🔍 Find Google Sheet in Drive": {
"main": [
[
{
"node": "🔄 Prepare Data for Insertion",
"type": "main",
"index": 0
}
],
[]
]
},
"🖼️Retrieve Image Attachment": {
"main": [
[
{
"node": "📄 Extract Text with OCR",
"type": "main",
"index": 0
}
]
]
},
"🗂️Select Best Quality Image": {
"main": [
[
{
"node": "🖼️Download High-Quality Image",
"type": "main",
"index": 0
}
]
]
},
"🖼️Download High-Quality Image": {
"main": [
[
{
"node": "📄 Extract Text with OCR",
"type": "main",
"index": 0
}
]
]
},
"📑 Insert Data into Google Sheets": {
"main": [
[
{
"node": "✉️ Send Analysis Result to User",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 财务, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
📊 WhatsApp和Telegram的AI令牌追踪器 - 将AI使用情况保存到Google表格
📊 WhatsApp和Telegram的AI令牌追踪器 - 将AI使用情况保存到Google表格
If
Set
Code
+15
37 节点Amanda Benks
财务
智能资金管理器
基于Telegram、Google Sheets和OpenAI的AI驱动收据和支出追踪器
If
Set
Code
+13
50 节点Khairul Muhtadin
财务
个人 - 申请 TRM
通过 Telegram 机器人和 AI 日期识别获取哥伦比亚比索兑美元汇率
If
Set
Code
+16
31 节点Juan Sanchez
财务
AI驱动的Telegram助手终极入门指南（PDF、Brave搜索和Google套件）
使用Gemini、RAG PDF搜索和Google套件构建多功能Telegram机器人
Set
Code
Wait
+26
79 节点Issam AGGOUR
人工智能
音乐生成工作流
使用 Suno API、Flux、Runway 和 Creatomate 生成 AI 歌曲和音乐视频
Set
Wait
Merge
+16
60 节点Joseph
其他
哥伦比亚发票处理
使用Gmail、GPT-4o和Google Workspace提取并整理哥伦比亚发票
Xml
Code
Merge
+15
23 节点Juan Sanchez
财务
工作流信息
难度等级
高级
节点数量35
分类2
节点类型10
作者
Jesús Pérez
@jasp402JASP402 | Developer Fullstack y QA Automation | Apasionado por la automatización con n8n. Creo workflows personalizados y eficientes para optimizar tus procesos. He desarrollado frameworks y librerías para potenciar la automatización. ¡Conecta conmigo para descubrir cómo puedo ayudarte!
外部链接
在 n8n.io 查看 →
分享此工作流