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:
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