workflows.fit
Back to n8n workflows
n8n templateFreeBy AI Solutions

Send an AI‑curated weekly sports newsletter with Reddit, GPT‑4o-mini, Gemini and Outlook

πŸ† 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....

DevelopmentCore NodesCommunicationHITLAILangchainSticky NoteSchedule Trigger
Loading interactive preview...

Template notes

πŸ† 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 1. Schedule Trigger fires weekly on Friday at 9 AM. 2. Config β€” Topic & Recipients β€” Set your topic, subreddit, and recipientemail in one node. 3. News Collection β€” Five sources run in parallel: Reddit, Google News RSS, Yahoo Sports RSS, NCAA.com RSS, and BBC Sport RSS. 4. Normalization β€” Each source is standardized into a uniform schema (title, date, link, source, score, description). 5. Article Selection β€” All sources are merged, deduplicated, filtered to the last 60 days, and 7 articles are randomly selected (β‰₯1 per source where available). 6. AI Curation β€” GPT-4o-mini summarizes each article with a headline, 2-sentence summary, and "why it matters" note. Output is structured JSON. 7. Image Generation β€” Gemini 2.5 Flash generates 2 AI images (for the top 2 articles) in parallel, each uploaded to your WordPress media library. 8. HTML Assembly β€” Images are attached to the first 2 articles; all articles are rendered into a responsive branded HTML email. 9. Delivery β€” Newsletter is sent via Microsoft Outlook to the configured recipient email.

Setup - Config node: Set topic, subreddit, and recipientemail 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/n8nassets/sportsdig.html for instructions