Telegram智能文件管理器（Drive + OCR集成）
高级
这是一个Document Extraction, Multimodal AI领域的自动化工作流，包含 33 个节点。主要使用 If, Set, Merge, Airtable, Telegram 等节点。 使用Telegram、Drive、OCR和Airtable构建可搜索文档档案库
前置要求
- •Airtable API Key
- •Telegram Bot Token
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "6D7Qa7LGmBt8ka3g",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "Telegram 智能文件管理器（Drive + OCR 集成）",
"tags": [],
"nodes": [
{
"id": "b1414d19-9d49-480b-be77-6d8709c86919",
"name": "Telegram 触发器",
"type": "n8n-nodes-base.telegramTrigger",
"notes": "Receives all incoming messages and documents from Telegram bot",
"position": [
-1264,
272
],
"webhookId": "telegram-smart-file-manager",
"parameters": {
"updates": [
"message",
"edited_message"
],
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "3ubbGgZx2YzylQZu",
"name": "Telegram account - test"
}
},
"typeVersion": 1.1
},
{
"id": "ae8100e3-c852-48a3-a564-f8d1524439cc",
"name": "检查是否为文件/图片",
"type": "n8n-nodes-base.if",
"notes": "Filters messages to process only documents and images",
"position": [
-1040,
272
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"conditions": [
{
"id": "condition-001",
"operator": {
"type": "object",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.message.document }}",
"rightValue": ""
},
{
"id": "condition-002",
"operator": {
"type": "object",
"operation": "exists"
},
"leftValue": "={{ $json.message.photo }}",
"rightValue": "",
"combineOperation": "or"
}
],
"combineOperation": "any"
}
},
"typeVersion": 2
},
{
"id": "0c28e059-5e63-4107-b8c9-02074ed7b7ca",
"name": "固定：检查文件",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1104,
144
],
"parameters": {
"color": 3,
"width": 200,
"height": 288,
"content": "🔍 **筛选器**：仅当消息包含文件或图片时继续"
},
"typeVersion": 1
},
{
"id": "5c25a662-adbc-44cb-a3ef-678aff284c6d",
"name": "提取文件元数据",
"type": "n8n-nodes-base.set",
"notes": "Extracts file ID, name, type and user info for processing",
"position": [
-816,
160
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "assign-001",
"name": "fileId",
"type": "string",
"value": "={{ $json.message.document?.file_id || $json.message.photo?.slice(-1)[0].file_id }}"
},
{
"id": "assign-002",
"name": "fileName",
"type": "string",
"value": "={{ $json.message.document?.file_name || 'image_' + $json.message.date + '.jpg' }}"
},
{
"id": "assign-003",
"name": "mimeType",
"type": "string",
"value": "={{ $json.message.document?.mime_type || 'image/jpeg' }}"
},
{
"id": "assign-004",
"name": "chatId",
"type": "number",
"value": "={{ $json.message.chat.id }}"
},
{
"id": "assign-005",
"name": "userName",
"type": "string",
"value": "={{ $json.message.from.first_name }} {{ $json.message.from.last_name || '' }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "5007396a-0dcf-4c74-ac08-eab12479ef61",
"name": "固定：提取元数据",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
0
],
"parameters": {
"color": 2,
"width": 210,
"height": 304,
"content": "📋 **提取**：fileId、名称、MIME 类型、聊天及用户信息"
},
"typeVersion": 1
},
{
"id": "79240107-39e4-4185-9cd2-d015b2fd2a39",
"name": "从 Telegram 下载文件",
"type": "n8n-nodes-base.telegram",
"notes": "Downloads the actual file content from Telegram servers",
"position": [
-608,
160
],
"webhookId": "2d85c25f-c520-4504-a788-2ed08dfce7aa",
"parameters": {
"fileId": "qwryuu75ewrjh",
"resource": "file",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "3ubbGgZx2YzylQZu",
"name": "Telegram account - test"
}
},
"typeVersion": 1.1
},
{
"id": "76a9187c-768d-40d9-97b0-4e93d2b09e40",
"name": "固定：下载文件",
"type": "n8n-nodes-base.stickyNote",
"position": [
-656,
-16
],
"parameters": {
"width": 220,
"height": 320,
"content": "⬇️ **下载**：通过 Telegram API 获取文件二进制数据"
},
"typeVersion": 1
},
{
"id": "b1a86b46-e69b-41cb-90b4-8c9bef5e4e59",
"name": "上传到 Google Drive",
"type": "n8n-nodes-base.googleDrive",
"notes": "Uploads file to Google Drive and returns Drive file ID",
"position": [
-384,
160
],
"parameters": {
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "root",
"cachedResultName": "/ (Root folder)"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "MGnTMJvH7MB4xBS9",
"name": "Google Drive account - test"
}
},
"typeVersion": 3
},
{
"id": "5695fd86-ddd8-40a1-ad2d-90debbc441bb",
"name": "固定：上传到 Drive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-432,
-16
],
"parameters": {
"color": 5,
"width": 220,
"height": 320,
"content": "☁️ **上传**：将文件保存到 Google Drive 根目录"
},
"typeVersion": 1
},
{
"id": "399a6769-627f-40b8-b2ea-c82a8c32eea9",
"name": "检查是否符合 OCR 条件",
"type": "n8n-nodes-base.if",
"notes": "Determines if file type supports OCR (images and PDFs)",
"position": [
-160,
160
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"conditions": [
{
"id": "ocr-condition-001",
"operator": {
"type": "string",
"operation": "startsWith"
},
"leftValue": "={{ $json.mimeType }}",
"rightValue": "image/"
},
{
"id": "ocr-condition-002",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.mimeType }}",
"rightValue": "application/pdf",
"combineOperation": "or"
}
],
"combineOperation": "any"
}
},
"typeVersion": 2
},
{
"id": "4fbd99c5-1138-41e6-ac76-1e37b179330e",
"name": "固定：OCR 资格检查",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
-16
],
"parameters": {
"color": 3,
"width": 200,
"height": 320,
"content": "🧠 **OCR 检查**：是否为图片或 PDF？"
},
"typeVersion": 1
},
{
"id": "c0310c17-5f48-4646-ae7e-6bbef0ef4504",
"name": "Google Vision OCR",
"type": "n8n-nodes-base.httpRequest",
"notes": "Performs OCR using Google Vision API to extract text from images",
"position": [
64,
64
],
"parameters": {
"url": "=https://vision.googleapis.com/v1/images:annotate",
"options": {},
"sendBody": true,
"authentication": "oAuth2",
"bodyParameters": {
"parameters": [
{
"name": "requests",
"value": "=[{\"image\":{\"content\":\"{{ $('Download File from Telegram').item.binary.data.data }}\"},\"features\":[{\"type\":\"TEXT_DETECTION\"}]}]"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "75dd9b9d-a291-4122-a6cd-98a09dc88fe7",
"name": "固定：Vision OCR",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-80
],
"parameters": {
"color": 6,
"width": 220,
"height": 320,
"content": "🔍 **OCR**：通过 Google Vision API 提取文本"
},
"typeVersion": 1
},
{
"id": "352815cf-6eda-4ac2-8e1e-de2f04975c56",
"name": "提取 OCR 文本",
"type": "n8n-nodes-base.set",
"notes": "Parses OCR results and extracts detected text content",
"position": [
272,
64
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "extract-text-001",
"name": "extractedText",
"type": "string",
"value": "={{ $json.responses[0]?.fullTextAnnotation?.text || 'No text detected' }}"
},
{
"id": "extract-text-002",
"name": "confidence",
"type": "string",
"value": "={{ $json.responses[0]?.fullTextAnnotation ? 'High' : 'None' }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "9ada9e69-ac35-4b83-a028-3f1f3e182cf0",
"name": "固定：提取 OCR 文本",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
-160
],
"parameters": {
"color": 2,
"width": 220,
"height": 352,
"content": "✂️ **解析**：从 OCR 响应中获取 fullTextAnnotation"
},
"typeVersion": 1
},
{
"id": "6d4867d7-32ef-4b1a-b219-fbbe4a06b2a0",
"name": "无需 OCR",
"type": "n8n-nodes-base.set",
"notes": "Sets default values for files that don't need OCR processing",
"position": [
64,
272
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "no-ocr-001",
"name": "extractedText",
"type": "string",
"value": "Not applicable for this file type"
},
{
"id": "no-ocr-002",
"name": "confidence",
"type": "string",
"value": "N/A"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "e3179bd4-e6d9-4931-8133-d9856a2ddbf2",
"name": "固定：无需 OCR",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
400
],
"parameters": {
"color": 7,
"width": 200,
"height": 240,
"content": "➖ **跳过 OCR**：非图片/PDF 文件"
},
"typeVersion": 1
},
{
"id": "d4cbfc85-2c1e-4b18-92ce-9d245caefc77",
"name": "合并 OCR 路径",
"type": "n8n-nodes-base.merge",
"notes": "Combines results from OCR and non-OCR processing paths",
"position": [
400,
160
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "ba51bc68-77df-4727-9bb3-11febae993cc",
"name": "在 Airtable 中建立索引",
"type": "n8n-nodes-base.airtable",
"notes": "Stores file metadata and extracted text in searchable Airtable database",
"position": [
624,
160
],
"parameters": {
"base": {
"__rl": true,
"mode": "id",
"value": "juu7654retyu"
},
"table": {
"__rl": true,
"mode": "id",
"value": "6ikkiu654erfghyt54321q"
},
"columns": {
"value": {},
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "ZtCtLnlIDAwG9TWC",
"name": "Airtable - test"
}
},
"typeVersion": 2
},
{
"id": "838b0f5b-987d-4d35-b03e-e21e71bd8183",
"name": "固定：Airtable 索引",
"type": "n8n-nodes-base.stickyNote",
"position": [
544,
80
],
"parameters": {
"color": 8,
"width": 230,
"height": 224,
"content": "📊 **索引**：将元数据 + OCR 文本保存到 Airtable"
},
"typeVersion": 1
},
{
"id": "aa68c4ad-3bbc-4d71-b822-7a4eb988eba2",
"name": "发送成功消息",
"type": "n8n-nodes-base.telegram",
"notes": "Sends confirmation message to user with file details and preview",
"position": [
848,
160
],
"webhookId": "e2e530f0-c122-4f94-984f-c6c05046c838",
"parameters": {
"text": "=✅ **File Uploaded Successfully!**\n\n📁 **File:** {{ $json.fileName }}\n🔗 **Drive Link:** {{ $('Upload to Google Drive').item.json.webViewLink }}\n📝 **Extracted Text:** {{ $json.extractedText.substring(0, 200) }}{{ $json.extractedText.length > 200 ? '...' : '' }}\n⏰ **Uploaded:** {{ $now.format('yyyy-MM-dd HH:mm') }}",
"chatId": "={{ $json.chatId }}",
"additionalFields": {
"parse_mode": "Markdown"
}
},
"credentials": {
"telegramApi": {
"id": "3ubbGgZx2YzylQZu",
"name": "Telegram account - test"
}
},
"typeVersion": 1.1
},
{
"id": "5a85d261-8535-4024-aa0a-d13508ab68b0",
"name": "固定：成功消息",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
16
],
"parameters": {
"color": 4,
"width": 220,
"height": 288,
"content": "✅ **通知**：包含链接和预览的成功消息"
},
"typeVersion": 1
},
{
"id": "247f8290-8372-41b6-af93-d50004d49a27",
"name": "发送错误消息",
"type": "n8n-nodes-base.telegram",
"notes": "Notifies user if any error occurs during processing",
"position": [
848,
368
],
"webhookId": "ca690436-1dd4-4477-91d8-e74cb33d07a0",
"parameters": {
"text": "❌ **Error Processing File**\n\nSorry, something went wrong while processing your file. Please try again later.",
"chatId": "={{ $json.chatId }}",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "3ubbGgZx2YzylQZu",
"name": "Telegram account - test"
}
},
"typeVersion": 1.1
},
{
"id": "6c943962-95b5-40c0-8492-daa5a5421bbf",
"name": "固定：错误消息",
"type": "n8n-nodes-base.stickyNote",
"position": [
768,
528
],
"parameters": {
"width": 200,
"height": 70,
"content": "❌ **错误**：失败时通知用户"
},
"typeVersion": 1
},
{
"id": "d645926d-5289-4878-b6fd-12d6e7b0490b",
"name": "检查搜索命令",
"type": "n8n-nodes-base.if",
"notes": "Detects if user wants to search indexed files using /search command",
"position": [
-816,
464
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"conditions": [
{
"id": "search-condition-001",
"operator": {
"type": "string",
"operation": "startsWith"
},
"leftValue": "={{ $json.message.text }}",
"rightValue": "/search "
}
],
"combineOperation": "any"
}
},
"typeVersion": 2
},
{
"id": "9328c7e3-6c2b-4d0c-897f-0cbf92c61ce8",
"name": "固定：搜索命令",
"type": "n8n-nodes-base.stickyNote",
"position": [
-944,
592
],
"parameters": {
"color": 3,
"width": 200,
"height": 70,
"content": "🔎 **检测**：/search <查询> 命令"
},
"typeVersion": 1
},
{
"id": "56783c48-c377-4415-90b2-66f6793196ef",
"name": "提取搜索查询",
"type": "n8n-nodes-base.set",
"notes": "Extracts the search keywords from user's message",
"position": [
-608,
464
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "search-query-001",
"name": "searchQuery",
"type": "string",
"value": "={{ $json.message.text.replace('/search ', '').trim() }}"
},
{
"id": "search-chat-001",
"name": "chatId",
"type": "number",
"value": "={{ $json.message.chat.id }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "6da1bc77-fe2b-4d7d-af2f-96956d2ada79",
"name": "固定：提取查询",
"type": "n8n-nodes-base.stickyNote",
"position": [
-656,
592
],
"parameters": {
"color": 2,
"width": 210,
"height": 70,
"content": "✂️ **解析**：提取 /search 后的查询内容"
},
"typeVersion": 1
},
{
"id": "2a8429f9-89fe-4387-872d-fb6bc4702eac",
"name": "在索引中搜索",
"type": "n8n-nodes-base.airtable",
"notes": "Searches indexed files for matching text content",
"position": [
-384,
464
],
"parameters": {
"base": {
"__rl": true,
"mode": "id",
"value": "vbhytrewsxcv"
},
"table": {
"__rl": true,
"mode": "id",
"value": "vcde456yuhgfdsz"
},
"options": {},
"operation": "search",
"filterByFormula": "=SEARCH(LOWER(\"{{ $json.searchQuery }}\"), LOWER({extracted_text}))"
},
"credentials": {
"airtableTokenApi": {
"id": "ZtCtLnlIDAwG9TWC",
"name": "Airtable - test"
}
},
"typeVersion": 2
},
{
"id": "e82131ab-bb70-41d1-a904-d0d088fb3c53",
"name": "固定：搜索索引",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
384
],
"parameters": {
"color": 6,
"width": 230,
"height": 70,
"content": "🔍 **搜索**：在 Airtable 的 extracted_text 字段进行全文搜索"
},
"typeVersion": 1
},
{
"id": "81969e62-0c4b-43e4-ab04-d6d4c9978f7c",
"name": "发送搜索结果",
"type": "n8n-nodes-base.telegram",
"notes": "Returns search results with file links to user",
"position": [
-160,
464
],
"webhookId": "595d3b2f-567b-435e-88a5-0682165f9080",
"parameters": {
"text": "=🔍 **Search Results for:** \"{{ $json.searchQuery }}\"\n\n{{ $('Search in Index').all().map((item, i) => `${i + 1}. **${item.json.fields.file_name}**\\n🔗 ${item.json.fields.drive_file_url}\\n📝 Preview: ${item.json.fields.extracted_text?.substring(0, 100)}...\\n`).join('\\n') || 'No results found.' }}",
"chatId": "={{ $json.chatId }}",
"additionalFields": {
"parse_mode": "Markdown"
}
},
"credentials": {
"telegramApi": {
"id": "3ubbGgZx2YzylQZu",
"name": "Telegram account - test"
}
},
"typeVersion": 1.1
},
{
"id": "d7cafa5b-c77f-4cc7-bc80-36491aa20d4e",
"name": "固定：搜索结果",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
384
],
"parameters": {
"color": 4,
"width": 220,
"height": 70,
"content": "📋 **结果**：发送匹配文件及预览"
},
"typeVersion": 1
},
{
"id": "3896a4e4-efa1-42af-af9b-d1954ac06471",
"name": "固定：触发器",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1344,
192
],
"parameters": {
"color": 4,
"width": 220,
"height": 224,
"content": "🎯 **触发器**：监听用户的新消息/文档"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "32fa1b16-0531-459e-a037-441d674eb57f",
"connections": {
"No OCR Needed": {
"main": [
[
{
"node": "Merge OCR Paths",
"type": "main",
"index": 1
},
{
"node": "Send Error Message",
"type": "main",
"index": 0
}
]
]
},
"Merge OCR Paths": {
"main": [
[
{
"node": "Index in Airtable",
"type": "main",
"index": 0
}
]
]
},
"Search in Index": {
"main": [
[
{
"node": "Send Search Results",
"type": "main",
"index": 0
}
]
]
},
"Extract OCR Text": {
"main": [
[
{
"node": "Merge OCR Paths",
"type": "main",
"index": 0
}
]
]
},
"Telegram Trigger": {
"main": [
[
{
"node": "Check if File/Image",
"type": "main",
"index": 0
},
{
"node": "Check Search Command",
"type": "main",
"index": 0
}
]
]
},
"Google Vision OCR": {
"main": [
[
{
"node": "Extract OCR Text",
"type": "main",
"index": 0
}
]
]
},
"Index in Airtable": {
"main": [
[
{
"node": "Send Success Message",
"type": "main",
"index": 0
}
]
]
},
"Check if File/Image": {
"main": [
[
{
"node": "Extract File Metadata",
"type": "main",
"index": 0
}
]
]
},
"Check Search Command": {
"main": [
[
{
"node": "Extract Search Query",
"type": "main",
"index": 0
}
]
]
},
"Extract Search Query": {
"main": [
[
{
"node": "Search in Index",
"type": "main",
"index": 0
}
]
]
},
"Check if OCR Eligible": {
"main": [
[
{
"node": "Google Vision OCR",
"type": "main",
"index": 0
}
],
[
{
"node": "No OCR Needed",
"type": "main",
"index": 0
}
]
]
},
"Extract File Metadata": {
"main": [
[
{
"node": "Download File from Telegram",
"type": "main",
"index": 0
}
]
]
},
"Upload to Google Drive": {
"main": [
[
{
"node": "Check if OCR Eligible",
"type": "main",
"index": 0
}
]
]
},
"Download File from Telegram": {
"main": [
[
{
"node": "Upload to Google Drive",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 文档提取, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
家居装饰AI（Google Nano Banana）- Santhej Kallada
基于Google Gemini的AI图像生成与编辑及Telegram机器人
If
Set
Code
+9
28 节点Santhej Kallada
内容创作
💥 HeyGen II - 克隆我 - 从想法到发布：适用于 YouTube、TikTok 和 Instagram 的 GPT-5 视频自动化 - 视频
使用 HeyGen、GPT-5 和社交发布自动化语音输入视频创作
If
Set
Wait
+13
41 节点Dr. Firas
内容创作
💥 HeyGen - 从想法到发布：用于 YouTube、TikTok 和 Instagram 的 GPT-5 视频自动化 - 视频
使用 GPT-5 生成 AI 虚拟形象视频并发布至社交媒体平台
If
Set
Wait
+13
41 节点Dr. Firas
内容创作
音频转录 - n8n创作者（模板）
使用Telegram和Groq Whisper的音频转录
If
Set
Switch
+5
22 节点Abhiman
文档提取
🎙️ VoiceScribe AI：使用 OpenAI Whisper 自动转录 Telegram 音频消息
使用 OpenAI Whisper 和 Google Workspace 自动转录 Telegram 语音消息
If
Code
Merge
+6
19 节点Trung Tran
文档提取
AI驱动视频创作与上传至Instagram、TikTok和YouTube
从云端硬盘进行AI驱动视频创作并上传至Instagram、TikTok和YouTube
If
Set
Code
+14
53 节点DevCode Journey
内容创作
工作流信息
难度等级
高级
节点数量33
分类2
节点类型9
作者
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
外部链接
在 n8n.io 查看 →
分享此工作流