GRC模块2：风险处理自动化器
中级
这是一个SecOps, Multimodal AI领域的自动化工作流，包含 12 个节点。主要使用 If, Set, Switch, GoogleSheets, ScheduleTrigger 等节点。 使用Google Sheets为GRC合规自动化风险处理任务
前置要求
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "g7VN0vAwXSeCYhMj",
"meta": {
"info": "***SANITIZED***"
},
"name": "GRC 模块 2：风险处理自动化器",
"tags": [
{
"id": "dPs2AtBKKjBbUjMP",
"name": "Auto‑Assign & Escalate",
"createdAt": "2025-08-04T01:32:52.595Z",
"updatedAt": "2025-08-04T01:32:52.595Z"
},
{
"id": "dk5SXW31JVBCdAuz",
"name": "Dynamic Treatment Router",
"createdAt": "2025-08-04T01:32:52.582Z",
"updatedAt": "2025-08-04T01:32:52.582Z"
}
],
"nodes": [
{
"id": "594a4bd7-48b8-4ed4-b67b-7efac5cb95d8",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3328,
-48
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "107fcb79-1e86-4ec1-9ba9-d656a647ffae",
"name": "触发器 - 每日风险分配",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-2656,
208
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "4db1006f-71d8-4424-9036-c4203a9aa308",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2448,
208
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "b8daf813-d138-49f0-9c49-c627cf3dc5b4",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-2224,
208
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "1c3457c7-5176-44b3-af38-993666f5da63",
"name": "切换",
"type": "n8n-nodes-base.switch",
"position": [
-2000,
112
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "8a29f0fb-0cdc-4bc0-9086-57a09360e8c6",
"name": "准备高风险任务",
"type": "n8n-nodes-base.set",
"position": [
-1360,
-80
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "5af2c75e-96d8-4d9a-97a8-ad01b6d90821",
"name": "准备中风险任务",
"type": "n8n-nodes-base.set",
"position": [
-1360,
128
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "a9633711-dd20-4b58-b4f6-2885c761bbc1",
"name": "准备低风险任务",
"type": "n8n-nodes-base.set",
"position": [
-1360,
368
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "5a10fc7f-1128-4d0c-8d94-64955fd7e349",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-944,
-96
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "dafad726-7ce2-47f4-8d65-27fe92875e22",
"name": "追加高风险任务",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1136,
-80
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "6cd694b9-1413-4bfe-9296-3024e30e2fff",
"name": "追加中风险任务",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1136,
128
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "0b53d068-9397-4a15-a6bc-d72535f6863b",
"name": "追加低风险任务",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1136,
368
],
"parameters": {},
"typeVersion": 4.6
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "71c49668-742e-4d07-9de9-a3639ef3aa72",
"connections": {
"If": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "Prepare High Risk Task",
"type": "main",
"index": 0
}
],
[
{
"node": "Prepare Medium Risk Task",
"type": "main",
"index": 0
}
],
[
{
"node": "Prepare Low Risk Task",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Prepare Low Risk Task": {
"main": [
[
{
"node": "Append Low Risk Task",
"type": "main",
"index": 0
}
]
]
},
"Prepare High Risk Task": {
"main": [
[
{
"node": "Append High Risk Task",
"type": "main",
"index": 0
}
]
]
},
"Prepare Medium Risk Task": {
"main": [
[
{
"node": "Append Medium Risk Task",
"type": "main",
"index": 0
}
]
]
},
"Trigger – Daily Risk Assignment": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 安全运维, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
GRC - 安全问卷自动填写
自动化安全问卷回复：GPT-4o和Google Sheets
If
Set
Code
+7
11 节点Adnan Tariq
安全运维
CyberScan Github 副本
基于 Nessus、风险分级和 Google Sheets 报告的 AI 漏洞扫描器
If
Set
Code
+8
39 节点Adnan Tariq
安全运维
CYBERPULSEBlueOps_模块1 客户端副本1
自动CVE和IOC数据源摄取，含OpenAI风险评估和邮件警报
If
Code
Merge
+7
21 节点Adnan Tariq
安全运维
M6 - 仪表盘和报告
Google表格、AI风险分析和邮件警报的实时安全威胁仪表盘
If
Code
Merge
+7
21 节点Adnan Tariq
安全运维
🔴 RedOps 模块 1 – PhishForge
基于OpenAI和Google表格的内部钓鱼模拟安全培训
Set
Gmail
Webhook
+5
12 节点Adnan Tariq
安全运维
GRC模块4 - 策略生命周期跟踪器
使用Google Sheets和Gmail通知跟踪策略到期日期和负责人
If
Gmail
Google Sheets
+2
6 节点Adnan Tariq
安全运维
工作流信息
难度等级
中级
节点数量12
分类2
节点类型6
作者
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 查看 →
分享此工作流