8
n8n 中文网amn8n.com

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)可能需要您自行付费。

工作流信息
难度等级
中级
节点数量11
分类2
节点类型10
难度说明

适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

作者
Adnan Tariq

Adnan Tariq

@adnantariq

Founder 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 查看

分享此工作流