Receive Daily Market News from FT.com to your Microsoft outlook inbox n8n Workflow Template

n8n workflow template · 7 nodes · Google Gemini

Receive Daily Market News from FT.com to your Microsoft outlook inbox is a free n8n workflow template that runs on a schedule and works with Google Gemini and Microsoft Outlook. It has 7 nodes, 2 of them AI nodes (Google Gemini Chat Model and AI Agent). The notes inside the workflow say: “This 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.” To run it, you add your own credentials for Google Gemini (PaLM) API and Microsoft Outlook OAuth2.

Download JSON How to import into n8n

At a glance

Trigger: Schedule Trigger (Schedule Trigger)
Nodes: 7
Apps: Google Gemini and Microsoft Outlook
AI nodes: 2
Credentials: 2 types
Category: Email automation

Apps and integrations

Google Gemini
Microsoft Outlook

Node types used

HTML
HTTP Request
Schedule Trigger
Google Gemini Chat Model
Edit Fields (Set)
AI Agent
Microsoft Outlook

How it works

The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.

Financial News Recap Workflow

This 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.

Workflow Steps

Schedule Trigger

Sets the workflow to activate daily at 7:00 AM.

Fetch Financial News

Retrieves financial news content from ft.com using an HTTP Request node.

Extract News Headlines and Sections

Using CSS selectors, this node parses specific sections of the HTML page to gather key headlines and sections

Headline #1, Headline #2
Editor's Picks

Aggregate News Content

Combines all extracted news sections into a single data set, organizing content under relevant categories.

AI Agent for Summarization

A Google Gemini Chat Model generates a structured summary in HTML format, optimized to provide investors with a clear market overview.

Email Dispatch

Sends the summarized content via Microsoft Outlook with a subject "Financial news from today," formatted in HTML for clarity and readability.

Nodes in this workflow

The 7 nodes in file order (sticky notes excluded). Branches and connections determine execution order in n8n:

Extract specific content (HTML)Extract selected headlines, editor's picks, spotlight etc.
Get financial news online (HTTP Request)
Schedule Trigger (Schedule Trigger)
Google Gemini Chat Model (Google Gemini Chat Model)
Gather the elements (Edit Fields (Set))
AI Agent (AI Agent)
Send the summary by e-mail (Microsoft Outlook)

Credentials you need

Google Gemini (PaLM) API – used by Google Gemini Chat Model
Microsoft Outlook OAuth2 – used by Send the summary by e-mail

Configure your own credentials after importing. Create each credential in n8n, then select it in the node.

How to import into n8n

Download the JSON file with the button above.
In n8n, open a new workflow, select the ... menu and choose Import from File. You can also paste the JSON straight into the editor canvas.
Open each node that shows a warning and select or create its credential.
Read the notes on the canvas, test the workflow with sample data, then activate it.

Do you need somewhere to run it? Read our guide to self-hosted n8n.