Workflow: automate with n8n workflow for Schedule Http Create Scheduled
Integrations: html, httpRequest, microsoftOutlook, scheduleTrigger, set, stickyNote

{"meta": {"instanceId": "6045c639951d83c8706b0dd8d6330164bda01fe58f103cedc2c276bf1f9c11f1"}, "nodes": [{"id": "d2a24a9b-9cf3-4de0-82e7-5d858658d4b4", "name": "Extract specific content", "type": "n8n-nodes-base.html", "notes": "Extract selected headlines, editor's picks, spotlight etc.", "position": [800, 340], "parameters": {"options": {"cleanUpText": true}, "operation": "extractHtmlContent", "extractionValues": {"values": [{"key": "Headline #1", "cssSelector": "#site-content > div:nth-child(1) > section > div > div > div.layout-desktop__grid.layout-desktop__grid--span4.layout-desktop__grid--column-start-1.layout-desktop__grid--row-start-1.layout-desktop__grid--with-border.layout--default > div > div > div > div.story-group-stacked__primary-story > div > div > div > div > div.primary-story__teaser"}, {"key": "Headline #2", "cssSelector": "#site-content > div:nth-child(1) > section > div > div > div.layout-desktop__grid.layout-desktop__grid--span6.layout-desktop__grid--column-start-5.layout-desktop__grid--row-start-1.layout-desktop__grid--with-border.layout--default > div > div > div > div > div > div.story-group__article.story-group__article--featured > div > div.featured-story-content > div.headline.js-teaser-headline.headline--scale-5.headline--color-black > a > span"}, {"key": "Editor's Picks", "cssSelector": "#site-content > div:nth-child(1) > section > div > div > div.layout-desktop__grid.layout-desktop__grid--span2.layout-desktop__grid--column-start-11.layout-desktop__grid--row-start-1.layout--default > div"}, {"key": "Top Stories", "cssSelector": "#site-content > div:nth-child(3) > section > div", "skipSelectors": "h2"}, {"key": "Spotlight", "cssSelector": "#site-content > div:nth-child(6) > section", "skipSelectors": "h2"}, {"key": "Various News", "cssSelector": "#site-content > div:nth-child(8) > section", "skipSelectors": "h2"}, {"key": "Europe News", "cssSelector": "#site-content > div:nth-child(13) > section", "skipSelectors": "h2"}]}}, "notesInFlow": true, "typeVersion": 1.2}, {"id": "38af5df2-65ce-4f04-aed3-6f71d81a37df", "name": "Get financial news online", "type": "n8n-nodes-base.httpRequest", "notes": "Url : https://www.ft.com/", "position": [580, 340], "parameters": {"url": "https://www.ft.com/", "options": {}}, "notesInFlow": true, "typeVersion": 4.2}, {"id": "764b2209-bf20-4feb-b000-fa261459a617", "name": "Schedule Trigger", "type": "n8n-nodes-base.scheduleTrigger", "position": [360, 340], "parameters": {"rule": {"interval": [{"triggerAtHour": 7}]}}, "typeVersion": 1.2}, {"id": "96b337ba-6fe7-47ec-8385-58bfc6c789cb", "name": "Google Gemini Chat Model", "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini", "position": [1200, 520], "parameters": {"options": {}}, "credentials": {"googlePalmApi": {"id": "450x4z8bKvomb0tZ", "name": "Google Gemini(PaLM) Api account"}}, "typeVersion": 1}, {"id": "925eabf3-3619-4da2-be2c-bda97c605d4d", "name": "Gather the elements", "type": "n8n-nodes-base.set", "position": [1020, 340], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "5412a5ee-dbbe-4fcc-98a5-6fafc37b94d1", "name": "News together", "type": "string", "value": "=Yahoo news :\n\n{{ $json['Headline '] }};\n\n{{ $('HTML').item.json['News #1'] }};\n\n{{ $('HTML').item.json['News #2'] }};\n\nFinancial times news :\n\n{{ $('Extract specific content').item.json['Headline #1'] }};\n\n{{ $('Extract specific content').item.json['Headline #2'] }};\n\n{{ $('Extract specific content').item.json['Editor\\'s Picks'] }};\n\n{{ $('Extract specific content').item.json['Top Stories'] }};\n\n{{ $('Extract specific content').item.json.Spotlight }};\n\n{{ $('Extract specific content').item.json['Various News'] }};\n\n{{ $('Extract specific content').item.json['Europe News'] }};\n\n"}]}}, "typeVersion": 3.4}, {"id": "5445b14f-25e8-4759-82d4-985961ca7fdd", "name": "AI Agent", "type": "@n8n/n8n-nodes-langchain.agent", "position": [1200, 340], "parameters": {"text": "=Here are the news to summarise :\n\n{{ $json['News together'] }}", "options": {"systemMessage": "You role is to summarise the financial news from today. The summary will help an investor to have a clear view of the market, and to make better choice. \n\nYou will write the body of an e-mail using a well structured html format"}, "promptType": "define"}, "typeVersion": 1.6}, {"id": "30b76eac-d646-44d8-bc41-46aa2d9fe05f", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [-200, 200], "parameters": {"width": 683.6774193548385, "height": 581.4193548387093, "content": "# Financial News Recap Workflow\n\nThis workflow automates the daily email delivery of curated financial news to a designated recipient at 7:00 AM. It extracts relevant financial news articles, structures the content, and sends it in a concise summary format via Microsoft Outlook.\n\n### Workflow Steps\n1. **Schedule Trigger** \n Sets the workflow to activate daily at 7:00 AM.\n2. **Fetch Financial News** \n Retrieves financial news content from [ft.com](https://www.ft.com/) using an HTTP Request node.\n3. **Extract News Headlines and Sections** \n Using CSS selectors, this node parses specific sections of the HTML page to gather key headlines and sections:\n - Headline #1, Headline #2\n - Editor's Picks\n - etc.\n4. **Aggregate News Content** \n Combines all extracted news sections into a single data set, organizing content under relevant categories.\n5. **AI Agent for Summarization** \n A Google Gemini Chat Model generates a structured summary in HTML format, optimized to provide investors with a clear market overview.\n6. **Email Dispatch** \n Sends the summarized content via Microsoft Outlook with a subject \"Financial news from today,\" formatted in HTML for clarity and readability.\n"}, "typeVersion": 1}, {"id": "7f2b6e9a-8b14-4083-a05c-3b76aae601a8", "name": "Send the summary by e-mail", "type": "n8n-nodes-base.microsoftOutlook", "position": [1540, 340], "parameters": {"subject": "Financial news from today", "bodyContent": "=News of the day : \n\n{{ $json.output }}", "toRecipients": "", "additionalFields": {"bodyContentType": "html"}}, "credentials": {"microsoftOutlookOAuth2Api": {"id": "8asOQiRWBGic8ei8", "name": "Microsoft Outlook account"}}, "typeVersion": 2}], "pinData": {}, "connections": {"AI Agent": {"main": [[{"node": "Send the summary by e-mail", "type": "main", "index": 0}]]}, "Schedule Trigger": {"main": [[{"node": "Get financial news online", "type": "main", "index": 0}]]}, "Gather the elements": {"main": [[{"node": "AI Agent", "type": "main", "index": 0}]]}, "Extract specific content": {"main": [[{"node": "Gather the elements", "type": "main", "index": 0}]]}, "Google Gemini Chat Model": {"ai_languageModel": [[{"node": "AI Agent", "type": "ai_languageModel", "index": 0}]]}, "Get financial news online": {"main": [[{"node": "Extract specific content", "type": "main", "index": 0}]]}}}