Finance & Insurance News Aggregator with AI Analysis Automatically collect, classify, and analyze financial news from Vietnamese sources with AI-powered expert commentary. Delivers daily HTML email reports. What It Does This workflow automates the entire process of monitoring financial and insurance news: Collects articles from 4 Vietnamese RSS feeds daily Filters content from the last 24 hours Classifies articles using AI (OpenAI GPT) Summarizes top 15 most important articles Adds expert commentary with AI (Groq LLaMA) Saves results to Google Sheets Sends formatted HTML email report Time saved : 2.5 hours/day → 5 minutes/day (95% reduction) How It Works 1. Data Collection (30-60s) Schedule Trigger fires daily at 8:00 AM (GMT+7) RSS Feed Reader fetches from 4 sources with retry logic Filter keeps only articles from last 24 hours Normalize data structure across different RSS formats 2. AI Classification (20-40s) Text Classifier (OpenAI GPT-4.1-nano) identifies finance/insurance content Fallback : Discards non-relevant articles Archive all processed links to Google Sheets 3. AI Analysis (40-80s) AI Agent 1 (OpenAI GPT-4o-mini) selects top 15 most important articles AI Agent 2 (Groq LLaMA 3.1 120B) adds expert commentary with: Specific data/numbers Impact analysis Actionable recommendations 4. Storage & Reporting (10-20s) Google Sheets stores analyzed articles with commentary Code Node formats responsive HTML email (2-column layout) Gmail sends daily report Total execution : 2-3 minutes Setup Requirements Credentials Needed OpenAI API - For classification and summarization Groq API - For expert commentary (FREE, 14k requests/day limit) Google Sheets OAuth2 - For data storage Gmail OAuth2 - For email delivery Configuration Steps Configure RSS Sources Set Node: Update array with your RSS URLs Default sources: - vneconomy.vn/tai-chinh.rss - vnbusiness.vn/rss/tai-chinh.rss - vietnamfinance.vn/bao-hiem.rss - tapchikinhtetaichinh.vn/bao-hiem-ngan-hang.rss Set Google Sheets Document Google Sheets Nodes: - Document ID: Your spreadsheet ID - Sheet names: "Tai_chinh_Bao_hiem", "List" Configure Email Recipients Gmail Node: - To: [email protected] - Subject: Auto-generated with date Adjust AI Prompts (Optional) AI: Summarize Top 15 - Change max articles (15 → 10 or 20) AI: Add Expert Commentary - Adjust comment length (60-120 words) Use Cases Primary Use Case Daily Financial News Monitoring for: Financial analysts Insurance professionals Investment advisors Business development teams Marketing teams tracking industry trends Extended Use Cases Compliance monitoring - Track regulatory changes Competitive intelligence - Monitor competitor news Content curation - Source material for newsletters Market research - Identify emerging trends Client updates - Share relevant news with clients Key Features Automation ✅ Zero manual work - Runs completely automated ✅ Daily schedule - Consistent 8 AM delivery ✅ Error handling - Retry logic for failed RSS fetches ✅ Fallback options - Continues even if some sources fail AI Intelligence ✅ Smart classification - Only relevant finance/insurance articles ✅ Quality summarization - Top 15 most important news ✅ Expert commentary - AI-generated analysis with specific data ✅ Structured output - Consistent JSON format Reporting ✅ Responsive HTML email - Beautiful on desktop and mobile ✅ Two-column layout - Content | Commentary side-by-side ✅ Source links - Direct links to original articles ✅ Timestamp - Vietnam timezone (GMT+7) Cost Efficiency ✅ Groq for free - 0 cost for expert commentary ✅ Optimized tokens - Only send necessary content to AI ✅ Batch processing - Minimize API calls Monthly cost : $35-40 (or $5 if self-hosting n8n) Technical Specifications Performance Execution time : 2-3 minutes/run Throughput : 50-100 articles → 15 analyzed articles Success rate : >99% (with retry logic) Scalability RSS sources : Easily add more (currently 4) Output formats : Email, Sheets (extendable to Slack, Telegram) Languages : Vietnamese (can adapt prompts for English) Error Handling RSS fetch: Retry 2x, continue on fail AI classification: Skip non-matching articles Google Sheets: Rate limit protection Email: Fallback to error notification Customization Tips Change Number of Articles AI Agent 2 prompt: "Chọn TỐI ĐA 15 bài" → "Chọn TỐI ĐA 10 bài" Add RSS Source Configure RSS Sources node: Add URL to array: "https://newsite.com/rss" Switch to Mobile Email Layout Disable: "Format Email (Desktop)" Enable: "Format Email (Mobile)" Change AI Model OpenAI nodes: gpt-4o-mini → gpt-3.5-turbo (cheaper) Groq node: Can switch to OpenAI for potentially better quality Adjust Schedule Daily RSS Trigger: Hour: 8 → Change to any 0-23 Or use cron: "0 8,16 * * *" (8 AM and 4 PM) Cost Breakdown Service Monthly Cost Notes OpenAI API $1-5 Classification + Summarization Groq API $0 FREE (14,400 req/day limit) Google Sheets $0 Free tier sufficient Gmail $0 Free tier sufficient n8n Cloud $20 Or self-host for $0-5 Total $20-25 Can reduce to $1 with optimization Cost Optimization Use Groq for all AI → Save $15-20/month Self-host n8n on $5 VPS → Save $20/month Result : $5/month (87% cost reduction) Limitations & Considerations ⚠️ RSS dependency - Relies on RSS feeds staying available ⚠️ Vietnamese domains - Some may be blocked by n8n whitelist ⚠️ AI accuracy - ~90% classification accuracy (can improve with prompt tuning) ⚠️ Rate limits - OpenAI: 3 req/min, Groq: 14,400 req/day ⚠️ Email limits - Gmail: 500/day (not an issue for daily reports) Version History v1.0 Initial release 4 RSS sources OpenAI + Groq AI analysis Google Sheets storage HTML email reports Support & Documentation 📚 Full documentation : See RSS_Finance_Insurance_Workflow_Guide.md 📦 Cluster descriptions : See Cluster_Descriptions.md 📊 Workflow overview : See Workflow_Overview.md Author : Nguyễn Thiệu Toàn Contact : [email protected] Website : nguyenthieutoan.com Tags news-aggregation rss ai-analysis finance insurance openai groq google-sheets email-automation vietnamese License Personal use. Please contact author for commercial usage rights.