AutomationFlowsAI & RAG › Insurance News Aggregation Keyword Analysis & Database Storage via Supabase

Insurance News Aggregation Keyword Analysis & Database Storage via Supabase

ByShelly-Ann Davy @SheCodesFlow on n8n.io

Automatically collect, analyze, and store industry news articles with intelligent filtering and dual-database storage

Cron / scheduled trigger★★★★☆ complexity16 nodesRSS Feed ReadHTTP Request
AI & RAG Trigger: Cron / scheduled Nodes: 16 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #9507 — we link there as the canonical source.

This workflow follows the HTTP Request → RSS Feed Read recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "name": "Insurance News Aggregation with Keyword Analysis & Dual-Database Storage via Supabase",
  "tags": [
    "insurance",
    "news",
    "supabase",
    "content-aggregation"
  ],
  "nodes": [
    {
      "name": "Sticky Note - Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        140,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "name": "Schedule Every 6 Hours",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        250,
        480
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "Get News Sources",
      "type": "n8n-nodes-base.function",
      "position": [
        450,
        480
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "Is RSS Feed?",
      "type": "n8n-nodes-base.if",
      "position": [
        650,
        480
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "Fetch RSS Feed",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        850,
        380
      ],
      "parameters": {},
      "typeVersion": 1,
      "continueOnFail": true
    },
    {
      "name": "Fetch Google News RSS",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        850,
        580
      ],
      "parameters": {},
      "typeVersion": 1,
      "continueOnFail": true
    },
    {
      "name": "Scrape Web Page",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        850,
        780
      ],
      "parameters": {},
      "typeVersion": 3,
      "continueOnFail": true
    },
    {
      "name": "Parse Articles",
      "type": "n8n-nodes-base.function",
      "position": [
        1050,
        580
      ],
      "parameters": {},
      "typeVersion": 1,
      "continueOnFail": true
    },
    {
      "name": "Fetch Full Article",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1250,
        580
      ],
      "parameters": {},
      "typeVersion": 3,
      "continueOnFail": true
    },
    {
      "name": "Rate Limit Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        1250,
        780
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "Extract Content & Keywords",
      "type": "n8n-nodes-base.code",
      "position": [
        1450,
        580
      ],
      "parameters": {},
      "typeVersion": 1,
      "continueOnFail": true
    },
    {
      "name": "Is Relevant?",
      "type": "n8n-nodes-base.if",
      "position": [
        1650,
        580
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "Store in Content Library",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1850,
        480
      ],
      "parameters": {},
      "typeVersion": 3,
      "continueOnFail": true
    },
    {
      "name": "Store in Knowledge Base",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1850,
        680
      ],
      "parameters": {},
      "typeVersion": 3,
      "continueOnFail": true
    },
    {
      "name": "Error Handler",
      "type": "n8n-nodes-base.function",
      "position": [
        1450,
        780
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "Sticky Note - Setup",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        560,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "settings": {
    "callerPolicy": "workflowsFromSameOwner",
    "errorWorkflow": "",
    "executionOrder": "v1",
    "saveManualExecutions": true
  },
  "updatedAt": "2025-01-15T00:00:00.000Z",
  "versionId": "3",
  "staticData": null,
  "connections": {
    "Is RSS Feed?": {
      "main": [
        [
          {
            "node": "Fetch RSS Feed",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Fetch Google News RSS",
            "type": "main",
            "index": 0
          },
          {
            "node": "Scrape Web Page",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Is Relevant?": {
      "main": [
        [
          {
            "node": "Store in Content Library",
            "type": "main",
            "index": 0
          },
          {
            "node": "Store in Knowledge Base",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Error Handler",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch RSS Feed": {
      "main": [
        [
          {
            "node": "Parse Articles",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Articles": {
      "main": [
        [
          {
            "node": "Fetch Full Article",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape Web Page": {
      "main": [
        [
          {
            "node": "Parse Articles",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get News Sources": {
      "main": [
        [
          {
            "node": "Is RSS Feed?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Full Article": {
      "main": [
        [
          {
            "node": "Extract Content & Keywords",
            "type": "main",
            "index": 0
          },
          {
            "node": "Rate Limit Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Google News RSS": {
      "main": [
        [
          {
            "node": "Parse Articles",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Every 6 Hours": {
      "main": [
        [
          {
            "node": "Get News Sources",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store in Knowledge Base": {
      "main": [
        []
      ]
    },
    "Store in Content Library": {
      "main": [
        []
      ]
    },
    "Extract Content & Keywords": {
      "main": [
        [
          {
            "node": "Is Relevant?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "triggerCount": 1
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Automatically collect, analyze, and store industry news articles with intelligent filtering and dual-database storage

Source: https://n8n.io/workflows/9507/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Automatically fetch, rank, and summarize the top financial stories from curated RSS feeds each day, then deliver a concise AI-written digest to Telegram and log the run to Google Sheets. Runs on a dai

Google Sheets, HTTP Request, RSS Feed Read
AI & RAG

Stay on top of what’s happening in your community without drowning in endless RSS feeds.

RSS Feed Read, HTTP Request, Discord
AI & RAG

This workflow creates a daily “n8n News Radar” briefing: Pulls the latest n8n ecosystem updates from Blog, Community, GitHub Releases, and Reddit. Filters to the last 24 hours + keyword relevance. Use

Telegram, Notion, Google Gemini +2
AI & RAG

Start your day with a personalized news podcast delivered directly to your Telegram. This workflow helps you stay informed without scrolling through endless feeds. It automatically collects news from

RSS Feed Read, YouTube, Google Gemini +2
AI & RAG

Daily Economic News Brief for Israel (Hebrew, RTL, GPT-4o)

Email Send, HTTP Request, OpenAI +1