Send a daily media briefing email with GPT-4.1-mini, NewsAPI, Gmail and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 17 nodes and runs on a schedule (every day). Along the way it connects OpenAI Chat Model, Google Sheets, HTTP Request and Gmail.
How it runs
Trigger: On a schedule (every day).
- Set timeframe to last 2 days (Date & Time): formats or calculates dates
- Format date (Date & Time): formats or calculates dates
- Set user config (Edit Fields (Set)): sets or maps fields
- Fetch news articles (HTTP Request): calls an HTTP API
- Understand number of results (Edit Fields (Set)): sets 4 fields: date, coverageVolume, totalResults…
- Save to Google Sheets (Google Sheets): append
- Get Google Sheets data (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Get historic values from Google Sheets (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 1 tool (Topic deep-dive); memory: Simple Memory
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Merge
n8n-nodes-base.merge - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Date & Time
n8n-nodes-base.dateTime - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Http Request Tool
n8n-nodes-base.httpRequestTool - Gmail
n8n-nodes-base.gmail
From the author
This workflow creates a daily media briefing based on public news sources. It retrieves relevant articles, summarizes key coverage, evaluates sentiment, and compares the current media volume against historical data. If an unusual spike in coverage is…