Automated RSS Monitoring with Gemini AI Summaries & Dedup to Sheets

This n8n workflow automates RSS feed monitoring for content creators, marketers, and researchers. It pulls RSS feeds from a configured Google Sheet, fetches recent articles (filterable by days), checks for duplicates by URL against existing Sheet data, and processes only new items. Full article content is retrieved, HTML converted to markdown, and Gemini AI generates consistent summaries including main message, key takeaways, points, and practical insights.

Key benefits include time-saving automation of manual RSS curation, duplicate prevention for clean data, and enriched outputs with AI analysis ready for sharing or further use. It runs on schedule (e.g., hourly) or manually, using self-hosted n8n community nodes for compatibility.

Use cases: Track industry news for marketing reports, curate research feeds for teams, or build content libraries with summaries. Customize prompts, time filters, AI models, or Sheet fields. Requires Google Sheets access, OpenRouter API key, and RSS URLs in the template Sheet.