Generate Zen articles and images with OpenRouter, Google Sheets, and Drive
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 63 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets, OpenRouter Chat Model, Google Docs and Google Drive. It also calls openrouter.ai over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Search Spreadsheet (Google Drive): work with file folder
- Search files and folders (Google Drive): work with file folder
- Spreadsheet Found? (If): checks a condition and branches into true / false
- Table Exists? (If): checks a condition and branches into true / false
- Get Folder IDs (Google Sheets): uses Google Sheets
- Set Spreadsheet ID (Found) (Edit Fields (Set)): sets 1 field: spreadsheet_id
- Create Spreadsheet (Google Sheets): work with spreadsheet
- Validate Folder IDs (If): checks a condition and branches into true / false
- Get Published Titles (Google Sheets): uses Google Sheets
- Get Existing Queue Titles (Google Sheets): uses Google Sheets
…plus 47 more steps. See the full node list below.
Services it uses
HTTP calls to: openrouter.ai
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 (16)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Limit
n8n-nodes-base.limit - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Google Docs
n8n-nodes-base.googleDocs - Google Drive
n8n-nodes-base.googleDrive - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Stop and Error
n8n-nodes-base.stopAndError - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Wait
n8n-nodes-base.wait - Merge
n8n-nodes-base.merge
From the author
Quick overview This workflow manages a Yandex Zen content pipeline by generating weekly article topics from Wikipedia categories, then drafting a daily Russian article and up to two illustrations via OpenRouter, saving everything to Google Docs/Drive and…