Automated Social Media Scheduler
Overview
System that automatically generates captions with AI from a product sheet or text brief, schedules posts at optimal times for each platform, and publishes automatically on Instagram, Facebook and LinkedIn — without manually touching any app.
social-scheduler.py · Today's queueInstagramFacebookLinkedIn
Social Media Scheduler
Write once · publishes everywhere · automatically
2 published~2,140 reach
Today's schedule
09:00▣
♥ 142 interactions
Published12:30ƒ
♥ 67 interactions
Published15:00in
Scheduled
18:45▣
Queued
20:00ƒ
Queued
Weekly stats
Posts published14
Total reach10,540
Hours saved~6h
Platform split
Instagram38%
Facebook35%
LinkedIn27%
AI caption generation
Captions auto-generated from product info and adapted per platform
Details
The problem
Managing three social platforms consistently requires hours per day: writing captions, finding the best times, manually publishing, monitoring engagement. For a small business, this time taken away from core work is often unsustainable.
The solution
A Python-based system that reads a weekly planning file (CSV or Google Sheets), uses OpenAI to generate the right caption for each platform, optimises publishing time based on historical insights, and publishes automatically via Meta Graph API and LinkedIn API. The entire flow runs on cron with no manual interaction.
How it works
1. Read editorial plan from CSV / Google Sheets
2. Generate caption for Instagram, Facebook and LinkedIn via OpenAI
3. Calculate optimal time per platform
4. Publish via Meta Graph API and LinkedIn API
5. Log result (likes, reach, errors)
6. Weekly engagement report via email
Typical results
From 6–8 hours of weekly social management to under 30 minutes of plan review. Consistent publishing even during busy work periods. Average organic reach increase of 20–30% thanks to time optimisation.