Automatically collect, classify, and analyze financial news from Vietnamese sources with AI-powered expert commentary. Delivers daily HTML email reports.
This workflow automates the entire process of monitoring financial and insurance news:
Time saved : 2.5 hours/day → 5 minutes/day (95% reduction)
Total execution : 2-3 minutes
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)Daily Financial News Monitoring for:
✅ 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
✅ 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
✅ 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)
✅ 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)
AI Agent 2 prompt:
"Chọn TỐI ĐA 15 bài" → "Chọn TỐI ĐA 10 bài"
Configure RSS Sources node:
Add URL to array: "https://newsite.com/rss"
Disable: "Format Email (Desktop)"
Enable: "Format Email (Mobile)"
OpenAI nodes: gpt-4o-mini → gpt-3.5-turbo (cheaper)
Groq node: Can switch to OpenAI for potentially better quality
Daily RSS Trigger:
Hour: 8 → Change to any 0-23
Or use cron: "0 8,16 * * *" (8 AM and 4 PM)
| 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 |
⚠️ 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)
v1.0
📚 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
news-aggregation rss ai-analysis finance insurance openai groq google-sheets email-automation vietnamese
Personal use. Please contact author for commercial usage rights.
