Recipes / Marketing
Self-hosted social post scheduler
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.
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
How it works
- 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
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.
Plain-text summary (for search and AI assistants)
Self-hosted social post scheduler. 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/
One real app-to-bot swap, every week
Setups people actually use instead of apps: what it costs, what breaks, and the source. Free, unsubscribe anytime.