Send Florida insurance and legal news digest with GPT-4o-mini and Outlook
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 27 nodes and runs on a schedule (every day at 04:00). Along the way it connects Microsoft Excel 365, OpenAI Chat Model and Microsoft Outlook. It also calls courtlistener.com over HTTP.
How it runs
Trigger: On a schedule (every day at 04:00).
- Load Seen Hashes (Microsoft Excel 365): get rows (table)
- Build Seen Hash Set (Code): runs custom JavaScript code
- Fetch Insurance Journal Feed (RSS Read): reads an RSS feed
- Fetch Claims Journal Feed (RSS Read): reads an RSS feed
- Fetch Google News Feed (RSS Read): reads an RSS feed
- Fetch Property Insurance Blog Feed (RSS Read): reads an RSS feed
- Fetch CourtListener Data (HTTP Request): calls courtlistener.com
- Normalize Insurance Journal Data (Code): runs custom JavaScript code
- Normalize Claims Journal Data (Code): runs custom JavaScript code
- Normalize Google News Data (Code): runs custom JavaScript code
…plus 15 more steps. See the full node list below.
Services it uses
HTTP calls to: courtlistener.com
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 (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - RSS Read
n8n-nodes-base.rssFeedRead - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Microsoft Outlook
n8n-nodes-base.microsoftOutlook
From the author
Quick overview This workflow runs daily at 4am to compile Florida insurance and legal news from RSS feeds and CourtListener, summarizes new items with OpenAI, builds an HTML digest, emails it to subscribers via Microsoft Outlook, and records sent-article…