📈 Receive Daily Market News from FT.com to your Microsoft outlook inbox
Receive a daily, personalized summary of financial news directly in your Microsoft Outlook inbox with this automated workflow. This n8n automation connects a Schedule Trigger to regularly fetch the latest financial news from FT.com using an HTTP Request node. The Extract Specific Content node then isolates key articles and information, which is passed to an AI Agent powered by the Google Gemini Chat Model. This AI Agent intelligently processes the raw news, generating a concise and relevant summary tailored to your interests, before the Microsoft Outlook node dispatches this summary to your designated email address. This workflow is ideal for financial professionals, investors, or anyone needing to stay informed about market trends without sifting through countless articles, saving significant time and effort by delivering actionable insights directly to their inbox every morning.
Workflow JSON
{"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": "", "name": "[Your googlePalmApi]"}}, "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": "", "name": "[Your microsoftOutlookOAuth2Api]"}}, "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}]]}}}How to Import This Workflow
- 1Copy the workflow JSON above using the Copy Workflow JSON button.
- 2Open your n8n instance and go to Workflows.
- 3Click Import from JSON and paste the copied workflow.
Don't have an n8n instance? Start your free trial at n8nautomation.cloud
Related Templates
Send specific PDF attachments from Gmail to Google Drive using OpenAI
Automatically extract and categorize specific PDF attachments from incoming Gmail emails and upload them to designated Google Drive folders based on their content, leveraging OpenAI's advanced text analysis capabilities. This marketing workflow begins with the Gmail trigger "On email received," which then checks if the email "Has attachments?" If attachments are present, the workflow iterates through them, identifying if each is a PDF. For each identified PDF, the "Read PDF" node extracts its textual content. This content is then evaluated by the "Is text within token limit?" node to ensure it's suitable for OpenAI processing. If within limits, the "OpenAI matches PDF textual content" node analyzes the text against predefined criteria. Based on whether the PDF is "matched" by OpenAI, the "Upload file to folder" node in Google Drive stores the relevant PDFs, while unmatched or non-PDF attachments are handled accordingly. This workflow is ideal for marketing teams needing to automatically sort client contracts, campaign reports, or specific vendor invoices received via email, ensuring critical documents are filed correctly without manual intervention. It significantly reduces the time spent on document organization and improves data accessibility, allowing teams to focus on strategic marketing initiatives rather than administrative tasks.
Auto categorize wordpress template
Automatically categorize your WordPress posts with the power of AI. This workflow connects your WordPress site with OpenAI's advanced language models to intelligently analyze your content and assign appropriate categories. When you manually trigger this workflow, it first retrieves all your WordPress posts using the "Get All Wordpress Posts" node. This data then flows into an AI Agent, which leverages the "OpenAI Chat Model" to understand the context and content of each post. Based on this analysis, the AI Agent then interacts with your WordPress site to update the categories of your posts, streamlining your content management. This is incredibly useful for bloggers, content marketers, and website administrators who manage large volumes of content and want to ensure their posts are consistently and accurately categorized without manual effort. It saves significant time and reduces the potential for human error in content organization, making your website more navigable and improving SEO.
Effortless Email Management with AI
Automate your email management by intelligently processing incoming messages, summarizing their content, and drafting personalized replies with AI. This powerful workflow connects your Gmail inbox via an IMAP trigger to a Text Classifier that categorizes emails, then uses OpenAI for summarization and drafting responses, and Qdrant for vector storage of relevant documents from Google Drive. It’s ideal for marketing teams, customer support, or busy professionals who need to efficiently handle high volumes of correspondence, saving significant time on reading, understanding, and responding to emails by leveraging AI to streamline communication and ensure timely, relevant replies. The system also allows for reviewing AI-generated drafts before sending, ensuring quality control while drastically reducing manual effort.