Schedule Trigger Automate

Automated workflow for Schedule Trigger that efficiently retrieves and processes RSS feed links every 24 hours, saving relevant news articles in Google Sheets while removing entries older than 3 days, ensuring up-to-date content management.

7/8/2025
23 nodes
Complex
schedulecomplexschedule triggermarkdownsplitinbatcheswaitrssfeedreadsticky notegooglesheetsautomationadvancedcron
Categories:
Schedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
Schedule TriggerMarkdownSplitInBatchesWaitRssFeedReadSticky NoteGoogleSheets

Target Audience

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.

Problem Solved

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.

Workflow Steps

  • 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.

    • Customization Guide

    Users can customize this workflow by:
    - Adjusting the Schedule: Modify the scheduling parameters in the Schedule Trigger node to change how often the workflow runs (e.g., daily, weekly).
    - Editing the Days Filter: Change the setdays variable in the filtering code to alter the time frame for news articles to be retained (e.g., from 3 days to 7 days).
    - Modifying RSS Links: Update the Google Sheets document that contains RSS feed links to add or remove sources as needed.
    - Customizing Markdown Output: Alter the Markdown formatting options to suit specific content presentation needs.
    - Changing Google Sheets Settings: Adjust the Google Sheets document ID and sheet name in the nodes to point to different documents or sheets for saving data.