Smart RSS Feed Reader with AI Summaries and Deduplication
detail.loadingPreview
Automate your content aggregation with this powerful n8n workflow. It fetches articles from multiple RSS feeds, intelligently removes duplicates, generates concise AI summaries, and stores all relevant information neatly in Google Sheets for easy access and analysis.
About This Workflow
Never miss an important update and cut through the noise with this intelligent RSS feed reader. This n8n workflow streamlines your information consumption by pulling articles from a customizable list of RSS feeds managed in Google Sheets. It includes robust deduplication logic to ensure you only process unique content. Crucially, it converts fetched article HTML into a cleaner Markdown format, then leverages AI to generate brief summaries, making it ideal for quick scanning or further LLM processing. All processed articles, complete with their AI summaries, original links, titles, sources, and publication dates, are systematically appended to a designated Google Sheet, transforming raw feed data into structured, actionable insights.
Key Features
- Centralized RSS Management: Configure your entire list of RSS feed URLs directly within a Google Sheet, making it easy to add or remove sources.
- Intelligent Deduplication: Prevents redundant processing and storage by checking for existing articles (via their link) in your Google Sheet before adding new entries.
- AI-Powered Summarization: Automatically converts article HTML content to Markdown and generates a concise AI summary, saving you valuable reading time.
- Structured Data Storage: Organizes all extracted article details, including link, title, source, publication date, categories, and AI summary, into a clean Google Sheet.
- Flexible & Extensible: Built with n8n, this workflow can be easily customized to integrate with other services or expand its capabilities (e.g., notifications, further analysis).
How To Use
- Set up your Google Sheets: Create two Google Sheets: one to list your RSS feed URLs (e.g., 'RSS Feeds') and another to store the processed articles (e.g., 'Articles'). Ensure your 'Articles' sheet has columns for 'link', 'title', 'source', 'pubDate', 'ai summary', and 'categories'.
- Configure Google Sheets Credentials: Connect your Google Sheets account to n8n using OAuth2. This workflow uses 'gSheets roman@ibb.media' as an example.
- Specify Sheet & Document IDs: In the 'Get RSS Feed List' and 'Get Row for URL is in Sheets' nodes, update the
DocumentandSheet Nameexpressions to point to your specific Google Sheet IDs and names. - (Optional) Integrate an LLM: If not already configured, set up your preferred Large Language Model node (e.g., OpenAI, Cohere, custom) to generate the 'ai summary' from the Markdown content produced by the 'Convert HTML to Markdown' node.
- Activate and Execute: Once configured, activate the workflow. You can trigger it manually via the 'When clicking ‘Execute workflow’' node or set up a time-based trigger for regular updates.
Apps Used
Workflow JSON
{
"id": "07823b85-38d0-4bc9-a9d2-054a43c41807",
"name": "Smart RSS Feed Reader with AI Summaries and Deduplication",
"nodes": 29,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 07823b85-38d0...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.