Sports Digest Newsletter — AI Solutions, Inc.

Who It's For

🏟️

Sports Organizations

Keep fans, staff, and stakeholders up to date with zero manual effort.

📰

Content Teams

Automate your weekly sports digest and free up time for deeper stories.

🎓

Athletic Departments

Aggregate news across college sports programs automatically.

⚙️

n8n Builders

A production-grade reference workflow combining RSS, AI, and email delivery.

How It Works

Schedule Trigger

Fires automatically every Friday at 9 AM. Fully configurable — change to daily, bi-weekly, or any schedule.

Topic Configuration

A single Config Set node defines your topic, subreddit, and recipient_email. All downstream nodes reference these values — change them in one place.

Parallel News Collection (5 Sources)

Simultaneously fetches up to 25 posts from Reddit, Google News RSS, Yahoo Sports RSS, NCAA.com RSS, and BBC Sport RSS — all running in parallel for speed.

Normalize & Deduplicate

Each source feed is standardized to a uniform schema (title, date, link, source, score, description). Items are merged, deduplicated by URL, and filtered to the last 60 days.

Article Selection

7 articles are randomly selected with at least 1 guaranteed from each source where available — ensuring diverse coverage every issue.

AI Curation with GPT-4o-mini

Each article gets an AI-written headline, 2-sentence summary, and a "why it matters" relevance note — tailored to your configured topic. Output is structured JSON.

Gemini Image Generation

Gemini 2.5 Flash generates 2 AI images (for the top 2 articles) in parallel. Each image is uploaded to your WordPress media library automatically.

HTML Newsletter Assembly

Images are attached to the first 2 articles. All 7 articles are rendered into a fully responsive, branded HTML email with configurable colors and logo.

Email Delivery via Outlook

The completed newsletter is sent via Microsoft Outlook to the configured recipient. Easily swapped for Gmail or SMTP nodes.

Requirements

n8n Instance

Self-hosted required for community nodes (Gemini image generation).

Reddit OAuth2

Reddit API app credentials (free) for fetching subreddit posts.

OpenAI API

GPT-4o-mini access for article summarization.

Google PaLM API

Gemini 2.5 Flash image model access for AI image generation.

WordPress Site

HTTP Basic Auth credential for media library uploads.

Microsoft Outlook

OAuth2 credential for email delivery. Swappable with Gmail.

⚠️ Community Node: This workflow uses @n8n/n8n-nodes-langchain.googleGemini for AI image generation. This is a LangChain community node and requires a self-hosted n8n instance. If your instance does not have this node, you can skip the image generation steps or replace them with DALL-E via the standard OpenAI node.

How to Set Up

1

Import the workflow JSON into your n8n instance via Workflows → Import from File.
2

Open the Config — Topic & Recipients Set node and enter your topic (e.g., "University of Florida Football"), subreddit (e.g., "FloridaGators"), and recipient_email.
3

Connect your Reddit OAuth2 credential to the Fetch — Reddit Posts node.
4

Connect your OpenAI API credential to the LLM — GPT-4o-mini node.
5

Connect your Google PaLM API (Gemini) credential to both Gemini image generation nodes.
6

Update the WordPress URL in the WP — Upload Image HTTP node to your site's API endpoint, and connect your WordPress HTTP Basic Auth credential.
7

Connect your Microsoft Outlook OAuth2 credential to the Outlook — Send Newsletter node (or swap with Gmail).
8

Customize branding variables (colors, logo URL, footer text) in the Build — Newsletter HTML Code node.
9

Run a manual test execution to verify all connections, then activate the workflow for weekly delivery.

How to Customize

Change the schedule in the Schedule Trigger node — daily, bi-weekly, monthly, or any cron pattern.
Adjust the article count from 7 by editing the selected.length < 7 threshold in Select — 7 Articles.
Add or remove news sources — the Merge node supports up to 10 inputs. Normalize each new source with a Code node using the same output schema.
Replace the Outlook node with Gmail, SMTP, or any other email node — the HTML body expression is the same.
Skip image generation entirely by removing the Gemini nodes and the WP upload chain — connect AI — Summarize Articles directly to Attach — Images to Articles.
Update brand colors, logo URL, and footer text in the Build — Newsletter HTML Code node — all branding variables are grouped at the top of the script.
Change the date window from 60 days by editing the cutoffDate calculation in Select — 7 Articles.
Swap the subscriber source — replace a static recipient with a loop over rows from a Google Sheet, Excel file, or CRM for bulk delivery.

AI-Curated Weekly Sports Email — No Manual Curation Required