M6 - 仪表盘和报告
高级
这是一个SecOps领域的自动化工作流，包含 21 个节点。主要使用 If, Code, Merge, Switch, SplitOut 等节点。 Google表格、AI风险分析和邮件警报的实时安全威胁仪表盘
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "ncKIMRjTLjshxhIv",
"meta": {
"instanceId": "6feff41aadeb8409737e26476f9d0a45f95eec6a9c16afff8ef87a662455b6df"
},
"name": "M6 - 仪表盘和报告",
"tags": [],
"nodes": [
{
"id": "d60a2fa1-a16e-4505-986c-388c37d3abbb",
"name": "⏰ Cron - 每日触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-460,
120
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "30808a33-e169-43a0-b8f5-6a758a0bda50",
"name": "🌐 获取CVE订阅源",
"type": "n8n-nodes-base.httpRequest",
"position": [
-220,
40
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "346452c0-c245-4434-8608-a38a738cd5ce",
"name": "🛡️ 获取IOC订阅源",
"type": "n8n-nodes-base.httpRequest",
"position": [
-220,
200
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "ffd4627e-d9e9-42f9-b55d-ad61201de651",
"name": "🧠 合并威胁数据",
"type": "n8n-nodes-base.merge",
"position": [
-20,
120
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "fc00545f-b079-4d74-b050-481d3a92a924",
"name": "🧠 整合威胁数据",
"type": "n8n-nodes-base.code",
"position": [
-20,
320
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7d7bb345-39c1-4104-a096-6c58409d67b4",
"name": "🧠 AI - 风险评估",
"type": "n8n-nodes-base.code",
"position": [
-20,
500
],
"parameters": {},
"typeVersion": 2
},
{
"id": "22f90241-1d2e-4b1d-aecf-57fd9b412dfd",
"name": "🧠 AI - 漏洞分类",
"type": "n8n-nodes-base.code",
"position": [
-20,
680
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7aabda51-2acd-467a-885e-39b522e2ce08",
"name": "🚨 警报 - LEV触发器",
"type": "n8n-nodes-base.if",
"position": [
-20,
880
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "85bba1fd-f169-421e-b934-47343b1624d6",
"name": "📧 发送警报邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
180,
820
],
"webhookId": "48963cc6-c85f-4946-92bd-2c91a1a255ef",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "123906b3-ece6-4c4c-be90-000db891b453",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
180,
980
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "795d9741-27f5-4507-94e9-04f450cc7d60",
"name": "🧠 AI - 事件预案选择器",
"type": "n8n-nodes-base.code",
"position": [
420,
500
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ae7a94c3-892f-493b-97de-cb3de458b20e",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
600,
500
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e0cd40a8-3b3e-40ef-8a54-ec6ffc447f6d",
"name": "🧭 响应路由器",
"type": "n8n-nodes-base.switch",
"position": [
780,
500
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "b5a688b5-e45e-4a69-a7a6-31bd371a8524",
"name": "发送警报邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
1100,
320
],
"webhookId": "decb9f47-14ee-49f7-9317-2d52a39f97bd",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "ec598d42-3ae3-4e40-b06a-f9dce667f478",
"name": "提取网站信息",
"type": "n8n-nodes-base.googleSheets",
"position": [
1100,
500
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "8b17c379-c2cb-4db9-9238-bf2cf9c30abe",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
1100,
680
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "819baad2-2f09-4990-824f-9dcb7c777546",
"name": "分离输出",
"type": "n8n-nodes-base.splitOut",
"position": [
260,
500
],
"parameters": {},
"typeVersion": 1
},
{
"id": "14f595f0-051b-48c1-9960-e98b232b9f1a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
1360,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "646f962f-df67-4f33-bf14-9009a806d11a",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1940,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "988221b8-3143-4f9c-a403-55b25e5d116a",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1940,
1000
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a1c88a89-8aff-411c-af0c-f949632436d0",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1940,
1200
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "f78b0e4e-fc09-4dd8-bcfa-9bf1db0eb2dd",
"connections": {
"Code": {
"main": [
[
{
"node": "🧭 Response Router",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "🧠 AI – Incident Playbook Selector",
"type": "main",
"index": 0
}
]
]
},
"🌐 Get CVE Feed": {
"main": [
[
{
"node": "🧠 Merge Threat Data",
"type": "main",
"index": 0
}
]
]
},
"🛡️ Get IOC Feed": {
"main": [
[
{
"node": "🧠 Merge Threat Data",
"type": "main",
"index": 1
}
]
]
},
"🧭 Response Router": {
"main": [
[
{
"node": "Send Alert Email",
"type": "main",
"index": 0
}
],
[
{
"node": "Log to Google Sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"🧠 Merge Threat Data": {
"main": [
[
{
"node": "🧠Combine Threat Data",
"type": "main",
"index": 0
}
]
]
},
"🧠Combine Threat Data": {
"main": [
[
{
"node": "🧠 AI – Risk Evaluation",
"type": "main",
"index": 0
}
]
]
},
"⏰ Cron – Daily Trigger": {
"main": [
[
{
"node": "🌐 Get CVE Feed",
"type": "main",
"index": 0
},
{
"node": "🛡️ Get IOC Feed",
"type": "main",
"index": 0
}
]
]
},
"🚨 ALERT – LEV Trigger": {
"main": [
[
{
"node": "📧 Send Alert Email",
"type": "main",
"index": 0
},
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"🧠 AI – Risk Evaluation": {
"main": [
[
{
"node": "🧠 AI – Triage Vulnerabilities",
"type": "main",
"index": 0
},
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"🧠 AI – Triage Vulnerabilities": {
"main": [
[
{
"node": "🚨 ALERT – LEV Trigger",
"type": "main",
"index": 0
}
]
]
},
"🧠 AI – Incident Playbook Selector": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 安全运维
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
CYBERPULSEBlueOps_模块1 客户端副本1
自动CVE和IOC数据源摄取，含OpenAI风险评估和邮件警报
If
Code
Merge
+7
21 节点Adnan Tariq
安全运维
CyberScan Github 副本
基于 Nessus、风险分级和 Google Sheets 报告的 AI 漏洞扫描器
If
Set
Code
+8
39 节点Adnan Tariq
安全运维
M5 - 自动回复器
自动化安全事件响应：Google Sheets、邮件警报和EDR隔离
If
Aggregate
Email Send
+4
8 节点Adnan Tariq
安全运维
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
自动化 PCI 控制评估
使用Google Sheets自动化PCI DSS控制评估与合规性跟踪
If
Set
Code
+5
19 节点Adnan Tariq
安全运维
GRC模块2：风险处理自动化器
使用Google Sheets为GRC合规自动化风险处理任务
If
Set
Switch
+3
12 节点Adnan Tariq
安全运维
工作流信息
难度等级
高级
节点数量21
分类1
节点类型10
作者
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 查看 →
分享此工作流