{"product_id":"n8n-zen-content-automation-openrouter-articles-images-to-google-sheets-drive","title":"n8n Zen Content Automation: OpenRouter Articles \u0026 Images to Google Sheets\/Drive","description":"\u003ch3\u003eAutomate a complete Yandex Zen content pipeline—topics, AI-written articles, and illustrations—then save everything to Google Sheets \u0026amp; Drive\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow generates weekly Russian article topics from Wikipedia categories, drafts a daily article and up to two images via OpenRouter, and publishes your outputs into Google Docs\/Drive while tracking status in a Google Sheets database. Designed for n8n users and automation engineers who want a reliable, production-style content workflow.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled topic refresh (weekly) or manual run (daily):\u003c\/strong\u003e Runs on demand for daily generation, and on Mondays at 09:00 to refresh the topic queue.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates\/loads your content database in Google Drive:\u003c\/strong\u003e Searches for a Google Sheets file named \u003cem\u003eZen_Content_DB\u003c\/em\u003e. If missing, it creates it with sheets for \u003cem\u003eTopics\u003c\/em\u003e, \u003cem\u003ePublished\u003c\/em\u003e, \u003cem\u003eImages\u003c\/em\u003e, and \u003cem\u003eState\u003c\/em\u003e, plus a \u003cem\u003eZen_Content_Articles\u003c\/em\u003e folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates new topic ideas:\u003c\/strong\u003e Reads existing published\/queued titles from the Topics sheet, pulls a random women-focused Wikipedia category, uses \u003cstrong\u003eOpenRouter (Claude Sonnet)\u003c\/strong\u003e to create unique Russian topic ideas, and appends only non-duplicates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts daily articles from queued topics:\u003c\/strong\u003e Selects one topic where \u003cem\u003estatus = new\u003c\/em\u003e, generates a Russian article with \u003cstrong\u003eOpenRouter (Claude Haiku)\u003c\/strong\u003e, then rewrites it in a second pass to reduce AI-sounding patterns.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves and shares content:\u003c\/strong\u003e Creates a per-article folder in Google Drive, creates a Google Doc, inserts the final article text, and shares the document link publicly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates and uploads illustrations:\u003c\/strong\u003e Uses \u003cstrong\u003eOpenRouter (GPT-5)\u003c\/strong\u003e to extract up to two illustrated scenes and produce English image prompts, then calls \u003cstrong\u003eOpenRouter Images (Gemini image model)\u003c\/strong\u003e to generate images and uploads them to Google Drive.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRun a consistent Yandex Zen publishing cadence without manually planning every topic and draft.\u003c\/li\u003e\n  \u003cli\u003eCentralize editorial workflow data in Google Sheets while storing articles and images in Google Drive.\u003c\/li\u003e\n  \u003cli\u003eUse OpenRouter models for both text drafting and image prompt generation in one automated pipeline.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow logic:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003ewait\u003c\/em\u003e, \u003cem\u003elimit\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExternal services:\u003c\/strong\u003e Wikipedia API, OpenRouter (Claude Sonnet, Claude Haiku, GPT-5), OpenRouter Images (Gemini), Google Sheets, Google Drive, Google Docs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData flow:\u003c\/strong\u003e Topic queue management (Topics\/Published\/State) + per-article Drive folders + public Doc links.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830400147635,"sku":"N8N-18236","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/exOMIMx19AuChEQvoSf0d_WddugDs4.png?v=1786698399","url":"https:\/\/buyflowscripts.com\/products\/n8n-zen-content-automation-openrouter-articles-images-to-google-sheets-drive","provider":"N8N Commerce","version":"1.0","type":"link"}