ISO 42001 控制映射模块
中级
这是一个Document Extraction, AI Summarization领域的自动化工作流,包含 13 个节点。主要使用 If, Set, Gmail, Merge, SplitOut 等节点。 使用GPT和Google表格自动进行ISO 42001合规性评估
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "hglWYkxV4GP7aiNI",
"meta": {
"instanceId": "6feff41aadeb8409737e26476f9d0a45f95eec6a9c16afff8ef87a662455b6df"
},
"name": "我的工作流 3ISO 42001 控制映射模块",
"tags": [
{
"id": "eFY1HiLXHwkR4yHB",
"name": "ISO42001_Mapper",
"createdAt": "2025-08-07T01:09:05.272Z",
"updatedAt": "2025-08-07T01:09:05.272Z"
},
{
"id": "FJsMDgZ6nDSNwM0j",
"name": "GRC",
"createdAt": "2025-08-07T01:09:05.282Z",
"updatedAt": "2025-08-07T01:09:05.282Z"
}
],
"nodes": [
{
"id": "4838b8dc-2547-4b02-82b5-8f6a2690393a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1080,
460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "44c8ea33-97ac-4126-b8dd-62da75b9d88e",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-2320,
80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0da2dfd9-924c-434d-853e-fdc6fc934740",
"name": "加载客户输入 – ISO 42001",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2080,
80
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "ac872936-ff2e-448d-8925-ea814d39f956",
"name": "静态 ISO 42001 条款",
"type": "n8n-nodes-base.set",
"position": [
-1860,
80
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "e7b1c6a5-41a1-4d90-be18-66f08f589f43",
"name": "拆分 ISO 条款",
"type": "n8n-nodes-base.splitOut",
"position": [
-1620,
80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1e39226f-c1f3-4a7a-9133-f4e42ad28742",
"name": "加载客户输入 – ISO",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1420,
240
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "4f410f67-6aae-4ca7-ac9a-86f78f261bf2",
"name": "合并条款 + 客户输入",
"type": "n8n-nodes-base.merge",
"position": [
-1240,
100
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "f20e806b-32bc-4058-8596-f6b693d1d6d6",
"name": "AI – 条款审计摘要",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-1020,
100
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "500703c7-7b4f-4607-9d78-9a236884f57e",
"name": "Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
-660,
100
],
"webhookId": "578273d2-4947-4511-ab9e-7b6762a82b03",
"parameters": {},
"executeOnce": true,
"typeVersion": 2.1
},
{
"id": "e7cce707-96ea-4927-bb22-bd8711f7b4d1",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-440,
100
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "81b7760f-7c23-43a3-b318-3f28a628a428",
"name": "检测到差距",
"type": "n8n-nodes-base.if",
"position": [
-220,
100
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "ba50a331-09be-415d-b343-2d71bc4f21fd",
"name": "发送警报 – 内部邮件",
"type": "n8n-nodes-base.gmail",
"position": [
0,
0
],
"webhookId": "7860afbd-3eb7-4689-84c0-c9bcf7e0ecd6",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "8b2fe340-c081-4a6f-8220-a93ebc2636f2",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-620,
460
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "9affd3ea-a294-40cd-931a-40e996d6c96b",
"connections": {
"Gmail": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Gap Detected": {
"main": [
[
{
"node": "Send Alert – Internal Email",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Gap Detected",
"type": "main",
"index": 0
}
]
]
},
"Split ISO Clauses": {
"main": [
[
{
"node": "Load Client Inputs – ISO ",
"type": "main",
"index": 0
},
{
"node": "Join Clauses + Client Input",
"type": "main",
"index": 0
}
]
]
},
"Static ISO 42001 Clauses": {
"main": [
[
{
"node": "Split ISO Clauses",
"type": "main",
"index": 0
}
]
]
},
"AI – Clause Audit Summary": {
"main": [
[
{
"node": "Gmail",
"type": "main",
"index": 0
}
]
]
},
"Join Clauses + Client Input": {
"main": [
[
{
"node": "AI – Clause Audit Summary",
"type": "main",
"index": 0
}
]
]
},
"Load Client Inputs – ISO ": {
"main": [
[
{
"node": "Join Clauses + Client Input",
"type": "main",
"index": 1
}
]
]
},
"Load Client Inputs – ISO 42001": {
"main": [
[
{
"node": "Static ISO 42001 Clauses",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Load Client Inputs – ISO 42001",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 文档提取, AI 摘要总结
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
审计文档自动化 – v1
通过Google Drive、Sheets和Gmail自动化合规审计文档管理
Set
Gmail
Merge
+5
9 节点Adnan Tariq
文档提取
自动化 PCI 控制评估
使用Google Sheets自动化PCI DSS控制评估与合规性跟踪
If
Set
Code
+5
19 节点Adnan Tariq
安全运维
GRC模块3:供应商风险评估器
使用 AI、Google Sheets 和邮件提醒自动化供应商风险评估
If
Set
Gmail
+4
7 节点Adnan Tariq
AI 摘要总结
工作日日志记录
AI工时表生成器 - 集成Gmail、日历和GitHub到Google表格
If
Set
Code
+11
31 节点Luka Zivkovic
个人效率
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
GRC - 安全问卷自动填写
自动化安全问卷回复:GPT-4o和Google Sheets
If
Set
Code
+7
11 节点Adnan Tariq
安全运维
工作流信息
难度等级
中级
节点数量13
分类2
节点类型9
作者
Adnan Tariq
@adnantariqFounder of CYBERPULSE AI — helping security teams and SMEs eliminate repetitive tasks through modular n8n automations. I build workflows for vulnerability triage, compliance reporting, threat intel, and Red/Blue/GRC ops. Book a session if you'd like custom automation for your use case. https://linkedin.com/in/adnan-tariq-4b2a1a47
外部链接
在 n8n.io 查看 →
分享此工作流