n8nflow.net logo

Daily French Economic News Digest with Gemini AI & Outlook Email

by Louisβ€’Updated: Last update a month agoβ€’Source: n8n.io
Loading workflow viewer...

πŸ“¬ What this workflow does

Every morning β†’ fetch 3 French economy RSS feeds β†’ keep fresh items β†’ AI rewrites into short summaries β†’ send a nice HTML email newsletter.


πŸ”„ Flow (high level)

  1. ⏰ Trigger at 07:00
  2. πŸ“° Fetch RSS (Le Monde, Usine Nouvelle, Le Figaro)
  3. β›” Filter β†’ keep only recent items
  4. πŸ”’ Sort newest first
  5. βœ‚οΈ Limit 2 per source
  6. βž• Merge
  7. πŸ€– AI summary (title + paragraph)
  8. 🏷 Normalize fields (title, source, link…)
  9. πŸ“¦ Aggregate arrays
  10. πŸ“§ Send via Outlook (HTML template)

🧩 Node notes

  • Trigger β†’ 07:00 daily (check timezone).
  • RSS Read β†’ feeds OK, but UsineNouvelle is http (redirects fine).
  • If nodes β†’ ❗ currently after $today β†’ keeps only future dates.
    • Fix:
      • For today only : after $today.startOf('day')
      • For last 24h : after $now.minus({ hours: 24 })
  • Sort + Limit β†’ newest 2 per feed.
  • Merge β†’ combine up to 6 items.
  • AI agent β†’ prompt uses <article> … needs closing </article> βœ…
  • Edit Fields β†’ maps source domains β†’ nice labels (β€œLe Monde” etc).
  • Aggregate β†’ arrays for email template.
  • Outlook email β†’ HTML newsletter (mobile-friendly).

⚑ Quick wins

  • πŸ•’ Fix the date filter logic (today/24h).
  • πŸ“ Fix closing tag in AI prompt (</article>).
  • 🌍 Add User-Agent header in RSS nodes (avoid 403).
  • πŸ” Remove duplicates on link.
  • ⏳ Mind the server timezone vs your audience.

Screenshot 20250821 at 12.32.58.png