🏆 Sports Digest — AI-Curated Weekly Newsletter
Automatically aggregates sports news for a configurable topic (e.g., "University of Florida Football" or "Atlanta Falcons") from Reddit, Google News, Yahoo Sports, NCAA.com, and BBC Sport, then curates and delivers a branded HTML email newsletter.
How it works
- Schedule Trigger fires weekly on Friday at 9 AM.
- Config — Topic & Recipients — Set your
topic, subreddit, and recipient_email in one node.
- News Collection — Five sources run in parallel: Reddit, Google News RSS, Yahoo Sports RSS, NCAA.com RSS, and BBC Sport RSS.
- Normalization — Each source is standardized into a uniform schema (title, date, link, source, score, description).
- Article Selection — All sources are merged, deduplicated, filtered to the last 60 days, and 7 articles are randomly selected (≥1 per source where available).
- AI Curation — GPT-4o-mini summarizes each article with a headline, 2-sentence summary, and "why it matters" note. Output is structured JSON.
- Image Generation — Gemini 2.5 Flash generates 2 AI images (for the top 2 articles) in parallel, each uploaded to your WordPress media library.
- HTML Assembly — Images are attached to the first 2 articles; all articles are rendered into a responsive branded HTML email.
- Delivery — Newsletter is sent via Microsoft Outlook to the configured recipient email.
Setup
- Config node: Set
topic, subreddit, and recipient_email before activating.
- Reddit: Configure Reddit OAuth2 credential.
- OpenAI: Add OpenAI API credential — requires GPT-4o-mini access.
- Gemini: Add Google PaLM API credential for Gemini 2.5 Flash image generation.
- WordPress: Add HTTP Basic Auth credential for your WordPress site (for image upload).
- Outlook: Add Microsoft Outlook OAuth2 credential for email delivery.
Customization
- Change the schedule in the trigger node (daily, weekly, etc.).
- Adjust the article count (default: 7) in the Select Articles node.
- Swap the WordPress upload for any image hosting service.
- Update the HTML template in Build Newsletter HTML to match your brand colors.
Community Nodes
⚠️ This workflow uses @n8n/n8n-nodes-langchain.googleGemini for AI image generation. This is a LangChain community node — requires a self-hosted n8n instance.
visit https://iportgpt.com/n8n_assets/sportsdig.html for instructions