n8n

How to Automate Outlook Investor News Summary?

Start the day with a clear market brief in your inbox. At 7:00 AM, a daily run collects key finance news and turns it into a short email for investors and managers. It is built for teams that want fast updates without reading full sites.

A schedule node kicks off each morning. The flow calls the homepage of ft.com with an HTTP Request and downloads the page. An HTML node uses CSS selectors and clean up to pull headlines and sections. A Set node groups the items into one field. An AI Agent powered by Google Gemini writes an HTML summary with simple sections that are easy to scan. Microsoft Outlook then sends the message with the subject Financial news from today.

You need a Google Gemini API key and a Microsoft Outlook account. Adjust the time if your team needs a different send window and update CSS selectors if the site changes its layout. Most teams cut morning news scanning from 30 minutes to under 5 minutes and get a steady format every day. Great for finance teams, advisors, and leaders who make market based choices.

What are the key features?

  • Daily schedule runs at 7:00 AM to start the job on time.
  • HTTP Request pulls the ft.com homepage for fresh market stories.
  • HTML parser uses CSS selectors with clean up to capture headlines and sections.
  • Set node combines all extracted items into one field for easy prompting.
  • AI Agent with Google Gemini creates a clean HTML summary for investors.
  • System prompt guides tone and structure so the brief is clear and useful.
  • Microsoft Outlook sends an HTML email with the subject Financial news from today.

What are the benefits?

  • Reduce manual news scanning from 30 minutes to 3 minutes each morning
  • Automate 100 percent of the daily email prep and send
  • Deliver the brief at 7:00 AM without manual steps
  • Connect Google Gemini and Microsoft Outlook in one flow
  • Improve consistency of market notes by 90 percent

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Gemini and Microsoft Outlook. See the Tools Required section above for links to create accounts with these services.
  3. Open the Google Gemini Chat Model node. In the Credential to connect with menu, click Create new credential. Follow the on screen steps and paste your API key from the Google AI website. Name the credential clearly, for example Gemini Prod.
  4. Open the Microsoft Outlook node. In the Credential to connect with menu, click Create new credential. Sign in to your Microsoft account and approve email send permissions. Save the credential with a clear name.
  5. Open the Schedule Trigger node and set the time to 7:00. Pick the correct timezone for your team if needed.
  6. Open the HTTP Request node and confirm Method is GET and URL is https://www.ft.com/. Click Execute node to confirm the page loads.
  7. Open the HTML node and review the CSS selectors in Extraction values. Keep Clean up text enabled. Execute the node and check that headline fields contain text. If empty, update selectors to match the current page layout.
  8. Open the Set node and confirm the News together field builds from the HTML outputs. Use the preview to make sure the text from each section appears in order.
  9. Open the AI Agent node. Make sure the Google Gemini model is selected as the language model. Review the system message so the summary suits investors. Run the node to preview the HTML output.
  10. Open the Microsoft Outlook node. Add your recipient emails in the To field. Confirm Subject is Financial news from today and Body content uses the output field. Additional fields should set Body content type to html. Send a test email to yourself.
  11. Activate the workflow. Check the next scheduled run and review the email. If the email is empty, confirm the AI Agent produced output and that the mapping points to the correct field.
  12. Troubleshooting: If selectors fail, refresh them in the HTML node. If Gemini returns errors, check API key validity and quota. If Outlook fails to send, reauthorize the credential and confirm mailbox permissions.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Gemini

Sign up

Free tier: $0 via Gemini API; e.g., Gemini 2.5 Flash-Lite free limits 1,000 requests/day (15 RPM, 250k TPM). Paid from $0.10/1M input tokens and $0.40/1M output tokens.

Microsoft Outlook

Sign up

Exchange Online (Plan 1): $4.00 user / mo (annual billing)

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.