{
  "name": "Automated RSS monitoring with Gemini AI summaries and deduplication to Google Sheets",
  "nodes": [
    {
      "id": "abe6ed52-40ac-4ed5-abea-419d94505509",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -3080,
        360
      ]
    },
    {
      "id": "43696041-99ea-4d24-b677-d025bb556544",
      "name": "Get RSS Feed List",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2380,
        280
      ]
    },
    {
      "id": "02fc9382-dd56-4af0-8c1c-9f3c83461b05",
      "name": "Read RSS",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        -1900,
        480
      ]
    },
    {
      "id": "c39a746a-639e-4d21-9dac-6974bb52a030",
      "name": "Loop Over Rss Elements",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -1340,
        -200
      ]
    },
    {
      "id": "b7f5ad99-0ea3-45b6-ae0b-07458a4255b3",
      "name": "Get Row for URL is in Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1120,
        -180
      ]
    },
    {
      "id": "05c8ff40-8232-4683-950a-37fa60d87eb2",
      "name": "Convert HTML to Markdown",
      "type": "n8n-nodes-base.markdown",
      "position": [
        -240,
        -200
      ]
    },
    {
      "id": "6708c44c-e1a5-4f2b-9780-c980c7a95053",
      "name": "Append Aummary to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        580,
        -40
      ]
    },
    {
      "id": "366e157b-9ff0-4913-b993-7d37c3252fe2",
      "name": "Combine Rss with source name",
      "type": "n8n-nodes-base.set",
      "position": [
        -1660,
        480
      ]
    },
    {
      "id": "29f5c69a-c6ea-4191-bff5-914044efb76e",
      "name": "Check If Article Exists",
      "type": "n8n-nodes-base.if",
      "position": [
        -900,
        -180
      ]
    },
    {
      "id": "a3e91192-55c8-4384-8d2e-fc6cc7321c98",
      "name": "Summarize Content",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -20,
        -200
      ]
    },
    {
      "id": "6edc03ae-3932-4b6d-b8f1-98cb2e51f4cb",
      "name": "Format Output",
      "type": "n8n-nodes-base.set",
      "position": [
        320,
        -200
      ]
    },
    {
      "id": "02eb922d-ae5c-4029-a01a-3a279989fa1c",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -3080,
        180
      ]
    },
    {
      "id": "131b0ae1-bc12-48d8-a20d-bbffbf9b6bee",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -2100,
        280
      ]
    },
    {
      "id": "28c1347b-e54e-405e-ab0a-da6a422187da",
      "name": "Filter Last X Days",
      "type": "n8n-nodes-base.filter",
      "position": [
        -1740,
        -200
      ]
    },
    {
      "id": "852a3623-87a1-4a96-99f4-eb8303ab7c2c",
      "name": "Settings",
      "type": "n8n-nodes-base.set",
      "position": [
        -2640,
        280
      ]
    },
    {
      "id": "7f3236e0-025d-496e-aacc-c74f15df3ec2",
      "name": "LLM Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        -60,
        -20
      ]
    },
    {
      "id": "e4b8e1da-e960-4774-8419-0ffce5df9b3f",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2720,
        40
      ],
      "parameters": {
        "width": 300,
        "height": 460,
        "content": "## Settings\n\n- Copy this Google Sheet : https://docs.google.com/spreadsheets/d/1i1p_DPymm8QeZrCLxs-Skz8BMSutKpUW4khzpiNBcYc/copy\n- Enter copied URL's in settings\n- Set up time gap for news from RSS"
      }
    },
    {
      "id": "472a0cbb-2b01-48c1-8472-8b0962269a80",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2220,
        220
      ],
      "parameters": {
        "width": 1060,
        "height": 560,
        "content": "## Loop for adding source name to RSS record"
      }
    },
    {
      "id": "94ead111-4efe-459d-9053-3ff7714d5b98",
      "name": "End of worfklow",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -1120,
        -460
      ]
    },
    {
      "id": "5e470cd5-23c9-4866-a18c-694bf1c021a9",
      "name": "Get Webpage HTML Content",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -660,
        -200
      ]
    },
    {
      "id": "8bc1cad5-fbbc-43fa-b41f-e668bf9bd8f8",
      "name": "Extract Body Content in HTML",
      "type": "n8n-nodes-base.html",
      "position": [
        -460,
        -200
      ]
    },
    {
      "id": "68bb881d-8c0c-4c21-9fab-237bcc42f76e",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1080,
        300
      ],
      "parameters": {
        "width": 760,
        "height": 280,
        "content": "## Google Sheets Columns\nGoogle Sheet Template: https://docs.google.com/spreadsheets/d/1i1p_DPymm8QeZrCLxs-Skz8BMSutKpUW4khzpiNBcYc/\n### Articles Sheet\n| pubDate    | source | title | link | categorie"
      }
    },
    {
      "id": "396e077e-aba2-4b89-bb0b-7aece91b924b",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3840,
        -540
      ],
      "parameters": {
        "width": 700,
        "height": 1680,
        "content": "# Monitor RSS feeds with AI summaries to Google Sheets\n\n## What this workflow does\n\nThis automation monitors multiple RSS feeds, filters new articles from the last X days, checks for duplicates, and g"
      }
    }
  ],
  "connections": {
    "Read RSS": {
      "main": [
        [
          {
            "node": "Combine Rss with source name",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Settings": {
      "main": [
        [
          {
            "node": "Get RSS Feed List",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Output": {
      "main": [
        [
          {
            "node": "Append Aummary to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "LLM Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Summarize Content",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Filter Last X Days",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Read RSS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Settings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get RSS Feed List": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarize Content": {
      "main": [
        [
          {
            "node": "Format Output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Last X Days": {
      "main": [
        [
          {
            "node": "Loop Over Rss Elements",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Rss Elements": {
      "main": [
        [
          {
            "node": "End of worfklow",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Get Row for URL is in Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check If Article Exists": {
      "main": [
        [
          {
            "node": "Get Webpage HTML Content",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Over Rss Elements",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert HTML to Markdown": {
      "main": [
        [
          {
            "node": "Summarize Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Webpage HTML Content": {
      "main": [
        [
          {
            "node": "Extract Body Content in HTML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine Rss with source name": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Body Content in HTML": {
      "main": [
        [
          {
            "node": "Convert HTML to Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Row for URL is in Sheets": {
      "main": [
        [
          {
            "node": "Check If Article Exists",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append Aummary to Google Sheets": {
      "main": [
        [
          {
            "node": "Loop Over Rss Elements",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Settings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}