Send a personalized daily digest to each subscriber based on the topics they care about. Great for marketing teams, product ops, or community managers who want a quick, clean summary delivered by email.

A scheduled run reads your subscriber list from Microsoft Excel, extracts unique categories to cut API calls, and fetches the latest items per category with an HTTP request. Each item gets a short AI summary using OpenAI for easy reading. The flow then filters content per subscriber, removes duplicates seen in past sends, and skips email if there is nothing new. It builds a tidy HTML email and sends it through Microsoft Outlook.

Setup is simple: an Excel sheet with name, email, and comma separated categories, plus credentials for Excel, Outlook, and OpenAI. Expect strong time savings vs manual curation and fewer API requests thanks to fetching categories once. Use it for recurring roundups, new release bulletins, or curated content by segment. Results are timely emails that match each reader’s interests.

• Daily schedule trigger runs at a set hour to deliver on time
• Reads subscriber rows from a Microsoft Excel worksheet with name, email and categories
• Builds a unique category list to avoid repeated API calls and save resources
• Fetches the latest 10 items per category using the HTTP Request node with query parameters
• Summarizes each item into one or two sentences using an OpenAI chat model
• Filters items per subscriber and removes duplicates seen in previous runs
• Generates a clean HTML email with category sections and links
• Sends personalized emails through Microsoft Outlook and skips sending if nothing is new

• Reduce manual newsletter building from 2 hours to 10 minutes
• Cut API calls by up to 80 percent by fetching unique categories once
• Eliminate duplicate sends with per subscriber dedupe across executions
• Scale to hundreds of subscribers without extra manual work
• Improve content relevance by matching categories to each reader
• Connect Excel, OpenAI and Outlook in one repeatable workflow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Microsoft Excel, Microsoft Outlook and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, connect Microsoft Excel: double click the Get Subscribers node, choose Credential to connect with, click Create new credential, then follow the on screen steps for OAuth2.
4. Select the workbook and worksheet in the Get Subscribers node. Ensure columns are name, email and categories. Enter categories as a comma separated list.
5. Open the Schedule Trigger node and set the time you want the digest to run. Confirm your n8n timezone settings match your preference.
6. Test the HTTP data pull: run the Categories to Items and Fetch Latest 10 per Category nodes for one category and confirm the response includes a data array with items.
7. Connect OpenAI: double click the OpenAI Chat Model node, create a new credential, paste your API key from your OpenAI account, and select the model. Run the Workflow Summarizer node to preview a summary.
8. Connect Microsoft Outlook: open the Send Daily Digest node, create a new credential, sign in with the sender account, and select the From address. Send a test email to yourself.
9. Review the Remove Already Seen node. The dedupe key uses the subscriber name and item id. Clear past executions if you want to resend items for testing.
10. Customize the Generate HTML Template node to match your brand. Execute it once with sample data to preview the email body.
11. Run the full workflow once. In the execution view, check Has New Workflows to see if the send branch or the skip branch ran. Adjust categories or rows if no items are found.
12. Troubleshoot common issues: ensure Excel categories match available categories, confirm Outlook has send permission, and keep the Fetch Latest step set to execute once to avoid extra API calls.