receive schedule events and readrows worksheet microsoft excel and aggregate
Configured with Aggregate, Chain LLM, Html, HTTP Request, and additional nodes. Review the connections and setup before adapting this template.
Node categories in this workflow
- Trigger
- Data store
- Transform
- AI & models
- Routing
- Web / API
- Messaging
Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.
Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.
How it works
The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.
| Node | Category | Type | Operation |
|---|---|---|---|
| Schedule Trigger | Trigger | Schedule Trigger | See node parameters |
| Get Subscribers | Data store | Microsoft Excel | worksheet / readRows |
| Get Unique Categories | Transform | Edit Fields | See node parameters |
| OpenAI Chat Model | AI & models | OpenAI Chat Model | See node parameters |
| Aggregate | Transform | Aggregate | See node parameters |
| Collect Fields | Transform | Edit Fields | See node parameters |
| Categories to Items | Transform | Split Out | See node parameters |
| For Each Category | Routing | Loop Over Items | See node parameters |
| Workflows to Items | Transform | Split Out | See node parameters |
| Workflow Summarizer | AI & models | Chain LLM | See node parameters |
| Merge | Transform | Merge | See node parameters |
| Fetch Latest 10 per Category | Web / API | HTTP Request | See node parameters |
| No Operation, do nothing | Routing | No Op | See node parameters |
| Get Relevant Workflows | Transform | Edit Fields | See node parameters |
| Flatten Workflows | Transform | Edit Fields | See node parameters |
| Remove Already Seen | Transform | Remove Duplicates | removeItemsSeenInPreviousExecutions |
| Workflow to Items | Transform | Split Out | See node parameters |
| Combine Workflows | Transform | Aggregate | See node parameters |
| Has New Workflows? | Routing | If | See node parameters |
| With User Reference | Transform | Edit Fields | See node parameters |
| Generate HTML Template | Transform | Html | See node parameters |
| Parse Rows | Transform | Edit Fields | See node parameters |
| Send Daily Digest | Messaging | Microsoft Outlook | See node parameters |
| Append Category | Transform | Edit Fields | See node parameters |
| For Each Subscriber | Routing | Loop Over Items | See node parameters |
Setup
- Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
- Connect your own credentials through n8n’s credential store. Replace
REPLACE_WITH_*values with your resource identifiers. - Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
- Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.
Requirements
An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.
Credential types declared in the source
microsoftExcelOAuth2ApimicrosoftOutlookOAuth2ApiopenAiApi
Workflow notes
1. Get Subscribers from Excel
1. Get Subscribers from Excel
Learn more about the Excel node
Excel can be an easy way to store a simple list of subscribers who will receive our daily digest. We can also specify only the categories they are interested in.
2. Fetch Latest Templates from n8n
2. Fetch Latest Templates from n8n
Learn more about the HTTP Request node
Using the HTTP request node, we can call the n8n.io template search API to the latest published templates. However, to save on resources, we only want to fetch from categories relevant to our subscribers. To do so:
- We only want to fetch latest templates from unique categories amongst all subscribers
- Do this fetching once to later reference for all subscribers
3. Generate AI Summary For Each Template
3. Generate AI Summary For Each Template
Read more about the Basic LLM node
When building our email digest, we'd rather have a shortened and summarized version of each template's description for easier scanning and reading. We can use AI to accomplish this and merge it with the template object.
4. Filter Relevant Templates for Subscriber
4. Filter Relevant Templates for Subscriber
Read more about the Split Out node
For each subscriber, we want to filter out our freshly collected n8n.io templates by the categories relevant to the subscriber as defined in the Excel sheet. A "Remove duplicates" node can be used to keep track of duplicate templates - as templates can have more than one category and appear twice!
5. Generate Daily Digest and Send Via Outlook
5. Generate Daily Digest and Send Via Outlook
Read more about the Outlook node
Finally, we can construct our digest's content using the HTML node and customise it by subscriber as necessary. The Outlook node is then used to send the digest to the subscriber.
Execute Once
Execute Once
This node has been set to execute once rather than for each subscriber.
Columns
Columns
- name (text)
- email (text)
- categories (text, comma-delimited)
Try It Out!
Try It Out!
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 them.
Need Help?
receive schedule events and readrows worksheet microsoft excel and aggregate
receive schedule events and readrows worksheet microsoft excel and aggregate
Purpose and structure
This folder contains the receive schedule events and readrows worksheet microsoft excel and aggregate workflow. Its executable nodes use aggregate, chainLlm, html, httpRequest, if, lmChatOpenAi, merge, microsoftExcel, microsoftOutlook, noOp, removeDuplicates, scheduleTrigger, set, splitInBatches, splitOut. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.
Setup
Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.
Entry points
Schedule Trigger
Verification
Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.
Attribution
https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Splitout/0833_Splitout_Schedule_Create_Webhook.json MIT; preserve source notices.