Unified Social Media Posting

Automation across 5+ platforms simultaneously. Content formatting, scheduling, analytics.

The brief

Content creator was posting the same content to Facebook, Instagram, TikTok, X, LinkedIn, and YouTube Shorts manually — at 15+ minutes per post across all platforms. Wanted automation but every "all-in-one" SaaS tool either cost $50+/mo or required uploading content to their servers (privacy and compliance issue).

Constraint: keep all content + credentials on the owner's own machine. Don't depend on any third-party scheduler.

The approach

Built a single Python orchestrator that knows the quirks of each platform's API + posting requirements (aspect ratios, max video length, hashtag conventions, caption length limits). One uploaded asset, one caption, one set of hashtags — the orchestrator handles per-platform reformatting.

For platforms without a clean API (Instagram, TikTok mainly), used browser automation with persistent session cookies. Headless Chromium under systemd. Cookies refresh themselves; if a session genuinely expires, the orchestrator pauses and notifies via Telegram for manual re-auth.

Scheduled posts go into a SQLite queue with a target timestamp. Cron-driven worker checks every 5 minutes for due posts and processes them. Failed posts retry with exponential backoff (max 3 attempts) before flagging for human review.

Analytics ingestion is the asymmetric value: each platform's API gets polled daily for engagement metrics on prior posts. All metrics roll up to a single dashboard so the owner can see "which post type works on which platform" without logging into 6 different analytics consoles.

Results

• ~15 min/post → ~30 sec/post from the owner's perspective — write once, hit schedule, walk away.
• Zero subscription cost for the automation itself (replaced an $80/mo SaaS tool).
• Cross-platform analytics in one place showed that 60% of long-form video engagement came from one platform that the owner had been deprioritizing — driving a content strategy shift.
• Multi-month uptime with no platform-specific breakage beyond expected session-cookie refreshes.

Tech stack

• Python orchestrator + SQLite queue
• Platform APIs where available (Facebook, LinkedIn, YouTube)
• Headless Chromium + Playwright for Instagram / TikTok where APIs are restricted
• Cron-driven scheduler with retry + backoff
• Daily analytics ingestion + dashboard rollup

What this means for you

If you're posting the same content to 3+ platforms manually, you're spending 5-15 minutes per post on reformatting and uploading. That's 2-5 hours per week most creators don't account for.

The build pays for itself in 1-2 months at most. Bigger win: the analytics rollup usually reveals which platform actually drives your audience growth — most creators are guessing.