Self-hosted n8n social media scheduler for LinkedIn and X
Daily cron reads approved posts from a Google Sheet, generates variations with OpenAI, publishes to LinkedIn and X, then marks rows Published to avoid duplicates. Discord alert on failures.
Setup steps
- Put approved posts in a Google Sheet
- Daily cron reads unpublished rows
- OpenAI writes variations
- Publish to LinkedIn and X
- Mark rows Published; alert on errors
Steps summarized from the original Reddit source ↗. Use “Copy” to grab them with the tools and source link, or copy an AI prompt.
Try it with AI
Paste this into ChatGPT, Claude or your own agent for step-by-step help. Prompt written by AppToBot from this recipe's data, not by the original author. It keeps drafts for your review and asks before anything is sent or paid.
Help me set up this automation using n8n + OpenAI + Google Sheets: "Self-hosted n8n social media scheduler for LinkedIn and X". Goal: replace Buffer/Hootsuite-style scheduler. How it should work: - Trigger: Daily schedule - Then: Reads approved posts from a Sheet - Then: Writes variations with OpenAI - Then: Publishes to LinkedIn and X - Result: Posts go out; rows marked Published Setup steps (summarized from the original source): 1. Put approved posts in a Google Sheet 2. Daily cron reads unpublished rows 3. OpenAI writes variations 4. Publish to LinkedIn and X 5. Mark rows Published; alert on errors Guide me one step at a time. Ask me for anything you need (accounts, sheet or channel names) before you start. Safety rules: - Build and test with sample data first, and show me a sample result before anything goes live. - Keep anything that goes to other people (emails, posts, replies, record updates) as drafts for my review until I say otherwise. - Never send, post, buy, pay, delete or change records without my approval. - Tell me about any cost (paid plans, API usage) before I'd incur it, and help me set a spending limit. - Keep API keys and passwords out of shared docs and chats. - Privacy: Post drafts go to OpenAI; social account tokens stored in n8n. Based on: https://www.reddit.com/r/automation/comments/1nb10z9/how_i_replaced_my_50month_social_media_scheduler/
Tool names link to each official site (opens in a new tab).
App you replace: Buffer Essentials lists at $5/mo per channel, billed yearly (vendor pricing page, list price as of Oct 2026, checked 2026-10-16). Your saving depends on what the bot costs you; see “Cost after”.
Running cost: API pennies Author reports pennies a month in API calls on self-hosted n8n. Self-hosted No-code How we sort costs
Stack: n8n · OpenAI · Google Sheets
Replace an app: AI bots that replace Buffer
App vs bot, side by side
| Old app / habit | Bot | |
|---|---|---|
| Tool | Buffer/Hootsuite-style scheduler | n8n cron + OpenAI + Google Sheets, posts to LinkedIn and X |
| Monthly cost | About $50/mo (per author) | Pennies/mo in API calls on self-hosted n8n (per author) |
| Setup | None (already in use) | Not reported · Intermediate |
| Your time | Baseline | Not reported |
| Maintenance | Handled by vendor/you as before | Watch platform API changes and token expiry; Discord alert on failures helps. |
| Privacy | Data stays with the app vendor | Post drafts go to OpenAI; social account tokens stored in n8n. |
Full comparison
| Replaces | Buffer/Hootsuite-style scheduler |
|---|---|
| Bot / agent stack | n8n cron + OpenAI + Google Sheets, posts to LinkedIn and X |
| Monthly cost before | About $50/mo (per author) |
| Monthly cost after | Pennies/mo in API calls on self-hosted n8n (per author) |
| Setup time | Not reported |
| Time saved | Not reported |
| Skill level | Intermediate |
| Reliability | 4/5: author reports it ran 'flawlessly for months'; single-author account. |
| Maintenance | Watch platform API changes and token expiry; Discord alert on failures helps. |
| Privacy & data | Post drafts go to OpenAI; social account tokens stored in n8n. |
| Best for | Solo creators posting to 1-2 networks |
| Not for | Teams needing approvals, analytics or many networks |
Pros and cons
Pros
- Big cost cut vs a $50/mo tool
- Sheet-based approval queue
- Duplicate protection
Cons
- Platform APIs (esp. X) change often
- No analytics dashboard like paid tools
Source and evidence
Author reports it ran 'flawlessly for months'.
Read the original Reddit source ↗
“Not reported” means the source doesn't say. We never fill gaps with guesses. Numbers marked “per author” or “vendor claim” are the source's own and weren't independently tested. Source check: Source blocked our fetcher on 2026-10-15; figures carried over from our original read of the source, re-check pending.
Our rating is an editorial opinion based on the public source above, not lab testing. Spot an error? Request a correction.
Plain-text summary (for search and AI assistants)
Self-hosted n8n social media scheduler for LinkedIn and X. Replaces Buffer/Hootsuite-style scheduler with n8n cron + OpenAI + Google Sheets, posts to LinkedIn and X. Cost before: About $50/mo (per author). Cost after: Pennies/mo in API calls on self-hosted n8n (per author). Setup: Not reported, Intermediate. Time saved: Not reported. Reliability 4/5: 4/5: author reports it ran 'flawlessly for months'; single-author account. Best for: Solo creators posting to 1-2 networks. Not for: Teams needing approvals, analytics or many networks. Source: https://www.reddit.com/r/automation/comments/1nb10z9/how_i_replaced_my_50month_social_media_scheduler/
Related recipes
- n8n SEO automation: an AI content pipeline (4/5)
- n8n newsletter automation with Gemini: a self-hosted Mailchimp alternative (2/5)
More: all Marketing recipes · Best AI agents to replace Zapier · n8n vs Make: AI agent recipes compared · AI bots that replace Buffer
Questions, corrections or ideas?
Spotted an error, want a recipe covered, or have a partnership idea? Send us a message and we'll get back to you.
Starting your own newsletter? Try beehiiv ↗
What is beehiiv?
beehiiv is a newsletter platform: you write and send emails, host a newsletter website, and grow and monetize a list from one place. We've used it for our own newsletter.
beehiiv says (vendor claims, not tested by us):
- Free plan with up to 2,500 subscribers and unlimited sends
- Built-in website, recommendation network and analytics
- 0% cut of paid subscription revenue (Stripe fees apply)
Good for: starting or growing an email newsletter. Not ideal for: email automations or removing beehiiv branding on a $0 budget (those need Lite or Pro).
Free plan: $0, no card needed. Paid plans from $49/mo billed annually (Lite, up to 1,000 subscribers). People who sign up through our link get a 14-day trial plus 20% off their first 3 months, per beehiiv's partner page. Facts as of Oct 2026, from beehiiv's own website. More about beehiiv →