Daily Newsletter Service using Excel, Outlook & AI

This workflow creates a fully automated daily newsletter service that delivers curated digests of the latest n8n.io templates to subscribers. It starts with a scheduled trigger that reads subscriber data from an Excel workbook, including names, emails, and comma-separated category preferences (e.g., AI, Marketing, DevOps). To optimize efficiency, it identifies unique categories across all subscribers, fetches only the newest templates from the n8n website via API, and uses AI to generate concise summaries suitable for email format.

For each subscriber, the workflow intelligently filters templates matching their preferences, excludes duplicates or previously seen items, and compiles them into a professional HTML email with direct links to the templates. This ensures personalized, relevant content without overwhelming recipients. The newsletter is then sent directly via the Outlook node, providing a seamless end-to-end automation.

Ideal for n8n communities, marketers, or teams tracking automation templates, it saves hours of manual curation. Benefits include resource optimization (fewer API calls), easy subscriber management (add/remove via Excel), and high engagement through tailored content. Perfect for internal knowledge sharing or customer newsletters, scalable for hundreds of subscribers.