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 runs every Monday, pulls stories from your chosen RSS feeds, uses OpenAI Chat Completions to draft a grouped HTML newsletter, and saves it as a draft broadcast in Kit (ConvertKit) or ema

RSS Feed Read, HTTP Request, Gmail
AI & RAG

This workflow runs every Monday at 08:00, reads your blog’s RSS feed, filters posts from the last 7 days, and uses an OpenAI-compatible Chat Completions API to generate a markdown newsletter digest yo

RSS Feed Read, HTTP Request
AI & RAG

This workflow runs daily, reads your blog RSS feed, uses Google Gemini to repurpose the latest posts into Twitter/X and LinkedIn drafts in your brand voice, then appends the drafts to Google Sheets an

RSS Feed Read, HTTP Request, Google Sheets +1