M2 - 资产丰富引擎

• •Google Sheets API 凭证

{
  "id": "FulCIypj42nIklCO",
  "meta": {
    "instanceId": "6feff41aadeb8409737e26476f9d0a45f95eec6a9c16afff8ef87a662455b6df"
  },
  "name": "M2 - 资产丰富引擎",
  "tags": [],
  "nodes": [
    {
      "id": "14a7268a-be41-4a5a-a5cb-9727b1f6d814",
      "name": "合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        100,
        240
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "5baea5d2-c41f-4eb1-868a-2307e2b931c2",
      "name": "🔁 每日触发器",
      "type": "n8n-nodes-base.cron",
      "position": [
        -420,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "dabf2c97-d177-4cda-9103-df589a0f3e66",
      "name": "🧠匹配威胁到资产",
      "type": "n8n-nodes-base.function",
      "position": [
        320,
        240
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "e370d6aa-be47-47a3-8a58-186dc5db4d6c",
      "name": "📊 添加新威胁",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        560,
        240
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "a1e771b7-6f18-4b7e-a1bb-49139dee5c75",
      "name": "📊 删除行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        560,
        420
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "621cf885-f05e-4fc3-9189-bfffe9a4f547",
      "name": "📬发送摘要邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        560,
        80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "700a7223-bfde-4a69-bbb4-e94999bcf444",
      "name": "🗃️ 已归档威胁",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        740,
        240
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "a468d0cf-47c8-4604-8500-3ee66620f218",
      "name": "📊威胁表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -200,
        160
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "fbe3a884-9151-44ca-92d4-7e44593f6c48",
      "name": "📊加载资产数据库",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -200,
        360
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a585c636-aec5-4b50-8f1c-68ad28b67ffa",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "1b243f06-2e22-46c7-a269-65b35fe3cbd4",
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "🧠Match Threats to Assets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📊Load Asset DB": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "📊Threats Sheets": {
      "main": [
        [
          {
            "node": "📊Load Asset DB",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔁 Daily Trigger": {
      "main": [
        [
          {
            "node": "📊Threats Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📊 Apend New Threat": {
      "main": [
        [
          {
            "node": "🗃️  Archived_Threats",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧠Match Threats to Assets": {
      "main": [
        [
          {
            "node": "📬Send Summary Email",
            "type": "main",
            "index": 0
          },
          {
            "node": "📊 Apend New Threat",
            "type": "main",
            "index": 0
          },
          {
            "node": "📊 Delete Row",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}