Daily newsletter service using Excel Outlook and AI
This n8n template builds a newsletter ("daily digest") delivery service which pulls and summarises the latest n8n.io template in select categories defined by...
🔌 Nodes & Integrations Used (7)
📖 Implementation & Setup Guide
This n8n template builds a newsletter ("daily digest") delivery service which pulls and summarises the latest n8n.io template in select categories defined by subscribers.
It's scheduled to run once a day and sends the newsletter directly to subscriber via a nicely formatted email. If you've had trouble keeping up with the latest and greatest templates beign published daily, this workflow can save you a lot of time!
How it works * A scheduled trigger pulls a list of subscribers (email and category preferences) from an Excel workbook. * We work out unique categories amongst all subscribers and only fetch the latest n8n website templates from these categories to save on resources and optimise the number of API calls we make. * The fetched templates are summarised via AI to produce a short description which is more suitable for our email format. * For each subscriber, we filter and collect only the templates relevant to their category preferences (as defined in the Excel) and ensure that duplicate templates or those which have been "seen before" are omitted. * A HTML node is then used to generate the email newsletter. HTML emails are the perfect format since we can add links back to the template. * Finally, we use the Outlook node to send the email digest to the subscriber.
How to use * Populate your Excel sheet with 3 columns: name, email and categories. Categories is a comma-delimited list of categories which match the n8n template website. The available categories are AI, SecOps, Sales, IT Ops, Marketing, Engineering, DevOps, Building Blocks, Design, Finance, HR, Other, Product and Support. * To subscribe a new user, simply add their email to the Excel sheet with at least one category. * To unsubscribe a user, remove them from the sheet. * If you're not interested in paid templates, you may want to filter them out after fetching.
Requirements * Microsoft Excel for subscriber list * Microsoft Outlook for delivering emails * OpenAI for AI-generated descriptions
Customising the workflow * Use AI to summarise the week's trend of templates types and use-cases * This template can be the basis for other similar newsletters - just pull in a list of things from anywhere!
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Daily newsletter service using Excel_ Outlook and AI.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Email & Outreach Workflows
View All in Email & Outreach →Abandoned cart recovery for Shopify via Gmail Google Sheets T
Who is this for? This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to reco...
Add new leads in Lemlist from Airtable
This workflow allows you to add new leads in Lemlist from Airtable. !workflow-screenshot Airtable node: This node lists all the emails that are stored in you...
Add Subscriber and Send Email Campaign
Production-ready n8n automation template for Add Subscriber and Send Email Campaign built by AhiXLight. Seamlessly connects Sendy with 3 configured nodes.
Add new contacts from HubSpot to the email list in Mailchimp
This workflow adds new HubSpot contacts to the Mailchimp email list. Prerequisites - HubSpot account and HubSpot credentials - Mailchimp account and Mailchim...