Automated RSS Feed Processing Workflow

This workflow is designed for:

• Content Creators: Individuals or teams who need to regularly gather and curate news content from various RSS feeds.
• Social Media Managers: Those who want to automate the process of sharing updated content and insights based on recent news.
• Digital Marketers: Professionals looking to keep their audience engaged with fresh content by removing outdated information.
• Developers: Users who are familiar with n8n and want to integrate automated workflows into their applications or services.

This workflow addresses the challenge of manually tracking and updating news content from multiple sources. It automates the process of:

• Collecting news from RSS feeds.
• Filtering out content older than 3 days to ensure only the most relevant and timely information is retained.
• Saving and organizing the news into a Google Sheets document for easy access and management.
• Scheduling these tasks to run automatically, thereby saving time and minimizing errors.

1. Schedule Trigger: The workflow initiates automatically based on a predefined schedule, ensuring it runs at regular intervals.
2. Read Links: It retrieves RSS feed links stored in a Google Sheets document.
3. Fetch News: For each link, the workflow reads the latest news articles.
4. Filter News: A coding node filters out articles older than 3 days, ensuring only fresh content is processed.
5. Edit Fields: Relevant fields such as id, title, output, pubDate, and tags are prepared for further processing.
6. Markdown Conversion: The content is formatted into Markdown for better presentation.
7. Save News: The fresh news articles are saved back into a Google Sheets document, appending or updating existing entries.
8. Delete Old News: Articles older than 3 days are deleted from the Google Sheets to keep the document clean and relevant.
9. Wait Nodes: Timed wait periods are implemented to prevent overwhelming the Google Sheets API with too many requests at once.