审计文档自动化 – v1

• •Google 账号和 Gmail API 凭证
• •Google Drive API 凭证
• •Google Sheets API 凭证

{
  "id": "KPUhmGUm3HsZ9NKu",
  "meta": {
    "instanceId": "6feff41aadeb8409737e26476f9d0a45f95eec6a9c16afff8ef87a662455b6df"
  },
  "name": "审计文档自动化 – v1",
  "tags": [],
  "nodes": [
    {
      "id": "dadbd689-4e8f-4fa5-8522-105d572593d7",
      "name": "当点击“执行工作流”时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a13bc01c-d0f6-456e-8947-1f3a737bb856",
      "name": "加载审计日志",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        220,
        0
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "dd24ad69-9614-4fca-a86b-1252a66a2dbf",
      "name": "获取证据文件",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        460,
        200
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "e1e94897-d0cd-4618-9ae3-b3aaec9ac9fb",
      "name": "合并日志+文件",
      "type": "n8n-nodes-base.merge",
      "position": [
        1040,
        20
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "afe9af73-d873-461f-81f0-c7e46d398f7d",
      "name": "添加控制ID到文件",
      "type": "n8n-nodes-base.set",
      "position": [
        700,
        200
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "075e1947-d1bf-48b1-84a2-c7f73488e3a6",
      "name": "下载证据文件",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1260,
        20
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "719d6943-73f4-40bb-b7de-8d49ca940d8b",
      "name": "压缩文件",
      "type": "n8n-nodes-base.compression",
      "position": [
        1480,
        20
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "9ae3ab6f-6ad7-44c5-ac60-5c4a3b7974ae",
      "name": "发送证据邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1660,
        20
      ],
      "webhookId": "fee93921-e756-413d-b56e-fe5730fd2e38",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "e733b2be-e4a7-4185-9dbc-44ebb480f8b6",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        440
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "332b6ac2-9d99-4dc2-bc67-9d93787e0a2d",
  "connections": {
    "Zip Files": {
      "main": [
        [
          {
            "node": "Send Evidence Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Load Audit Logs": {
      "main": [
        [
          {
            "node": "Fetch Evidence Files",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge Logs + Files",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Logs + Files": {
      "main": [
        [
          {
            "node": "Download Evidence File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Evidence Files": {
      "main": [
        [
          {
            "node": "Add control_id to File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add control_id to File": {
      "main": [
        [
          {
            "node": "Merge Logs + Files",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Download Evidence File": {
      "main": [
        [
          {
            "node": "Zip Files",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Load Audit Logs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}