Send a daily AI news digest using Google News, GPT-4o-mini, Sheets and Gmail

Description

Add your news topics to a Google Sheet once — with keywords, article limits, and an Active toggle — and every morning at 7AM a personalized news digest lands in your inbox automatically. The workflow fetches fresh articles from Google News for each active topic, parses the RSS feed to extract titles, sources, and timestamps, and uses GPT-4o-mini to write a clear 3-sentence summary per article. All summaries are grouped by topic, assembled into a styled HTML email with dark section headers and article cards, sent to your inbox via Gmail, and logged to a Digest Log sheet with topic count, article count, and sent time. Built for anyone who wants a personalized daily news briefing without manually visiting news sites or curating articles each morning.

---

What This Workflow Does

- Reads active topics from Google Sheets and skips paused ones — You control which topics appear in your digest by setting Active to TRUE or FALSE — no need to delete rows to pause a topic - Fetches fresh articles from Google News RSS per topic — Each topic's keywords are used to build a live Google News RSS query so you always get today's articles - Respects per-topic article limits — Each row in your Topics sheet has a Max Articles column so you can get 5 articles for important topics and 2 for lower-priority ones - Skips topics with no results today — If Google News returns nothing for a topic on a given day, that topic is silently skipped rather than breaking the workflow - Summarizes each article in 3 plain sentences — GPT-4o-mini reads the article title and description and writes a factual, no-bullet summary so you can scan the digest quickly - Groups all summaries into one styled HTML email — Articles are organized by topic with dark headers, article cards, source attribution, and time-ago labels — all ready to read in any email client - Logs every digest run to Google Sheets — Date, topics count, articles found, and sent time are saved in a Digest Log tab so you can track your daily coverage

---

Setup Requirements

Tools Needed - n8n instance (self-hosted or cloud) - Google Sheets (two tabs: Topics and Digest Log) - OpenAI account with GPT-4o-mini API access - Gmail account