🔴 RedOps 模块 6 - 自动报告

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

{
  "id": "Pk4Ou8ITce0vjJHj",
  "meta": {
    "instanceId": "6feff41aadeb8409737e26476f9d0a45f95eec6a9c16afff8ef87a662455b6df"
  },
  "name": "🔴 RedOps 模块 6 - 自动报告",
  "tags": [
    {
      "id": "uNqHAlvBtMsP4gFd",
      "name": "Pro",
      "createdAt": "2025-07-07T09:34:20.437Z",
      "updatedAt": "2025-07-07T09:34:20.437Z"
    }
  ],
  "nodes": [
    {
      "id": "89a7108d-7f35-427b-9e0a-b188fdd22a06",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "dfe20b6f-cf49-4c46-b597-a5903510ab6b",
      "name": "🕒 触发自动报告",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1840,
        40
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "059c0784-4981-480d-977e-314f6c27ee03",
      "name": "📄 读取 Trap 日志表",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1620,
        40
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "5187baa9-a247-4dea-96b7-e7d49b62c246",
      "name": "📊 格式化报告数据",
      "type": "n8n-nodes-base.code",
      "position": [
        -1400,
        40
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "053fb8f2-5e90-458c-9cd1-59cb96e27572",
      "name": "📑 构建 HTML 报告摘要",
      "type": "n8n-nodes-base.code",
      "position": [
        -1180,
        40
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "aec2f987-c61a-459e-82ee-b439af67b9bb",
      "name": "📧 发送摘要邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -960,
        40
      ],
      "webhookId": "64e24252-6bea-459a-8051-9852ae8a3e27",
      "parameters": {},
      "typeVersion": 2.1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "fb18e6b4-0a37-453b-a24d-e36437e2b41c",
  "connections": {
    "📊 Format Report Data": {
      "main": [
        [
          {
            "node": "📑 Build HTML Report Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🕒 Trigger AutoReport": {
      "main": [
        [
          {
            "node": "📄 Read Trap Log Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📄 Read Trap Log Sheet": {
      "main": [
        [
          {
            "node": "📊 Format Report Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📑 Build HTML Report Summary": {
      "main": [
        [
          {
            "node": "📧 Send Summary Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}