{
  "name": "Track CVE vulnerability details & history with NVD API and Google Sheets",
  "nodes": [
    {
      "id": "b8e39932-0733-465a-a784-469d36374754",
      "name": "Webhook: Get CVE Details",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -260,
        -160
      ]
    },
    {
      "id": "844af868-d326-4d73-85b8-00de22f2e5ca",
      "name": "Fetch CVE from NVD API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -40,
        -160
      ]
    },
    {
      "id": "3ab38c76-33df-44a1-987b-0f668028c4f7",
      "name": "Parse CVE JSON → Flat Format",
      "type": "n8n-nodes-base.code",
      "position": [
        180,
        -160
      ]
    },
    {
      "id": "f96c4bcb-b24e-4e19-9c59-6ed733d0f98b",
      "name": "Log CVE Metadata to Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        400,
        -160
      ]
    },
    {
      "id": "11bb7c7e-c7e8-4d1f-98c9-c36d59b9b928",
      "name": "Webhook: Get CVE Change History",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -260,
        260
      ]
    },
    {
      "id": "ac9e845b-4905-43d1-971b-9c93c3ef8f9e",
      "name": "Fetch CVE History from NVD API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -40,
        260
      ]
    },
    {
      "id": "8a78a501-352d-4e4a-9ff1-3752e7723d65",
      "name": "Parse CVE History JSON → Flat Format",
      "type": "n8n-nodes-base.code",
      "position": [
        180,
        260
      ]
    },
    {
      "id": "885c9eae-cab8-40ba-8eac-2e920370651f",
      "name": "Log CVE History to Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        400,
        260
      ]
    },
    {
      "id": "8d8f4db1-f5fd-499c-ace5-eec99ecb6b9e",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -380,
        -340
      ],
      "parameters": {
        "width": 1000,
        "height": 360,
        "content": "## 🔍 Lookup CVE vulnerability metadata from NVD and sync to Google Sheet"
      }
    },
    {
      "id": "854a2420-e22f-4630-8b97-bd1e8f484158",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -380,
        100
      ],
      "parameters": {
        "width": 1000,
        "height": 360,
        "content": "## 🕓 Track change history for CVEs via NVD and log each update"
      }
    },
    {
      "id": "71f9bf5e-5ccd-4752-a583-6f751071b239",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1140,
        -340
      ],
      "parameters": {
        "width": 740,
        "height": 800,
        "content": "# NVD (National Vulnerability Database)\n\n## Setup\n\n- Import this workflow into your n8n instance.\n\n- Set up the following credentials:\n\n-- Google Sheets OAuth2\n\n-- NVD API Key (via HTTP Header Auth)\n\n"
      }
    },
    {
      "id": "16151bff-6c9d-441e-9ee5-5c73a2d3135a",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        -260
      ],
      "parameters": {
        "width": 150,
        "height": 80,
        "content": "NVD API Key (via HTTP Header Auth) ⬇️"
      }
    },
    {
      "id": "05222357-d84d-4615-9bfd-635ddc7c68b7",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        160
      ],
      "parameters": {
        "width": 150,
        "height": 80,
        "content": "NVD API Key (via HTTP Header Auth) ⬇️"
      }
    }
  ],
  "connections": {
    "Fetch CVE from NVD API": {
      "main": [
        [
          {
            "node": "Parse CVE JSON → Flat Format",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook: Get CVE Details": {
      "main": [
        [
          {
            "node": "Fetch CVE from NVD API",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch CVE History from NVD API": {
      "main": [
        [
          {
            "node": "Parse CVE History JSON → Flat Format",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse CVE JSON → Flat Format": {
      "main": [
        [
          {
            "node": "Log CVE Metadata to Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook: Get CVE Change History": {
      "main": [
        [
          {
            "node": "Fetch CVE History from NVD API",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse CVE History JSON → Flat Format": {
      "main": [
        [
          {
            "node": "Log CVE History to Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}