Tech news aggregator: The Verge & TechCrunch RSS to Notion with GPT-4 summaries

This n8n workflow automates the process of fetching, processing, and storing tech news articles from RSS feeds into a Notion database. It retrieves articles from The Verge and TechCrunch, processes them to avoid duplicates, extracts full article content, generates summaries using an LLM, and stores the data in Notion. The workflow is designed to run on a schedule or manually for testing, with sticky notes providing clear documentation for each step.

Data in notion 

Workflow Overview

- Triggers: - Manual Trigger: Used for testing the workflow (When clicking ‘Execute workflow’). - Schedule Trigger: Runs daily at 11 AM to fetch new articles (Schedule Trigger, disabled).

- Fetch Feeds: - Pulls RSS feeds from The Verge (The Verge) and TechCrunch (TechCrunch).

- Hash Creation: - Generates a SHA256 hash of each article’s URL (Crypto, Crypto1) to identify unique articles efficiently.

- Loop Over Articles: - Processes articles in batches (Loop Over Items, Loop Over Items1) to handle multiple articles from each feed.

- Duplicate Check: - Queries the Notion database (Get many database pages, Get many database pages1) to check if an article’s hash exists. If it does, the article is skipped (If, If1).