Automated News Summarizer with GPT-4o + Email Delivery
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