Automated Daily Financial News Recap & Email via Gemini and Outlook

Overview

This n8n workflow automates the process of gathering the latest financial news from ft.com, summarizing it using Google Gemini, and delivering a well-structured HTML email recap via Microsoft Outlook. It's designed to run daily, providing timely market insights.

Key Features

• Scheduled Execution: Triggers daily at a configurable time (default 7:00 AM) to fetch the latest news.
• Web Scraping: Retrieves HTML content from ft.com using an HTTP Request node.
• Targeted Content Extraction: Uses CSS selectors in an HTML node to parse and extract specific headlines, editor's picks, and news sections from the ft.com webpage.
• News Aggregation: A Set node ('Gather the elements') combines extracted news. Note: This node is configured to pull data from the ft.com extraction and also includes placeholders/expressions for 'Yahoo news' and data from a node named 'HTML'. These may need adjustment or removal if not applicable to your setup.
• AI-Powered Summarization: Leverages a Google Gemini Chat Model via an AI Agent to generate a concise and informative summary of the aggregated news. The summary is requested in HTML format, suitable for email.
• Automated Email Dispatch: Sends the AI-generated HTML summary via Microsoft Outlook to specified recipients with a subject line "Financial news from today".
• Customizable AI Prompt: The system prompt for the AI Agent can be tailored to refine the summary's style, tone, and focus (e.g., "summarise the financial news... help an investor... write the body of an e-mail using a well structured html format").

• An n8n instance (Cloud or self-hosted).
• Google Gemini API Key (associated with the 'Google Gemini(PaLM) Api account' credential in the workflow).
• Microsoft Outlook account with credentials configured in n8n (e.g., 'Microsoft Outlook account' using OAuth2).

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure the 'Schedule Trigger' node: Adjust the trigger time (default is 7:00 AM daily) as needed.
4. Review 'Get financial news online' node: Ensures the URL (default: https://www.ft.com/) is correct and accessible.
5. Crucial: Update 'Extract specific content' node: The CSS selectors are tailored for ft.com's layout at a specific time. If ft.com changes its website structure, these selectors will need to be updated for the workflow to extract content correctly. Refer to the node's notes: "Extract selected headlines, editor's picks, spotlight etc."
6. Adjust 'Gather the elements' node: This node combines news. It correctly references data from 'Extract specific content' (ft.com news). However, it also includes expressions for 'Yahoo news' (e.g., {{ $json['Headline '] }}, {{ $('HTML').item.json['News #1'] }}) which refer to data sources not defined in this workflow. You may need to remove these parts or adapt the node if you integrate other news sources.
7. Configure 'Google Gemini Chat Model' node: Select your existing 'Google Gemini(PaLM) Api account' credential or create a new one with your API key.
8. Customize 'AI Agent' node (Optional): Modify the 'Text' input or 'System Message' to refine how Google Gemini summarizes the news (e.g., length, style, specific points of focus).
9. Configure 'Send the summary by e-mail' node: Enter the recipient email address(es) in the 'To Recipients' field. Select your existing 'Microsoft Outlook account' credential or create a new one.
10. Activate the workflow.