AI-Powered Social Media Automation
An AI "marketing employee" that drafts a themed Facebook post every morning. A person approves it before it publishes.
- Context
- Yuzo Cloud's Facebook Page
- Role
- Sole developer
- Year
- 2026
- Status
- In production
Content queue
Generate now09:42 approved by reviewer
09:43 published to Page ✓
Yuzo Cloud
Draft · Tuesday
Still copying order details from chat into a spreadsheet? Here's a 15-minute automation that does it for you, and never misses a field.
Mockup with sample data. Client screens and figures are withheld.
The problem
Posting consistently takes daily effort that a small business rarely has, while fully automatic AI posting risks publishing something off-brand.
The solution
A scheduled agent drafts every day, and nothing reaches the Page without a person approving it.
Daily scheduled generation
A cron job runs at 9:00 Manila time, picks the day's theme from a weekly content strategy and writes the post plus an image prompt.
Human in the loop
Drafts land in a dashboard to review, edit, approve or reject. Only approved posts can be published.
Publishing via the Graph API
One click publishes to the Facebook Page with a long-lived Page token and stores the post ID and publish time.
Observable and idempotent
Every agent step is written to a log table, and the job skips if today's post already exists.
My responsibilities
- Agent design: weekly content strategy, prompts and time-zone-aware scheduling
- Approval workflow and dashboard
- Facebook app setup, permissions and Page-token exchange
- Database schema, logging and production deployment with a secured cron endpoint
Results
- ✓Running in production with a daily scheduled draft
- ✓Verified end to end: generate, approve, publish to a live Facebook Page
Next case study
Business Analytics & Reporting Systems