This n8n workflow automates the process of fetching, filtering, and managing RSS feed entries from Google Sheets. It is designed to regularly update a list of news links by reading new RSS feeds, filtering out old content, and maintaining an organized, up-to-date feed. The workflow starts with a scheduled trigger that initiates the process daily, fetching RSS feed links stored in Google Sheets. Each link is then read and processed, where new entries are filtered based on their publication date—keeping only those published within the last three days.
The workflow employs multiple nodes: it retrieves the list of RSS links, reads each link’s content, filters entries according to age, and formats the remaining news items into Markdown for easy presentation or further use. Older entries are identified with custom code nodes, and finally, outdated news is deleted from Google Sheets to keep the data current and manageable. Various wait nodes are used to avoid exceeding API rate limits, ensuring the process runs smoothly without interruptions.
This automation is highly useful for content curators, news websites, or anyone who maintains a dynamic RSS feed that needs regular updates and cleanups without manual intervention. It ensures fresh content is always available while removing stale entries, streamlining content management workflows.
Reviews
There are no reviews yet.