n8n LinkedIn Scheduler: Google Sheets → OpenRouter + Telegram

Schedule, draft, generate, and publish LinkedIn posts automatically—daily—from your Google Sheets calendar to LinkedIn with Telegram alerts.

This n8n workflow, n8n LinkedIn Scheduler: Google Sheets → OpenRouter + Telegram, runs every day at 09:00 to find due, approved posts in your Google Sheets, draft LinkedIn copy with OpenRouter, generate a black-and-white image with OpenAI, and publish to LinkedIn. It also handles approvals and failures via Telegram and posts a daily digest with publishing results.

What this workflow does

• Runs daily via cron at 09:00 and reads rows from a Google Sheets post calendar.
• Filters due content by selecting rows that are Approved, scheduled for today, and not already Published.
• Drafts LinkedIn copy using brand guidelines from a separate Google Sheets tab, prompting OpenRouter to output structured JSON (with a fallback model).
• Generates an image with OpenAI based on the drafted copy, creates a black-and-white post image, uploads it to imgbb, and then hosts it for LinkedIn via the upload-post API.
• Publishes to LinkedIn using upload-post, and marks the Google Sheets row as Published on success.
• Alerts on errors: if publishing fails, sends an admin alert to Telegram and updates the row status in Google Sheets to Error.
• Requests review by sending Telegram messages for rows marked pending_review, plus a daily Telegram digest with the number of published posts.

Use cases

• SaaS teams managing a LinkedIn content calendar in Google Sheets and needing consistent daily publishing.
• Automation engineers who want a production-ready n8n workflow with AI drafting, image generation, and status tracking.
• Marketing operators who need approval workflows and Telegram visibility when something goes wrong.

Technical details

• n8n nodes/workflow logic: if, filter, telegram, email send, summarize, sticky note
• Integrations: Google Sheets (post calendar + brand guidelines), OpenRouter (structured JSON drafting with fallback), OpenAI (black-and-white image generation), imgbb (HTTP query auth), LinkedIn via upload-post, Telegram notifications

Perfect for n8n automation, LinkedIn scheduling, and AI-assisted content workflows that stay controlled, tracked, and alert-driven.