Automated News Summarizer with GPT-4o + Email Delivery

Description

How it Works

This workflow fetches top news headlines every 10 minutes from NewsAPI, summarizes them using OpenAI's GPT-4o model, and sends a concise email digest to a list of recipients defined in a Google Spreadsheet. It's ideal for anyone who wants to stay updated with the latest news in a short, digestible format.

🎯 Use Case

Professionals who want summarized daily news
Newsletters or internal communication updates
Teams that require contextual summaries of the latest events

Setup Instructions

1. Upload the Spreadsheet
File name: Emails
Column: Email with recipient addresses
2. Configure Google Sheets Nodes
Connect your Google account to:
Email List
Send Email
3. Add API Credentials
NewsAPI Key** → for fetching top headlines
OpenAI API Key** → for summarizing headlines
Gmail Account** → for sending the email digest
4. Activate the Workflow
Once active, the workflow runs every 10 minutes via a cron trigger
Summarized news is sent to the list of emails in the spreadsheet

🔁 Workflow Logic

Trigger: Every 10 minutes via Cron
Fetch News: HTTP request to NewsAPI for top headlines
Summarize: Headlines are passed to OpenAI's GPT-4o for 5-bullet summary
Read Recipients: Google Sheet is used to collect email recipients
Send Email: Summary is formatted and sent via Gmail

🧩 Node Descriptions

| Node Name | Description |
|-----------|-------------|
| Cron | Triggers the workflow every 10 minutes. |
| HTTP Request - NewsAPI | Fetches top news headlines using NewsAPI. |
| Set | Formats or structures raw news data before processing. |
| AI Agent | Summarizes the news content using OpenAI into 5 bullet points. |
| Email List | Reads recipient email addresses from the 'Emails' Google Spreadsheet. |
| Send Email | Sends the email digest to all recipients using Gmail. |

🛠️ Customization Tips

Modify the AI prompt for tone, length, or content type
Send summaries to Slack, Telegram, or Notion instead of Gmail
Adjust cron interval for more/less frequent updates
Change email formatting (HTML vs plain text)

📎 Required Files

| File Name | Purpose |
|-----------|---------|
| Emails spreadsheet | Google Sheet containing the list of email recipients |
| daily_news.json | Main n8n workflow file to automate daily news digest |

🧪 Testing Tips

Add 1–2 test email addresses in your spreadsheet
Temporarily change the Cron node to run every minute for testing
Check email inbox for delivery and formatting
Inspect the execution logs for API errors or formatting issues

🏷 Suggested Tags & Categories

#News #OpenAI #Automation #Email #Digest #Marketing