{
  "name": "Aggregate endpoint security risk scores with EDR, vulnerability data & Google Sheets",
  "nodes": [
    {
      "id": "14fe3db0-79b1-48f7-b511-cf9673606a8d",
      "name": "⏰ Cron Trigger – Daily",
      "type": "n8n-nodes-base.cron",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "6bc84d47-2c24-4f8e-ac67-bd0791073866",
      "name": "🛡 Get EDR Logs",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        220,
        0
      ]
    },
    {
      "id": "47589ec4-9d8f-48b6-aa02-8cb9ec2bf26c",
      "name": "🗃 Get File Integrity Logs",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        220,
        400
      ]
    },
    {
      "id": "68d90599-7f4e-43dd-b603-0a62228adb3a",
      "name": "🧬 Get Vulnerability Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        220,
        200
      ]
    },
    {
      "id": "80f9847c-87fc-4e22-a2c5-8bec50b9be91",
      "name": "🔀 Merge Endpoint Signals",
      "type": "n8n-nodes-base.merge",
      "position": [
        420,
        140
      ]
    },
    {
      "id": "e4a1d4c4-f9cb-48e4-8532-0d15a76860f0",
      "name": "🔀 Merge + FIM Logs",
      "type": "n8n-nodes-base.merge",
      "position": [
        420,
        360
      ]
    },
    {
      "id": "ecf40cba-8067-428b-a780-d7e56d7397c1",
      "name": "🧠 Risk Score Calculator",
      "type": "n8n-nodes-base.function",
      "position": [
        220,
        580
      ]
    },
    {
      "id": "dae4094a-6907-4183-ba11-8c433d4c1356",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        420,
        580
      ]
    },
    {
      "id": "767a6b21-e2a6-4c16-ba73-ee40d4c91770",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        220
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    }
  ],
  "connections": {
    "🛡 Get EDR Logs": {
      "main": [
        [
          {
            "node": "🔀 Merge Endpoint Signals",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔀 Merge + FIM Logs": {
      "main": [
        [
          {
            "node": "🧠 Risk Score Calculator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "⏰ Cron Trigger – Daily": {
      "main": [
        [
          {
            "node": "🛡 Get EDR Logs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧠 Risk Score Calculator": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔀 Merge Endpoint Signals": {
      "main": [
        [
          {
            "node": "🔀 Merge + FIM Logs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧬 Get Vulnerability Data": {
      "main": [
        [
          {
            "node": "🔀 Merge Endpoint Signals",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "🗃 Get File Integrity Logs": {
      "main": [
        [
          {
            "node": "🔀 Merge + FIM Logs",
            "type": "main",
            "index": 1
          }
        ]
      ]
    }
  }
}