{"product_id":"n8n-linkedin-scheduler-google-sheets-openrouter-telegram","title":"n8n LinkedIn Scheduler: Google Sheets → OpenRouter + Telegram","description":"\u003ch3\u003eSchedule, draft, generate, and publish LinkedIn posts automatically—daily—from your Google Sheets calendar to LinkedIn with Telegram alerts.\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow, \u003cstrong\u003en8n LinkedIn Scheduler: Google Sheets → OpenRouter + Telegram\u003c\/strong\u003e, runs every day at \u003cstrong\u003e09:00\u003c\/strong\u003e to find due, approved posts in your Google Sheets, draft LinkedIn copy with \u003cstrong\u003eOpenRouter\u003c\/strong\u003e, generate a black-and-white image with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and publish to LinkedIn. It also handles approvals and failures via \u003cstrong\u003eTelegram\u003c\/strong\u003e and posts a daily digest with publishing results.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e via cron at \u003cstrong\u003e09:00\u003c\/strong\u003e and reads rows from a Google Sheets post calendar.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters due content\u003c\/strong\u003e by selecting rows that are \u003cstrong\u003eApproved\u003c\/strong\u003e, scheduled for \u003cstrong\u003etoday\u003c\/strong\u003e, and \u003cstrong\u003enot already Published\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts LinkedIn copy\u003c\/strong\u003e using brand guidelines from a separate Google Sheets tab, prompting \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to output structured JSON (with a \u003cstrong\u003efallback model\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates an image\u003c\/strong\u003e with \u003cstrong\u003eOpenAI\u003c\/strong\u003e based on the drafted copy, creates a black-and-white post image, uploads it to \u003cstrong\u003eimgbb\u003c\/strong\u003e, and then hosts it for LinkedIn via the \u003cstrong\u003eupload-post\u003c\/strong\u003e API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes to LinkedIn\u003c\/strong\u003e using \u003cstrong\u003eupload-post\u003c\/strong\u003e, and marks the Google Sheets row as \u003cstrong\u003ePublished\u003c\/strong\u003e on success.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts on errors\u003c\/strong\u003e: if publishing fails, sends an \u003cstrong\u003eadmin alert to Telegram\u003c\/strong\u003e and updates the row status in Google Sheets to \u003cstrong\u003eError\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequests review\u003c\/strong\u003e by sending Telegram messages for rows marked \u003cstrong\u003epending_review\u003c\/strong\u003e, plus a \u003cstrong\u003edaily Telegram digest\u003c\/strong\u003e with the number of published posts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams managing a LinkedIn content calendar in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and needing consistent daily publishing.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want a production-ready n8n workflow with AI drafting, image generation, and status tracking.\u003c\/li\u003e\n  \u003cli\u003eMarketing operators who need \u003cstrong\u003eapproval workflows\u003c\/strong\u003e and \u003cstrong\u003eTelegram visibility\u003c\/strong\u003e when something goes wrong.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/workflow logic\u003c\/strong\u003e: if, filter, telegram, email send, summarize, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Sheets (post calendar + brand guidelines), OpenRouter (structured JSON drafting with fallback), OpenAI (black-and-white image generation), imgbb (HTTP query auth), LinkedIn via \u003cstrong\u003eupload-post\u003c\/strong\u003e, Telegram notifications\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003ePerfect for n8n automation, LinkedIn scheduling, and AI-assisted content workflows that stay controlled, tracked, and alert-driven.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45967622537395,"sku":"N8N-19251","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ZR_Y3K5FjzrgxnhYOOiCn_RcIKxViP.png?v=1788686056","url":"https:\/\/buyflowscripts.com\/products\/n8n-linkedin-scheduler-google-sheets-openrouter-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}