From RSS Feeds to Ready-to-Use Scripts - Workflow

Keeping up with AI news is exhausting. Every day brings breakthrough models, policy changes, funding announcements, and research papers. Content creators, especially those running AI-focused YouTube channels or newsletters, face a brutal choice: spend hours manually curating news or miss the stories that matter most.

What if your computer could do the heavy lifting? This n8n workflow automatically collects AI news from trusted sources, filters for recent stories, and transforms them into presenter-ready video scripts. No more scrambling at 6 AM wondering what to cover today.

Prerequisites: What You'll Need to Get Started

Before diving into the workflow construction, gather these essential components:

• n8n Platform: Either self-hosted or cloud version
• Google Sheets API: For storing your generated scripts
• Google Gemini API: The AI engine that writes your scripts
• RSS Feed Access: The workflow uses public feeds, no special access needed

Key Components: The Building Blocks

This automation workflow leverages several powerful n8n nodes working in harmony:

• Schedule Trigger: Kicks off the entire process at 8 AM daily
• Code Node: Handles RSS feed URLs and data processing logic
• RSS Feed Read: Fetches articles from multiple AI news sources
• If Node: Filters articles from the last 1-2 days only
• Google Gemini Chat Model: The AI brain that writes compelling scripts
• Google Sheets Node: Stores your finished scripts for easy access

Step 1: Set Your News Sources and Schedule

Start by creating a Schedule Trigger node set to fire at 8 AM every day. This gives you fresh content to review each morning before you start creating.

Next, add a Code node that defines your RSS feed sources. The workflow targets five high-quality AI news feeds:

• MIT Technology Review
• Towards Data Science
• AI Trends
• MIT AI News
• The Gradient

These sources provide a healthy mix of breaking news, research insights, and industry analysis. The Code node returns each feed URL as a separate item, setting up the next processing step.

image_1.png

Step 2: Collect and Filter Fresh Content

Connect a Split in Batches node to process each RSS feed individually. This prevents one slow feed from blocking others and makes error handling cleaner.

Add an RSS Feed Read node that fetches articles from each source. Set it to continue on error so a single broken feed doesn't crash your entire workflow.

Here's where smart filtering happens: an If node checks publication dates and only passes articles from the last two days. This keeps your content current and prevents processing old stories your audience has already seen.

A Limit node caps each feed at 10 articles maximum. With five feeds, you'll never process more than 50 articles total, keeping execution times reasonable.

Step 3: Clean and Deduplicate Your Data

Raw RSS feeds are messy. Articles have different field names, some lack crucial information, and popular stories appear across multiple sources.

The workflow includes a sophisticated Code node that handles data cleaning:

• Extracts consistent fields: title, source, link, content, and publication date
• Removes duplicate articles using URL matching
• Filters out incomplete articles missing titles or links
• Handles various RSS formats automatically

image_2.png

An Aggregate node then combines all cleaned articles into a single dataset, ready for AI processing.

Step 4: Generate Professional Video Scripts

This is where the magic happens. The workflow uses Google Gemini with a carefully crafted prompt that acts like an experienced video producer.

The AI receives your curated articles and follows specific instructions:

Select 10 of the most impactful stories, prioritizing breakthroughs, industry news, research developments, and policy changes. Generate a comprehensive 700-800 word video script with presenter-style narration for each story.

A Structured Output Parser ensures consistent formatting. Every generated script includes:

• Headline: The article's main title
• Source: Publication or author attribution
• Script: 700-800 words of presenter-ready content
• Link: Direct URL to the original article

The AI doesn't just summarize. It explains why each story matters, adds context about industry implications, and creates smooth transitions between segments.

Step 5: Store and Access Your Content

A Split Out node separates the batch-processed articles into individual items. Each article becomes a separate row in your Google Sheets document.

The final Google Sheets node appends new content to your spreadsheet. You wake up each morning to find fresh, AI-generated video scripts waiting in an organized, searchable format.

image_3.png

Benefits and Practical Use Cases

This automated workflow transforms content creation from a daily grind into a streamlined process:

• Time Savings: Reduces 2-3 hours of manual research to 10 minutes of review
• Consistency: Never miss important AI developments again
• Quality Control: Focuses on authoritative sources and recent developments
• Scalability: Easy to add new RSS feeds or adjust filtering criteria

Content creators use this for YouTube videos, podcast preparation, newsletter writing, and social media planning. The structured output adapts easily to different formats and platforms.

Marketing teams leverage it for industry trend analysis and competitive intelligence. Researchers use it to stay current with developments outside their specific focus areas.

The workflow runs silently in the background, requiring minimal maintenance once configured. RSS feeds occasionally change URLs or formats, but the error handling ensures your automation keeps running even when individual sources have issues.

Building this workflow takes about 30 minutes. The time investment pays for itself within a week of consistent use. Your mornings become productive strategy sessions instead of frantic news hunting expeditions.

Ready to automate your AI news curation? Start with the Schedule Trigger, add your RSS sources, and let artificial intelligence handle the heavy lifting while you focus on creating compelling content your audience actually wants to consume.