πŸ“± Automated news summarizer with GPT-4o + email delivery

⚑ 2,252 views Β· πŸ“± Social Media & Email Marketing

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

Setup Instructions

1. Upload the Spreadsheet

2. Configure Google Sheets Nodes

3. Add API Credentials

4. Activate the Workflow

πŸ” Workflow Logic

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

🧩 Node Descriptions

Node NameDescription
CronTriggers the workflow every 10 minutes.
HTTP Request - NewsAPIFetches top news headlines using NewsAPI.
SetFormats or structures raw news data before processing.
AI AgentSummarizes the news content using OpenAI into 5 bullet points.
Email ListReads recipient email addresses from the β€˜Emails’ Google Spreadsheet.
Send EmailSends the email digest to all recipients using Gmail.

πŸ› οΈ Customization Tips

πŸ“Ž Required Files

File NamePurpose
Emails spreadsheetGoogle Sheet containing the list of email recipients
daily_news.jsonMain n8n workflow file to automate daily news digest

πŸ§ͺ Testing Tips

🏷 Suggested Tags & Categories

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

πŸ”— Nodes Used

Google Sheets, HTTP Request, Gmail, Schedule Trigger, AI Agent, OpenAI Chat Model

πŸ“₯ Import

Download workflow.json and import into n8n: Workflow menu β†’ Import from File

πŸ“– Importing guide Β· πŸ”‘ Credential setup