Typhoon_提交
中级
这是一个AI, IT Ops领域的自动化工作流，包含 8 个节点。主要使用 Code, GoogleSheets, ManualTrigger, ReadWriteFile, ExecuteCommand 等节点，结合人工智能技术实现智能自动化。 使用Typhoon OCR和Llama 3.1提取并结构化泰语文档至Google Sheets
前置要求
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "iPCOP0dstJZlKFQS",
"meta": {
"instanceId": "e2034325698638870d6b764285427bad9d79bf1e08a458be597c06e61ad7e545",
"templateCredsSetupCompleted": true
},
"name": "Typhoon_提交",
"tags": [],
"nodes": [
{
"id": "7d7df2fd-bc12-4850-aa9a-3e318bfed747",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
40,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "58290920-9b18-47dd-82b9-62c340b7ed53",
"name": "OpenRouter Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
600,
120
],
"parameters": {
"model": "scb10x/llama3.1-typhoon2-70b-instruct",
"options": {}
},
"credentials": {
"openRouterApi": {
"id": "dyclDhheSN7TDEE9",
"name": "OpenRouter account"
}
},
"typeVersion": 1
},
{
"id": "d42f2a8d-7bd5-462d-932c-34ee5de16592",
"name": "使用 Typhoon OCR 提取文本",
"type": "n8n-nodes-base.executeCommand",
"position": [
420,
0
],
"parameters": {
"command": "=python -c \"import sys, os; os.environ['TYPHOON_OCR_API_KEY'] = '<YourTyphoonKey>'; from typhoon_ocr import ocr_document; sys.stdout.reconfigure(encoding='utf-8'); input_path = sys.argv[1]; text = ocr_document(input_path); print(text)\" \"doc/{{$json[\"fileName\"]}}\"",
"executeOnce": false
},
"typeVersion": 1
},
{
"id": "d6d13619-f704-45d0-85fc-3e5b9dc4bd7a",
"name": "使用 LLM 将文本结构化到 JSON",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
600,
0
],
"parameters": {
"text": "=ข้อความด้านล่างนี้เป็นเนื้อหา OCR จากหนังสือราชการ กรุณาแยกหัวข้อสำคัญออกมาในรูปแบบ JSON:\n\n1. book_id: เลขที่หนังสือ\n2. date: วันที่ในเอกสาร\n3. subject: หัวเรื่อง\n4. to: เรียน\n5. attach: สิ่งที่ส่งมาด้วย\n6. detail: เนื้อความในหนังสือ\n7. signed_by: ผู้ลงนาม\n8. signed_by2: ตำแหน่งผู้ลงนาม\n9. contact: ช่องทางติดต่อ (เช่น เบอร์โทร อีเมล)\n10. download_url: ลิงก์สำหรับดาวน์โหลด (ถ้ามี)\n\nOCR_TEXT:\n\"\"\"\n{{ $json[\"stdout\"] }}\n\"\"\"",
"promptType": "define"
},
"typeVersion": 1.6
},
{
"id": "eaa9580c-9b98-42dc-a164-38430df41459",
"name": "将 JSON 解析为表格格式",
"type": "n8n-nodes-base.code",
"position": [
940,
0
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "const raw = $json[\"text\"];\n\n// 1. ลบ ```json และ ``` ที่ LLM อาจใส่มา\nconst cleaned = raw.replace(/```json\\n?|```/g, \"\").trim();\n\nlet parsed;\ntry {\n // 2. แปลงเป็น object\n parsed = JSON.parse(cleaned);\n} catch (err) {\n throw new Error(\"JSON parsing failed: \" + err.message + \"\\n\\nRaw text:\\n\" + cleaned);\n}\n\n// 3. หาก contact เป็น object แยก field ออกมา\nconst contact = parsed.contact || {};\n\nreturn {\n book_id: parsed.book_id || \"\",\n date: parsed.date || \"\",\n subject: parsed.subject || \"\",\n to: parsed.to || \"\",\n attach: parsed.attach || \"\",\n detail: parsed.detail || \"\",\n signed_by: parsed.signed_by || \"\",\n signed_by2: parsed.signed_by2 || \"\",\n contact_phone: contact.phone || \"\",\n contact_email: contact.email || \"\",\n contact_fax: contact.fax || \"\",\n download_url: parsed.download_url || \"\"\n};\n"
},
"typeVersion": 2
},
{
"id": "8e3e5e7e-d329-459e-bd85-31fc2f76144b",
"name": "保存到 Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1120,
0
],
"parameters": {
"columns": {
"value": {
"to": "={{ $json.to }}",
"date": "={{ $json.date }}",
"attach": "={{ $json.attach }}",
"detail": "={{ $json.detail }}",
"book_id": "={{ $json.book_id }}",
"subject": "={{ $json.subject }}",
"signed_by": "={{ $json.signed_by }}",
"signed_by2": "={{ $json.signed_by2 }}",
"contact_fax": "={{ $json.contact_fax }}",
"download_url": "={{ $json.download_url }}",
"contact_email": "={{ $json.contact_email }}",
"contact_phone": "={{ $json.contact_phone }}"
},
"schema": [
{
"id": "book_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "book_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "to",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "to",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "attach",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "attach",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "detail",
"type": "string",
"display": true,
"required": false,
"displayName": "detail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "signed_by",
"type": "string",
"display": true,
"required": false,
"displayName": "signed_by",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "signed_by2",
"type": "string",
"display": true,
"required": false,
"displayName": "signed_by2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contact_phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "contact_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contact_email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "contact_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contact_fax",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "contact_fax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "download_url",
"type": "string",
"display": true,
"required": false,
"displayName": "download_url",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"book_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1h70cJyLj5i2j0Ag5kqp93ccZjjhJnqpLmz-ee5r4brU/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1h70cJyLj5i2j0Ag5kqp93ccZjjhJnqpLmz-ee5r4brU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1h70cJyLj5i2j0Ag5kqp93ccZjjhJnqpLmz-ee5r4brU/edit?usp=drivesdk",
"cachedResultName": "TyphoonOCR_Extracted_Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Ra2f1dlqOJ13jTtb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "7b20ef0a-5d1f-4efe-bac3-53ace280cac2",
"name": "从 doc 文件夹加载 PDF",
"type": "n8n-nodes-base.readWriteFile",
"position": [
220,
0
],
"parameters": {
"options": {},
"fileSelector": "doc/*"
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "944977eb-2db6-430f-957e-345541ba8d39",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-100
],
"parameters": {
"width": 1320,
"height": 360,
"content": "## 泰语 OCR 到表格"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "dc1bd760-0abe-4125-b2f6-2eeb4d9b02eb",
"connections": {
"OpenRouter Chat Model": {
"ai_languageModel": [
[
{
"node": "Structure Text to JSON with LLM",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Load PDFs from doc Folder": {
"main": [
[
{
"node": "Extract Text with Typhoon OCR",
"type": "main",
"index": 0
}
]
]
},
"Parse JSON to Sheet Format": {
"main": [
[
{
"node": "Save to Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Extract Text with Typhoon OCR": {
"main": [
[
{
"node": "Structure Text to JSON with LLM",
"type": "main",
"index": 0
}
]
]
},
"Structure Text to JSON with LLM": {
"main": [
[
{
"node": "Parse JSON to Sheet Format",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Load PDFs from doc Folder",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 人工智能, IT 运维
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
TyphoonV2.2 多文件与多页面及带AI
使用TyphoonOCR和AI处理泰语文档至Google表格（多页PDF）
Code
Aggregate
Google Sheets
+7
15 节点Jaruphat J.
AI 摘要总结
自动报价视频V2_模板
使用AI自动创建电影式报价视频并上传至YouTube
Code
Wait
Google Drive
+6
28 节点Jaruphat J.
人工智能
自动剪辑 – 自动生成视频剪辑并上传到YouTube
使用FFmpeg自动创建并上传包含泰语引文的YouTube视频
Set
Code
Merge
+7
23 节点Jaruphat J.
产品
法律案例研究提取器，使用Bright Data MCP和Google Gemini的数据挖掘器
法律案例研究提取器，使用Bright Data MCP和Google Gemini的数据挖掘器
Set
Code
Wait
+10
22 节点Ranjan Dailata
人工智能
AI驱动的WooCommerce产品导入器与SEO
基于Google表格的AI驱动WooCommerce产品导入器，含Yoast SEO元数据
Code
Telegram
Woo Commerce
+7
16 节点Davide
销售
亚马逊产品搜索爬虫（BrightData、GPT-4和Google Sheets）
使用BrightData、GPT-4和Google Sheets的亚马逊产品搜索爬虫
Code
Split Out
Http Request
+7
11 节点phil
人工智能
工作流信息
难度等级
中级
节点数量8
分类2
节点类型8
作者
Jaruphat J.
@jaruphatjProject Manager who passionate about Automation & AI and continuously explore innovative ways to improve business processes through intelligent workflow automation. Let’s connect and automate the future!
外部链接
在 n8n.io 查看 →
分享此工作流