LLM Daily Financial News Summaries via AI for Investors

This workflow automates daily financial news summaries from the Financial Times, delivering investor-focused HTML emails. Key nodes include Schedule Trigger (runs at 7 AM UTC), Set (adds metadata), HTTP Request (fetches news), HTML (extracts content), Condition (validates data), Agent (summarizes using Google Gemini), and Microsoft Outlook (sends emails). It uses the Financial Times website and Google Gemini API for content extraction and AI summarization, ensuring professional, concise summaries.\n\nSetup requirements and configuration: Install n8n from n8n.io (self-hosted) or sign up at cloud.n8n.io. Obtain API credentials: Google Gemini key from ai.google.dev and Microsoft Outlook OAuth2 from developer.microsoft.com. Import the JSON workflow in n8n. Configure the HTTP Request node with the Financial Times URL (https://www.ft.com/). Set up Microsoft Outlook credentials in the ‘Credentials’ section, ensuring OAuth2 token access. Add environment variables GOOGLE_GEMINI_API_KEY and MICROSOFT_OUTLOOK_OAUTH2_TOKEN. Create a recipient email list in the Microsoft Outlook node. Ensure internet access for API calls and website fetching. No webhook setup is required as the workflow uses a daily schedule trigger.\n\nTesting and deployment steps: Activate the workflow to start the daily schedule. Verify the HTTP Request node fetches Financial Times content by checking for primary/secondary headlines in logs. Ensure the HTML node extracts at least three sections (e.g., editors_picks, top_stories). Validate Google Gemini’s summary output (minimum 100 characters) for key market insights and sector mentions. Test email delivery by confirming receipt in the Outlook recipient’s inbox with proper HTML formatting. Check error handling for failed fetches, expecting “fetch_or_processing_error” in logs if the Financial Times site is unreachable. Monitor for “summary-length” validation errors if the AI output is too short. Confirm the email includes a branded footer and timestamp. Review logs for issues like ‘Google Gemini API failure’ or ‘Outlook authentication error.’ Ensure the success response logs confirm email delivery with metadata, maintaining consistent daily execution.