Monitor and classify RSS feeds with AI, then alert Slack and Google Sheets
Workflow Description
Scheduled automation that fetches RSS feeds, analyzes content using OpenAI, classifies articles by importance and category, stores results in Google Sheets, and sends real-time alerts to Slack channels based on priority levels.
How it works
- 1.Run the workflow on a set schedule to fetch updates automatically
- 2.Read and extract the latest articles from configured RSS feed sources
- 3.Send article titles and summaries to OpenAI for semantic analysis and meaning extraction
- 4.Classify content automatically by relevance, category, and priority tier
- 5.Record all analyzed data and classifications in a Google Sheets spreadsheet
- 6.Post high-priority findings as messages to designated Slack channels instantly
Use cases
- Monitor industry news and competitor announcements with automatic categorization for leadership teams
- Track mentions and updates across multiple blogs and news sources without manual effort
- Build a searchable archive of analyzed articles for knowledge management and research
- Trigger urgent alerts when critical information is detected by AI classification rules
Requirements
- Active OpenAI API key with sufficient quota for text processing
- Google Workspace account with permissions to edit spreadsheets
- Slack workspace with bot permissions to post messages to channels
- Valid and regularly updated RSS feed URLs configured in the workflow
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (31)
OpenAI Chat Model
OpenAI
Basic LLM Chain
LLM Chain
Schedule Trigger
Schedule Trigger
RSS Read
Rss Feed Read
Relevance Classification for Topic Monitoring
If
Sticky Note
Sticky Note
Sticky Note3
Sticky Note
Google Sheets - Get RSS Feed url followed
Google Sheets
Sticky Note4
Sticky Note
Sticky Note6
Sticky Note
Sticky Note5
Sticky Note
Slack1
Slack
Sticky Note8
Sticky Note
Sticky Note9
Sticky Note
Sticky Note10
Sticky Note
Sticky Note2
Sticky Note
Sticky Note11
Sticky Note
Sticky Note12
Sticky Note
Sticky Note1
Sticky Note
Sticky Note7
Sticky Note
Google Sheets - Get article monitored database
Google Sheets
Code
Code
No Operation, do nothing
No Op
If
If
Jina AI - Read URL
HTTP Request
Set field - existing_url
Set
OpenAI Chat Model1
OpenAI
Set fields - Not relevant articles
Set
Google Sheets - Add relevant articles
Google Sheets
Google Sheets - Add relevant article
Google Sheets
Set Fields - Relevant Articles
Set