Automate RSS Content with AI: Summarize, Notify & Archive

This n8n workflow automates the full lifecycle of RSS feed processing. It starts with a scheduled trigger every 24 hours, reading RSS URLs from a Google Sheets file, splitting them for individual handling. It then scans each feed, retrieves the latest entries, and filters out anything older than 24 hours to ensure fresh content without duplicates.

Next, it aggregates the filtered items, uses an OpenAI Chat Model for intelligent summarization, and sends beautifully formatted digests directly to Discord channels. Finally, it converts entries to Markdown and stores them in a second Google Sheets file, incorporating a wait step to respect API rate limits.

Benefits include no-code setup, AI-driven noise reduction, seamless Discord integration for real-time updates, and persistent storage for analysis or republishing. It saves hours of manual curation, making it perfect for busy teams.

Use cases: Daily tech news digests for Discord communities, content curation for newsletters, competitive intelligence from targeted RSS feeds, and auto-archiving of blogs or podcasts.