自动化 PCI 控制评估
高级
这是一个SecOps, AI Summarization领域的自动化工作流，包含 19 个节点。主要使用 If, Set, Code, Merge, Filter 等节点。 使用Google Sheets自动化PCI DSS控制评估与合规性跟踪
前置要求
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "ftH5uN0C12ktrAmA",
"meta": {
"instanceId": "6feff41aadeb8409737e26476f9d0a45f95eec6a9c16afff8ef87a662455b6df"
},
"name": "自动化 PCI 控制评估",
"tags": [
{
"id": "4m3yfV7OSc6yJuDw",
"name": "PCI_Match_Status_Tracker",
"createdAt": "2025-08-07T00:41:58.364Z",
"updatedAt": "2025-08-07T00:41:58.364Z"
}
],
"nodes": [
{
"id": "bd48c9b2-e059-4864-a79a-35d526f892ec",
"name": "当点击“执行工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-320,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c971eaf5-e60e-4b8b-9435-2fb4d672a971",
"name": "客户_PCI_响应",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
220
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "2df78789-a56d-460f-8000-9c695fd08067",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
660,
120
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "3ac86d72-1172-431f-9ac9-a0423bb530c8",
"name": "控制项",
"type": "n8n-nodes-base.code",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d75dd12c-fd95-47bd-ac78-55caea2b45b1",
"name": "标准化客户 ID",
"type": "n8n-nodes-base.set",
"position": [
180,
220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "4354b8ff-a259-46e2-812b-7b113fb29dcf",
"name": "重命名官方 ID",
"type": "n8n-nodes-base.set",
"position": [
380,
0
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2bb57423-8d88-4d13-a0f4-4199aa13775d",
"name": "重命名客户 ID",
"type": "n8n-nodes-base.set",
"position": [
380,
220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "deb343b2-bba1-45f9-9c88-29e0d34a780f",
"name": "标准化控制 ID（控制项）",
"type": "n8n-nodes-base.set",
"position": [
180,
0
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "31908eb4-7335-489d-8546-2648d79e082e",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
900,
120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e412d4e9-d0ac-4841-ac0d-abd2eddbd143",
"name": "筛选",
"type": "n8n-nodes-base.filter",
"position": [
1120,
120
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "21142a4f-b2e8-4035-a8a5-dfd7676a0904",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
1360,
120
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f9943119-94a6-4929-880b-7ad5c3391e9d",
"name": "编辑字段1",
"type": "n8n-nodes-base.set",
"position": [
1660,
40
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "b1ddb48f-843b-43f5-bdf6-7e76ae9c522b",
"name": "编辑字段2",
"type": "n8n-nodes-base.set",
"position": [
1660,
260
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "ce1915b9-d68a-4239-8043-6b812d85b3ad",
"name": "合并1",
"type": "n8n-nodes-base.merge",
"position": [
1960,
140
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "c27bbd0b-b008-4151-94c0-41d5a5ec57c1",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
2180,
140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "78ee0bb7-0707-42ef-93c0-23af232ed5ef",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2760,
140
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "0916ba4d-45e4-485e-b8e5-7bbab2b9eb9a",
"name": "按客户分组",
"type": "n8n-nodes-base.code",
"position": [
2380,
140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "51c05cbf-e8c9-4dc6-b721-07794f6716e0",
"name": "匹配每个客户的状态计数",
"type": "n8n-nodes-base.code",
"position": [
2560,
140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "81ecd957-d2b6-43ff-a258-a231f65f4ab6",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
500
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "e128a0ef-dde7-4510-ab27-025420089d73",
"connections": {
"If": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Group By Client",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Merge1": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"controls": {
"main": [
[
{
"node": "Normalize Control ID (controls)",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 1
}
]
]
},
"Group By Client": {
"main": [
[
{
"node": "Match Status Count Per Client",
"type": "main",
"index": 0
}
]
]
},
"Rename Client ID": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Rename Official ID": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Normalize Client ID": {
"main": [
[
{
"node": "Rename Client ID",
"type": "main",
"index": 0
}
]
]
},
"Client_PCI_Responses": {
"main": [
[
{
"node": "Normalize Client ID",
"type": "main",
"index": 0
}
]
]
},
"Match Status Count Per Client": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Normalize Control ID (controls)": {
"main": [
[
{
"node": "Rename Official ID",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Client_PCI_Responses",
"type": "main",
"index": 0
},
{
"node": "controls",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 安全运维, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
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
安全运维
GRC - 安全问卷自动填写
自动化安全问卷回复：GPT-4o和Google Sheets
If
Set
Code
+7
11 节点Adnan Tariq
安全运维
ISO 42001 控制映射模块
使用GPT和Google表格自动进行ISO 42001合规性评估
If
Set
Gmail
+6
13 节点Adnan Tariq
文档提取
01 使用AI媒体买家分析Facebook广告表现并将洞察发送到Google Sheets
使用Gemini AI分析Facebook广告并将洞察发送到Google Sheets
If
Set
Code
+13
34 节点JJ Tham
市场调研
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
工作流信息
难度等级
高级
节点数量19
分类2
节点类型8
作者
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 查看 →
分享此工作流