Daily newsletter service using Excel, Outlook and AI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 25 nodes and runs on a schedule (every day at 06:00). Along the way it connects Microsoft Excel 365, OpenAI Chat Model and Microsoft Outlook.
How it runs
Trigger: On a schedule (every day at 06:00).
- Get Subscribers (Microsoft Excel 365): read rows (worksheet)
- Parse Rows (Edit Fields (Set)): sets 3 fields: name, email, categories
- Get Unique Categories (Edit Fields (Set)): sets 1 field: categories
- Merge: merges the data from its input branches
- Categories to Items (Split Out): splits a list into separate items
- For Each Subscriber (Loop Over Items (Split in Batches)): loops over the items in batches
- Fetch Latest 10 per Category (HTTP Request): calls an HTTP API
- Has New Workflows? (If): checks a condition and branches into true / false
- Get Relevant Workflows (Edit Fields (Set)): sets 1 field: workflows
- Append Category (Edit Fields (Set)): sets 1 field: category
…plus 12 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (15)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Aggregate
n8n-nodes-base.aggregate - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Merge
n8n-nodes-base.merge - HTTP Request
n8n-nodes-base.httpRequest - No Operation, do nothing
n8n-nodes-base.noOp - Remove Duplicates
n8n-nodes-base.removeDuplicates - If
n8n-nodes-base.if - HTML
n8n-nodes-base.html - Microsoft Outlook
n8n-nodes-base.microsoftOutlook
From the author
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…