Back to Templates

Create a Personalized Daily Newsletter with Google Gemini AI and RSS Feeds

Created by

Created by: Dixit Ram || dixitram

Dixit Ram

Last update

Last update 11 hours ago

Share


Who's it for

This workflow is for anyone who wants to stay informed without the overwhelm. Whether you're tracking industry news, following your favorite blogs, monitoring competitors, or just keeping up with topics you care about—this automated newsletter keeps you in the loop effortlessly.

What it does

This automated workflow fetches content from your favorite RSS feeds, filters it based on your interests using Google Gemini AI, and sends you a beautifully formatted HTML newsletter at your preferred time. The AI selects the top 10-15 items from each category based on keywords you define, delivering only what matters to you.

How it works

  1. Schedule Trigger: Runs daily at your chosen time (default: 9:00 AM)
  2. RSS Feeds: Fetches content from your favorite news sources and websites
  3. Processing: Splits URLs, loops through feeds in batches to avoid rate limits
  4. Merge & Convert: Combines all RSS items into a single CSV file
  5. AI Curation: Google Gemini analyzes the content and selects relevant items based on your keywords
  6. Email Delivery: Sends a personalized HTML newsletter with summaries and images

Requirements

  • Google Gemini API credentials (for AI curation)
  • SMTP credentials (for sending emails)
  • Active n8n instance (self-hosted or cloud)

How to set up

  1. Add your Google Gemini API credentials in both Gemini nodes
  2. Configure your SMTP settings in the "Send email" node
  3. Update the email addresses (from and to) in the email node
  4. Add your favorite RSS feed URLs in the "Set" nodes
  5. Customize the AI keywords in "Analyze document" to match your interests
  6. Set your preferred schedule time in the trigger node

How to customize

  • Add your RSS feeds: Replace the example URLs in both "Set" nodes with RSS feeds from your favorite sources (blogs, news sites, podcasts, YouTube channels, etc.)
  • Define your interests: Modify the keywords in the "Analyze document" AI prompt to filter content that matters to you
  • Adjust categories: Change the two sections to match your needs (e.g., "Industry News" and "Competitor Updates" or "Learning Resources" and "Tools")
  • Change email format: Update the HTML template in the AI prompt to customize the newsletter design
  • Modify delivery time: Update the schedule trigger to run at your preferred time