Automated FT.com Financial News Recap & Email via Google Gemini & Outlook

Overview

This workflow automates the daily email delivery of curated financial news from FT.com to a designated recipient. It activates daily at 7:00 AM, retrieves news content, extracts key headlines and sections using CSS selectors, then uses Google Gemini to generate a structured HTML summary. Finally, it dispatches this summary via Microsoft Outlook.

Key Features

• Scheduled Daily Execution: Triggers automatically every day at 7:00 AM (configurable).
• FT.com News Fetching: Retrieves financial news content specifically from https://www.ft.com/.
• Targeted Content Extraction: Parses specific HTML sections from FT.com to gather headlines, editor's picks, and other news segments using CSS selectors.
• News Aggregation: Combines extracted FT.com news sections into a single dataset for summarization.
• AI-Powered Summarization: Employs Google Gemini to create an HTML-formatted summary, designed to give investors a clear market overview.
• Automated Outlook Email: Sends the news summary as an HTML email using Microsoft Outlook.

• An n8n instance (Cloud or self-hosted).
• Google Gemini API Key (this might be configured in n8n under 'Google PaLM API' credentials depending on your n8n version and node version).
• Microsoft Outlook account credentials (OAuth2 configured in n8n).
• The target news website (https://www.ft.com/) must be accessible and its structure should match the configured CSS selectors for successful scraping.

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure the 'Schedule Trigger' node: Adjust the Trigger At Hour parameter (default is 7 for 7:00 AM) if you need the workflow to run at a different time. Ensure your n8n instance's timezone is correctly set.
4. Configure the 'Get financial news online' (HTTP Request) node:
   • The default URL is https://www.ft.com/. If FT.com changes its URL structure or if you wish to target a different site (requires adjusting selectors), update it here.
5. Configure the 'Extract specific content' (HTML Extract) node:
   • This node uses CSS selectors to extract data from FT.com. If FT.com's website structure changes, or if you modified the URL in the previous step to a different website, these selectors must be updated. Test this node carefully to ensure it extracts the correct information.
6. Configure the 'Google Gemini Chat Model' node:
   • Select or create your Google Gemini (or PaLM) API credential. Ensure it has the necessary permissions and billing enabled on your Google Cloud account.
7. Configure the 'AI Agent' node:
   • Review the System Message. You can customize this prompt to change the AI's summarization style, tone, length, or specific instructions for the HTML email body.
8. Configure the 'Gather the elements' (Set) node:
   • Review the expression for News together. It concatenates the data extracted by the 'Extract specific content' node. If you've changed the CSS selectors or the structure of extracted data, you might need to update this expression to ensure all desired content is passed to the AI for summarization. Note: The default expression in the provided workflow includes placeholders for "Yahoo news" which are not fetched by this workflow; these will be blank unless you add a new data source and update the expression.
9. Configure the 'Send the summary by e-mail' (Microsoft Outlook) node:
   • Select or create your Microsoft Outlook OAuth2 API credential.
   • Enter the recipient email address(es) in the To Recipients field.
   • The Subject and Body Content are pre-filled with expressions. The body uses the AI-generated HTML summary. Adjust as needed.
10. Activate the workflow.