{
  "name": "Cybersecurity Intelligence: Create Daily Digest & Viral Topics with Gemini AI",
  "nodes": [
    {
      "id": "a1053544-7fdf-42ba-aa8f-788726bec223",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1104,
        2512
      ]
    },
    {
      "id": "36642d68-97f9-48cb-9b85-39f3ca9c5b13",
      "name": "Process output into HTML",
      "type": "n8n-nodes-base.code",
      "position": [
        1376,
        2384
      ]
    },
    {
      "id": "e5a060a2-7d9c-4361-a6e4-54b4ea5f8c02",
      "name": "Baserow Push Data",
      "type": "n8n-nodes-base.baserow",
      "position": [
        1376,
        2192
      ]
    },
    {
      "id": "5fb2aedf-d957-44e3-93c6-54779bb813c3",
      "name": "Filter summaries and created date",
      "type": "n8n-nodes-base.set",
      "position": [
        2048,
        2192
      ]
    },
    {
      "id": "f5b9d10b-0555-42a8-be10-b229b69467a1",
      "name": "Get data of previous days",
      "type": "n8n-nodes-base.baserow",
      "position": [
        1824,
        2192
      ]
    },
    {
      "id": "2ddd6974-8b50-4d2f-8a08-c303fc87a15a",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        2512,
        2416
      ]
    },
    {
      "id": "534e2327-26ce-491a-9acb-b885b8524c26",
      "name": "Flatten",
      "type": "n8n-nodes-base.code",
      "position": [
        2272,
        2192
      ]
    },
    {
      "id": "128fab04-8f6f-4d3b-814f-13942994a89f",
      "name": "Process output into HTML1",
      "type": "n8n-nodes-base.code",
      "position": [
        2848,
        2096
      ]
    },
    {
      "id": "3e9d7228-27c5-46ca-98f8-eacf707b9704",
      "name": "Baserow Push Data1",
      "type": "n8n-nodes-base.baserow",
      "position": [
        2848,
        2288
      ]
    },
    {
      "id": "96165d72-d656-4e6c-9984-9ebf74c633e7",
      "name": "Daily trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        80,
        2256
      ]
    },
    {
      "id": "4df5872b-ffe1-44d4-9f34-d0d54364e484",
      "name": "Write basic digest for today",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1024,
        2288
      ]
    },
    {
      "id": "dc92b836-b2b8-4d83-ab35-3007203b7de6",
      "name": "Send daily digest email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1600,
        2384
      ]
    },
    {
      "id": "233ddaf2-70e7-4c05-aca0-9d1c070e533d",
      "name": "Send viral topics email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        3072,
        2096
      ]
    },
    {
      "id": "35da285a-2abb-4b5a-ba7e-047798202150",
      "name": "Structured Output Parser1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        2640,
        2416
      ]
    },
    {
      "id": "847aa33a-95fc-47b7-93b7-39ec0eab3df9",
      "name": "Identify viral topics and write digest",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        2496,
        2192
      ]
    },
    {
      "id": "403b07f0-b37c-4d1c-a197-5c0e15a55478",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        1296
      ],
      "parameters": {
        "width": 416,
        "height": 2064,
        "content": "# Collection\n## Ingest intelligence from RSS feeds, every morning on 7am."
      }
    },
    {
      "id": "0a7109a1-c9ca-4b85-9755-b4f99dc9cccd",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        528,
        1296
      ],
      "parameters": {
        "width": 416,
        "height": 2064,
        "content": "# Processing\n## Process the ingested data for further analysis by merging it into a single data block. Filter articles older than 24h and irrelevant fields."
      }
    },
    {
      "id": "8b3ed565-27ad-4dfa-8630-ec188f01f3a9",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        1296
      ],
      "parameters": {
        "width": 320,
        "height": 2064,
        "content": "# Analysis\n## Leverage AI to deduplicate, organize, and summarize the information for a daily digest email."
      }
    },
    {
      "id": "85e5a8b7-26b0-4907-8965-724e9a191c81",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2448,
        1296
      ],
      "parameters": {
        "width": 320,
        "height": 2064,
        "content": "# Analysis\n## Leverage AI to identity viral topics in reporting from the previous week and organize it into a viral topics threat brief."
      }
    },
    {
      "id": "cc122ef6-13eb-4e86-8259-ecb1b1aa9368",
      "name": "7 days ago date",
      "type": "n8n-nodes-base.code",
      "position": [
        1600,
        2192
      ]
    },
    {
      "id": "caa6b20c-8b55-4af8-88c3-b46c3eacbb77",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1328,
        2352
      ],
      "parameters": {
        "width": 416,
        "height": 1008,
        "content": "\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n# Dissemination\n## Disseminate the report over email."
      }
    },
    {
      "id": "8b43c80c-61e4-4b19-b319-320b5e4c1ec3",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1328,
        1296
      ],
      "parameters": {
        "width": 1088,
        "height": 1024,
        "content": "# Processing\n## Save the output in a database and collect the data of the last 7 days for viral topic identification. Filter out only the needed data and flatten the array for better AI consumption."
      }
    },
    {
      "id": "53a79424-2145-4e7b-920d-2acd42ad2827",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2800,
        1296
      ],
      "parameters": {
        "width": 416,
        "height": 2064,
        "content": "# Dissemination\n## Disseminate the report over email and save it in a database for future usage."
      }
    },
    {
      "id": "d0f4ecbd-5823-49dc-90f8-a90f092f63c4",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -592,
        1296
      ],
      "parameters": {
        "width": 640,
        "height": 1120,
        "content": "# AI Threat Intelligence: Compose Daily Digest & Viral Topics Reports \n## Process cybersecurity reports into an AI-generated daily threat intelligence digest and viral topic report.\nThis n8n workflow "
      }
    },
    {
      "id": "75fccadd-fb48-4d3c-9d8a-0332ed143572",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        320,
        2464
      ]
    },
    {
      "id": "21b5a74b-e7fa-4970-a1cb-227e0a924a77",
      "name": "RSS Read",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        320,
        2608
      ]
    },
    {
      "id": "85630d43-4f0f-4d06-a154-aac3f6ce8c39",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        592,
        2256
      ]
    },
    {
      "id": "f8df553c-e0b5-4fec-be82-113452d99616",
      "name": "RSS feeds",
      "type": "n8n-nodes-base.code",
      "position": [
        272,
        2256
      ]
    },
    {
      "id": "c71a7512-e1e0-4080-adc6-3b7eb2cae0f9",
      "name": "Precook data",
      "type": "n8n-nodes-base.code",
      "position": [
        800,
        2256
      ]
    }
  ],
  "connections": {
    "Flatten": {
      "main": [
        [
          {
            "node": "Identify viral topics and write digest",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "RSS Read": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "Precook data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "RSS feeds": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Precook data": {
      "main": [
        [
          {
            "node": "Write basic digest for today",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily trigger": {
      "main": [
        [
          {
            "node": "RSS feeds",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7 days ago date": {
      "main": [
        [
          {
            "node": "Get data of previous days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "RSS Read",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Baserow Push Data": {
      "main": [
        [
          {
            "node": "7 days ago date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send daily digest email": {
      "main": [
        []
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Identify viral topics and write digest",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Write basic digest for today",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Process output into HTML": {
      "main": [
        [
          {
            "node": "Send daily digest email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Write basic digest for today",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Get data of previous days": {
      "main": [
        [
          {
            "node": "Filter summaries and created date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process output into HTML1": {
      "main": [
        [
          {
            "node": "Send viral topics email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser1": {
      "ai_outputParser": [
        [
          {
            "node": "Identify viral topics and write digest",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Write basic digest for today": {
      "main": [
        [
          {
            "node": "Process output into HTML",
            "type": "main",
            "index": 0
          },
          {
            "node": "Baserow Push Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter summaries and created date": {
      "main": [
        [
          {
            "node": "Flatten",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Identify viral topics and write digest": {
      "main": [
        [
          {
            "node": "Process output into HTML1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Baserow Push Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}