Automated RSS monitoring with Gemini AI summaries and deduplication to Google Sheets

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

Who's it for

Content creators, marketers, and researchers who need to monitor multiple RSS feeds and get AI-generated summaries without manual work.

How it works

This workflow automatically monitors RSS feeds, filters new articles from the last X days, checks for duplicates, and generates structured AI summaries. It fetches full article content, converts HTML to markdown, and uses Gemini AI to create consistent summaries with quick takeaways, key points, and practical insights. All data is saved to Google Sheets for easy access and sharing.

The system processes RSS feeds in batches, ensuring no duplicate articles are processed twice by checking existing URLs in your Google Sheets. Each new article gets a comprehensive AI summary that includes the main message, key takeaways, important points, and practical applications.

Requirements

- Google Sheets access - OpenRouter API key for Gemini AI model or other language model - RSS feed URLs to monitor