Schedule Trigger Automate

For platform n8n, automate daily email digests by pulling subscriber preferences from Excel, fetching the latest templates based on their interests, and summarizing them with AI. This workflow ensures subscribers receive tailored content, enhancing engagement while saving time and resources.

7/8/2025
33 nodes
Complex
schedulecomplexschedule triggermicrosoftexcellangchainaggregatesplitoutsplitinbatchesnoopremoveduplicatesmicrosoftoutlooksticky noteautomationadvancedcronapiintegrationlogicconditional
Categories:
Communication & MessagingSchedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
Schedule TriggerMicrosoftExcelLangChainAggregateSplitOutSplitInBatchesNoOpRemoveDuplicatesMicrosoftOutlookSticky Note

Target Audience

This workflow is ideal for:
- Marketing Teams: To keep subscribers updated with the latest templates in their areas of interest.
- Business Owners: Who want to automate their newsletter for efficient communication with clients.
- Content Creators: Looking for a streamlined way to share new resources with their audience.
- Automation Enthusiasts: Individuals interested in leveraging n8n for automating repetitive tasks related to email marketing.

Problem Solved

This workflow addresses the challenge of efficiently delivering relevant content to subscribers based on their interests. It helps to:
- Automatically gather subscriber information from an Excel sheet.
- Fetch and summarize the latest templates from n8n.io relevant to each subscriber's categories.
- Send personalized daily digest emails to keep users engaged without manual intervention.

Workflow Steps

  • Scheduled Trigger: The workflow is triggered daily at 6 AM to ensure timely delivery of updates.
    2. Get Subscribers: It retrieves subscriber details, including their email addresses and preferred categories, from a Microsoft Excel workbook.
    3. Unique Categories Extraction: The workflow identifies unique categories from the subscriber list to minimize API calls and optimize performance.
    4. Fetch Latest Templates: For each category, it retrieves the latest 10 templates from the n8n API, sorted by creation date.
    5. AI Summary Generation: Each template's description is summarized using an AI model to create concise and engaging content for the email newsletter.
    6. Filter Relevant Templates: The workflow filters out templates based on each subscriber's interests, ensuring they only receive relevant updates.
    7. Generate HTML Template: A visually appealing HTML email is constructed, incorporating the summarized content and links to the templates.
    8. Send Daily Digest: Finally, the email is sent to each subscriber through Microsoft Outlook, ensuring they receive personalized updates.

    • Customization Guide

    Users can customize this workflow by:
    - Modifying the Schedule: Change the trigger time to suit your audience's preferences.
    - Updating Subscriber List: Edit the Excel sheet to add or remove subscribers and adjust their preferred categories.
    - Adjusting Template Fetching Criteria: Change the number of templates fetched or the sorting criteria as needed.
    - Customizing Email Content: Modify the HTML template to align with your branding and messaging style.
    - Integrating Additional Nodes: Add more nodes to include features like analytics tracking or additional notification methods.