About this recipe
A recipe for 📈 Receive Daily Market News From Ft.com To Your Microsoft Outlook Inbox
Recipe Template
{
"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
}
]
]
}
}
}How to Use an n8n Template
1
Create a New Workflow
Click "New Workflow" in your n8n dashboard to get started.
2
Copy & Paste Template
First, copy this template:
Click here to copy the JSON
.
Then, in n8n, click the three dots (···) → "Import from file" and paste the JSON code.
3
Customize the Nodes
Go through each node in the workflow to update inputs like spreadsheet IDs, email addresses, or message content. Adjust field mappings to match your data.
4
Grant Access
For nodes that connect to external apps (like Google Sheets or Slack), you'll need to grant access. Connect your accounts using OAuth or an API key and save the credentials in the node.
5
Test It
Run the workflow by clicking "Execute Node" for each step or "Run Once" for the whole thing. Check the right sidebar to inspect data and debug any errors (they'll show up in red).
6
Activate Workflow
Once everything works as expected, click the "Activate" toggle to turn your workflow on. You're all set!