GRC - 安全问卷自动填写
中级
这是一个SecOps, Multimodal AI领域的自动化工作流,包含 11 个节点。主要使用 If, Set, Code, Gmail, Merge 等节点。 自动化安全问卷回复:GPT-4o和Google Sheets
前置要求
- •Google 账号和 Gmail API 凭证
- •HTTP Webhook 端点(n8n 会自动生成)
- •Google Drive API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "suFwbFh7NOckUGrH",
"meta": {
"instanceId": "6feff41aadeb8409737e26476f9d0a45f95eec6a9c16afff8ef87a662455b6df"
},
"name": "GRC - 安全问卷自动填写",
"tags": [
{
"id": "gJSr5qMwZv8VikrA",
"name": "Compliance Responder",
"createdAt": "2025-08-04T01:27:51.485Z",
"updatedAt": "2025-08-04T01:27:51.485Z"
}
],
"nodes": [
{
"id": "123b4768-29e6-44e4-b5f8-4efd7755fc7e",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-1640,
180
],
"webhookId": "a134d3f5-179d-4a44-a6b3-74844d04ae25",
"parameters": {},
"typeVersion": 2
},
{
"id": "ee0965d6-0cdc-46f6-a82a-0aa3396ac0e8",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1240,
180
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "2eba0fe8-b3f5-4a3d-a5e3-00d70a16b447",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
-720,
120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "73a3e582-d02d-4d00-b147-1eea18665d9f",
"name": "OpenAI",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-480,
120
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "12d1abd5-7826-4235-b792-a4c0ba6ffae6",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "1e27c1f2-bf19-48ae-a4f3-3b0f6bccce32",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-1020,
180
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "39b53f5e-87a6-4178-be48-31bb27efe926",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
0,
260
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "1c1e83ed-eadd-4cce-83be-e79d58a88623",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
440,
140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "66271d78-bca4-4b47-ae70-5ccb58fac9ac",
"name": "Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
660,
140
],
"webhookId": "985a1edf-4cec-4ab8-8ebb-8e1ffa581f4b",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "d555c006-215b-4bab-8bde-7df72b35767e",
"name": "Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
-1440,
180
],
"parameters": {},
"typeVersion": 3
},
{
"id": "7c882edd-18c8-4300-b05f-ece5ae3fdf89",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
460
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "b6f97c2b-05fc-4e73-b054-7c75d8255e39",
"connections": {
"If": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Gmail",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"OpenAI": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Google Drive",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "OpenAI",
"type": "main",
"index": 0
}
]
]
},
"Google Drive": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 安全运维, 多模态 AI
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
自动化潜在客户捕获、AI资质鉴定及ElevenLabs个性化语音跟进
基于 OpenAI 和 ElevenLabs 的自动化线索捕获与 AI 个性化语音跟进
If
Set
Code
+10
22 节点Marth
客户培育
GRC模块3:供应商风险评估器
使用 AI、Google Sheets 和邮件提醒自动化供应商风险评估
If
Set
Gmail
+4
7 节点Adnan Tariq
AI 摘要总结
会议纪要和行动项跟踪器
基于AI的会议纪要:使用GPT-4、任务分配和多渠道分发
If
Set
Code
+10
38 节点Jitesh Dugar
内容创作
🔴 RedOps 模块 1 – PhishForge
基于OpenAI和Google表格的内部钓鱼模拟安全培训
Set
Gmail
Webhook
+5
12 节点Adnan Tariq
安全运维
🔴 RedOps模块2 – Payload_Validator
使用GPT-4生成的有效载荷和Google表格验证邮件安全网关
Set
Merge
Google Sheets
+3
9 节点Adnan Tariq
安全运维
自动化 PCI 控制评估
使用Google Sheets自动化PCI DSS控制评估与合规性跟踪
If
Set
Code
+5
19 节点Adnan Tariq
安全运维
工作流信息
难度等级
中级
节点数量11
分类2
节点类型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 查看 →
分享此工作流