JSON 检查自动化
高级
这是一个Engineering、AI Summarization领域的自动化工作流，包含 16 个节点。主要使用 GoogleDrive、GoogleSheets、ManualTrigger、SplitInBatches、Agent 等节点。 使用 GPT-4 和 LangChain 验证 n8n JSON 工作流：从 Google Drive 到 Sheets
前置要求
- •Google Drive API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (16 个)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "Nhz3FZFOC8cVSIgl",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "JSON 检查自动化",
"tags": [],
"nodes": [
{
"id": "32a806b9-15a0-4b98-aef8-a0ec3d768ce5",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1184,
-128
],
"parameters": {},
"typeVersion": 1
},
{
"id": "99cbfdf5-5621-4979-acca-58c14f1efde1",
"name": "搜索文件和文件夹",
"type": "n8n-nodes-base.googleDrive",
"position": [
-960,
-128
],
"parameters": {},
"typeVersion": 3
},
{
"id": "308b5705-010c-4244-82f5-a0617d75d8ac",
"name": "下载文件",
"type": "n8n-nodes-base.googleDrive",
"position": [
-512,
-256
],
"parameters": {},
"typeVersion": 3
},
{
"id": "3c126eb6-b17f-411a-afb0-ac74c4f8a30d",
"name": "在表格中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
336,
-128
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "1bc40e03-eb40-47ff-925c-48077321fe1e",
"name": "遍历项目1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-736,
-128
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c6c78342-c519-4e31-acf7-3e075a132be2",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-64,
-256
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "fd8aed3f-d298-4b31-89f0-9a1f0a5b12ba",
"name": "Azure OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
-32,
-32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c82ab676-4ec7-429d-b661-d3b4a349f59a",
"name": "简单记忆",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
96,
-32
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "66b12c5f-34ad-4047-bceb-1d30acae61ff",
"name": "从文件提取",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-288,
-256
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a8d71076-a070-4929-9b22-52700b17582a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1072,
32
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "349d8da5-fb3d-4cdc-b8ad-351336f505fa",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1488,
-384
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0551b0be-fdae-4997-82c3-562a70e6c536",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-912,
-640
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0134bd47-ba61-4b9d-8fa1-5ea5d43b5555",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-496,
-656
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1a01740b-afb9-4ecd-bbd9-e6de203b0174",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-352,
80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "96a5132e-0d73-4ef4-8f1c-15a3e1af78a5",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-864
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ce9b62ca-8f73-4ee7-8177-949a049acc67",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
512,
-208
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "d04c1b12-e1ff-4454-b8ab-ea0b44263455",
"connections": {
"AI Agent": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Download file": {
"main": [
[
{
"node": "Extract from File",
"type": "main",
"index": 0
}
]
]
},
"Simple Memory": {
"ai_memory": [
[
{
"node": "AI Agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[],
[
{
"node": "Download file",
"type": "main",
"index": 0
}
]
]
},
"Extract from File": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Search files and folders": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Search files and folders",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Engineering、AI Summarization等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
从Google Drive生成n8n模板描述
使用Azure GPT-4从Google Drive生成模板描述
Code
Gmail
Google Drive
+9
27 节点Rahul Joshi
Content Creation
发票分类器
使用GPT-4o在Google Drive中分类和自动整理发票
Switch
Google Drive
Manual Trigger
+5
18 节点Rahul Joshi
Invoice Processing
技能矩阵提取器
使用Google Drive和GPT-4o将技能矩阵提取至Google表格
Code
Google Drive
Google Sheets
+5
17 节点Rahul Joshi
Miscellaneous
JD匹配分数
使用 Google Drive、Google Sheets 和 GPT-4o 评估简历与职位描述的匹配度
Code
Google Drive
Google Sheets
+5
37 节点Rahul Joshi
HR
使用GPT-4从Figma设计生成QA测试用例到Google Sheets
使用GPT-4o-mini从Figma设计生成QA测试用例到Google Sheets
Code
Http Request
Google Sheets
+6
14 节点Rahul Joshi
Engineering
反馈保存和报告生成
使用Azure OpenAI和Google Sheets分析销售交易结果并生成报告
Set
Code
Email Send
+6
28 节点Rahul Joshi
CRM
工作流信息
难度等级
高级
节点数量16
分类2
节点类型9
作者
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
外部链接
在 n8n.io 上查看 →
分享此工作流