{"product_id":"florida-insurance-legal-news-digest-n8n-gpt-4o-outlook","title":"Florida Insurance \u0026 Legal News Digest (n8n + GPT-4o + Outlook)","description":"\u003ch3\u003eGet a daily Florida insurance \u0026amp; legal news digest—automatically emailed to you\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eFlorida Insurance \u0026amp; Legal News Digest (n8n + GPT-4o + Outlook)\u003c\/strong\u003e workflow runs every day at \u003cstrong\u003e4am\u003c\/strong\u003e to pull new Florida-relevant insurance and legal updates from RSS feeds and \u003cstrong\u003eCourtListener\u003c\/strong\u003e, summarize them with OpenAI, and \u003cstrong\u003eemail a polished HTML newsletter\u003c\/strong\u003e to your subscribers via \u003cstrong\u003eMicrosoft Outlook\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules and deduplicates:\u003c\/strong\u003e Executes daily at 4am, loads previously seen article URL hashes from a \u003cstrong\u003eMicrosoft Excel\u003c\/strong\u003e workbook stored on \u003cstrong\u003eSharePoint\u003c\/strong\u003e, then removes anything already processed (and duplicates found in the current run).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects Florida-focused sources:\u003c\/strong\u003e Fetches recent items from \u003cstrong\u003eInsurance Journal\u003c\/strong\u003e, \u003cstrong\u003eClaims Journal\u003c\/strong\u003e, a \u003cstrong\u003eGoogle News RSS search\u003c\/strong\u003e, \u003cstrong\u003eProperty Insurance Coverage Law Blog\u003c\/strong\u003e, and \u003cstrong\u003eCourtListener\u003c\/strong\u003e. Each item is normalized into a consistent article format with a computed URL hash.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSummarizes with OpenAI:\u003c\/strong\u003e Splits the remaining articles into batches of \u003cstrong\u003e30\u003c\/strong\u003e and uses \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e to generate a JSON list of newsletter-ready summaries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds and sends an HTML newsletter:\u003c\/strong\u003e Groups summaries by stream and renders a styled HTML digest, then sends it to recipients from a subscriber list in Microsoft Excel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents resends:\u003c\/strong\u003e Appends the URL hashes of successfully sent articles back into the SharePoint-hosted “seen” table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCompliance and legal teams tracking \u003cstrong\u003eFlorida insurance\u003c\/strong\u003e developments without manual searching.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and automation engineers who want an \u003cstrong\u003en8n news summarization\u003c\/strong\u003e workflow with deduplication and scheduled delivery.\u003c\/li\u003e\n  \u003cli\u003ePractitioners who monitor case updates from \u003cstrong\u003eCourtListener\u003c\/strong\u003e and relevant industry sources.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e if, code, merge, filter, sticky note, http request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e RSS sources (Insurance Journal, Claims Journal, Google News RSS search, Property Insurance Coverage Law Blog) + \u003cstrong\u003eCourtListener\u003c\/strong\u003e, \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e, \u003cstrong\u003eMicrosoft Outlook\u003c\/strong\u003e, and \u003cstrong\u003eMicrosoft Excel on SharePoint\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow behavior:\u003c\/strong\u003e daily 4am run, batch summarization (30 items), HTML rendering, Outlook email dispatch, and SharePoint hash tracking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e Add Microsoft Excel\/SharePoint credentials and update the workbook item ID, worksheet, and table reference used for the subscriber list and “seen” hashes.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45755361657011,"sku":"N8N-17720","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/B5HSXKpjYgoHm60ZOIdZ__uOmVkKAK.png?v=1785661654","url":"https:\/\/buyflowscripts.com\/products\/florida-insurance-legal-news-digest-n8n-gpt-4o-outlook","provider":"N8N Commerce","version":"1.0","type":"link"}