使用JSON、Google表格和GPT-4o自动化SAP B1日记账分录
高级
这是一个Document Extraction, AI Summarization领域的自动化工作流，包含 25 个节点。主要使用 Set, Code, Merge, Switch, Webhook 等节点。 使用JSON、Google表格和GPT-4o自动化SAP B1日记账分录
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "6f68qrMxAD14jS4i",
"meta": {
"instanceId": "558d88703fb65b2d0e44613bc35916258b0f0bf983c5d4730c00c424b77ca36a"
},
"name": "我的工作流 4",
"tags": [
{
"id": "GvklsLWXMBUjgBiK",
"name": "SAPB1-2=Finanzas",
"createdAt": "2025-07-03T12:55:09.224Z",
"updatedAt": "2025-07-03T12:55:09.224Z"
}
],
"nodes": [
{
"id": "6f3055d0-2612-49e5-8b70-ade568596658",
"name": "Webhook触发器",
"type": "n8n-nodes-base.webhook",
"position": [
-1820,
720
],
"webhookId": "991024c1-f7fc-4515-99ef-2b53df96f8cb",
"parameters": {},
"typeVersion": 1
},
{
"id": "a85066bb-91fa-4e1f-bb09-d7164165b2f6",
"name": "SAP 登录",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1580,
720
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "a53020c0-c167-4cf1-9597-95b07d7b87cd",
"name": "按来源路由",
"type": "n8n-nodes-base.switch",
"position": [
-1300,
720
],
"parameters": {},
"typeVersion": 3.2,
"alwaysOutputData": false
},
{
"id": "08c6fdef-b4e9-4f82-8080-7f8d06ba4336",
"name": "映射 JSON 字段",
"type": "n8n-nodes-base.set",
"position": [
-720,
480
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "ff7679dd-811c-4b83-9e35-f61c4a6ac2b2",
"name": "发布日记账（JSON）",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
-480,
480
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "838b28c5-1ccb-40bc-9e07-88569e11287f",
"name": "记录成功（JSON）",
"type": "n8n-nodes-base.googleSheets",
"position": [
-240,
320
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": false
},
{
"id": "1900cd98-9b64-41f7-af03-68018376e6da",
"name": "记录错误（JSON）",
"type": "n8n-nodes-base.googleSheets",
"position": [
-240,
540
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "a9d367d5-cef4-40d8-8d13-dc0da04e424a",
"name": "LLM 转换（手动）",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-780,
1500
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "41f1f35e-a4b2-4510-8910-8b1742df417f",
"name": "发布日记账（手动）",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
-380,
1500
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "2c445e36-67b3-44c1-912d-1225ab4d5077",
"name": "记录成功（手动）",
"type": "n8n-nodes-base.googleSheets",
"position": [
-100,
1360
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "42d94e4b-0a1d-482a-88bb-5397129dd29a",
"name": "记录错误（手动）",
"type": "n8n-nodes-base.googleSheets",
"position": [
-100,
1580
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "fab58a6e-27c7-4021-9183-065d40f25e7d",
"name": "设置 SAP 数据",
"type": "n8n-nodes-base.set",
"position": [
-740,
980
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "980fa23f-1850-4594-9e92-6aea0a6e62bb",
"name": "加载表格数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
-480,
1100
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "d83ac837-292a-4a5c-b537-e89d3671c23c",
"name": "整理表格行",
"type": "n8n-nodes-base.set",
"position": [
-220,
1100
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "532419b3-33fe-4b6d-8ec0-6db03126faa1",
"name": "解析表格 JSON",
"type": "n8n-nodes-base.code",
"position": [
20,
1100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "aa35f48c-7aee-4b57-85bc-1acaaace7324",
"name": "LLM 转换（表格）",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
240,
1100
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "0fda167e-545f-4b3d-ae86-366ca46f83c1",
"name": "构建日记账主体",
"type": "n8n-nodes-base.set",
"position": [
580,
1100
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2fbf56de-2d73-46bb-851a-174ff3eedb73",
"name": "合并表头和行",
"type": "n8n-nodes-base.merge",
"position": [
780,
960
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "2ea523f5-16b4-4fa7-96e1-d3f0fd415d8c",
"name": "发布日记账（表格）",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
980,
960
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "470caa25-52dd-424e-a000-d07ebabcb6e5",
"name": "记录成功（表格）",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
800
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "a17b7dd8-747e-4b5b-9f2f-dadd607e8b3f",
"name": "记录错误（表格）",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
1020
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "12d5eb01-d326-4b35-b922-5bb148b32fc4",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1880,
560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a621ad9e-20e1-454d-acb9-1ce7376da82c",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2230580e-5800-4dc0-96f4-276152c330f3",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
760
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "94b1309f-5a8f-479e-a82b-6dea66f4cf17",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
1320
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a7b337d9-989c-45b5-bb73-457c480ce81c",
"connections": {
"a85066bb-91fa-4e1f-bb09-d7164165b2f6": {
"main": [
[
{
"node": "a53020c0-c167-4cf1-9597-95b07d7b87cd",
"type": "main",
"index": 0
}
]
]
},
"fab58a6e-27c7-4021-9183-065d40f25e7d": {
"main": [
[
{
"node": "980fa23f-1850-4594-9e92-6aea0a6e62bb",
"type": "main",
"index": 0
},
{
"node": "2fbf56de-2d73-46bb-851a-174ff3eedb73",
"type": "main",
"index": 1
}
]
]
},
"980fa23f-1850-4594-9e92-6aea0a6e62bb": {
"main": [
[
{
"node": "d83ac837-292a-4a5c-b537-e89d3671c23c",
"type": "main",
"index": 0
}
]
]
},
"08c6fdef-b4e9-4f82-8080-7f8d06ba4336": {
"main": [
[
{
"node": "ff7679dd-811c-4b83-9e35-f61c4a6ac2b2",
"type": "main",
"index": 0
}
]
]
},
"a53020c0-c167-4cf1-9597-95b07d7b87cd": {
"main": [
[
{
"node": "08c6fdef-b4e9-4f82-8080-7f8d06ba4336",
"type": "main",
"index": 0
}
],
[
{
"node": "fab58a6e-27c7-4021-9183-065d40f25e7d",
"type": "main",
"index": 0
}
],
[
{
"node": "a9d367d5-cef4-40d8-8d13-dc0da04e424a",
"type": "main",
"index": 0
}
]
]
},
"6f3055d0-2612-49e5-8b70-ade568596658": {
"main": [
[
{
"node": "a85066bb-91fa-4e1f-bb09-d7164165b2f6",
"type": "main",
"index": 0
}
]
]
},
"532419b3-33fe-4b6d-8ec0-6db03126faa1": {
"main": [
[
{
"node": "aa35f48c-7aee-4b57-85bc-1acaaace7324",
"type": "main",
"index": 0
}
]
]
},
"d83ac837-292a-4a5c-b537-e89d3671c23c": {
"main": [
[
{
"node": "532419b3-33fe-4b6d-8ec0-6db03126faa1",
"type": "main",
"index": 0
}
]
]
},
"0fda167e-545f-4b3d-ae86-366ca46f83c1": {
"main": [
[
{
"node": "2fbf56de-2d73-46bb-851a-174ff3eedb73",
"type": "main",
"index": 0
}
]
]
},
"ff7679dd-811c-4b83-9e35-f61c4a6ac2b2": {
"main": [
[
{
"node": "838b28c5-1ccb-40bc-9e07-88569e11287f",
"type": "main",
"index": 0
}
],
[
{
"node": "1900cd98-9b64-41f7-af03-68018376e6da",
"type": "main",
"index": 0
}
]
]
},
"2fbf56de-2d73-46bb-851a-174ff3eedb73": {
"main": [
[
{
"node": "2ea523f5-16b4-4fa7-96e1-d3f0fd415d8c",
"type": "main",
"index": 0
}
]
]
},
"2ea523f5-16b4-4fa7-96e1-d3f0fd415d8c": {
"main": [
[
{
"node": "470caa25-52dd-424e-a000-d07ebabcb6e5",
"type": "main",
"index": 0
}
],
[
{
"node": "a17b7dd8-747e-4b5b-9f2f-dadd607e8b3f",
"type": "main",
"index": 0
}
]
]
},
"aa35f48c-7aee-4b57-85bc-1acaaace7324": {
"main": [
[
{
"node": "0fda167e-545f-4b3d-ae86-366ca46f83c1",
"type": "main",
"index": 0
}
]
]
},
"41f1f35e-a4b2-4510-8910-8b1742df417f": {
"main": [
[
{
"node": "2c445e36-67b3-44c1-912d-1225ab4d5077",
"type": "main",
"index": 0
}
],
[
{
"node": "42d94e4b-0a1d-482a-88bb-5397129dd29a",
"type": "main",
"index": 0
}
]
]
},
"a9d367d5-cef4-40d8-8d13-dc0da04e424a": {
"main": [
[
{
"node": "41f1f35e-a4b2-4510-8910-8b1742df417f",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 文档提取, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+
If
Set
Code
52 节点Daniel Lianes
杂项
使用VEXA、OpenAI和Mem0自动化会议智能分析
使用VEXA、OpenAI和Mem0自动化会议对话洞察分析
Set
Code
Merge
+
Set
Code
Merge
26 节点Stephan Koning
文档提取
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+
If
Set
Code
141 节点Ezema Kingsley Chibuzo
潜在客户开发
OCR Telegram - SAP
基于Telegram、GPT-4o、OCR和SAP集成的自动化发票处理
Set
Code
Wait
+
Set
Code
Wait
29 节点Raquel Giugliano
人工智能
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
If
Set
Code
+
If
Set
Code
40 节点Immanuel
人工智能
使用AI、ElevenLabs和多平台发布创建和审批POV视频
使用AI、ElevenLabs和多平台发布创建和审批POV视频（TikTok/IG/YT）
If
Set
Code
+
If
Set
Code
60 节点Immanuel
设计
