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

1. 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
   

2. Set Google Sheets Document

   Google Sheets Nodes:
   - Document ID: Your spreadsheet ID
   - Sheet names: "Tai_chinh_Bao_hiem", "List"
   

3. Configure Email Recipients

   Gmail Node:
   - To: [email protected]
   - Subject: Auto-generated with date
   

4. 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

1. Use Groq for all AI → Save $15-20/month
2. Self-host n8n on $5 VPS → Save $20/month
3. 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.