Generate weekly AI automation newsletters with Google Sheets, Tavily, OpenRouter and Gmail
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 30 nodes and runs on a schedule (every week). Along the way it connects Google Sheets, OpenRouter Chat Model and Gmail. It also calls api.tavily.com over HTTP.
How it runs
Trigger: On a schedule (every week).
- Get Topic (Google Sheets): uses Google Sheets
- Manual Topic Exists? (If): checks a condition and branches into true / false
- Merge: merges the data from its input branches
- Reddit Trend Search (HTTP Request): calls api.tavily.com (POST)
- Generate ID (Crypto): hashes or encrypts values
- AI Topic Selector (AI Agent): runs an AI agent, with model: OpenRouter Model (Topic Selector); 1 tool (Think)
- Update With ID (Google Sheets): append or update
- Write Auto Topic to Sheet (Google Sheets): append
- Initial Research (HTTP Request): calls api.tavily.com (POST)
- Get Auto Topic (Google Sheets): uses Google Sheets
…plus 13 more steps. See the full node list below.
Services it uses
HTTP calls to: api.tavily.com
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 (17)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Merge
n8n-nodes-base.merge - Crypto
n8n-nodes-base.crypto - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Split Out
n8n-nodes-base.splitOut - Aggregate
n8n-nodes-base.aggregate - Think Tool
@n8n/n8n-nodes-langchain.toolThink - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This weekly workflow uses Google Sheets as a topic queue, Tavily for web and Reddit research, OpenRouter (OpenAI models) to plan and write a three-section newsletter with citations, then formats it as HTML and sends it to a subscriber list via…