Social Media Content Creator & Publisher
AI-powered weekly social media calendar: enter topics → OpenAI writes captions and generates images → human approves the batch → publishes to Facebook, Instagram, LinkedIn, and Twitter/X on schedule. Logs every post to Google Sheets and stores images on Dropbox for public hosting (required by Instagram).
Steps in this flow
- Topics In (webhook or schedule)
- Guard: Daily Batch
- For each topic
- OpenAI: Generate Caption
- OpenAI: Generate Image
- Dropbox: Save Image From URL
- Wait 8s for Dropbox fetch
- Dropbox: Create Shared Link
- Collect every topic's post
- Write the approval list
- Approve the whole batch before publishing
- For each approved post
- Facebook: Publish Post
- Instagram: Create Media Container
- Instagram: Publish Container
- LinkedIn: Share Post
- Twitter/X: Post Tweet (optional)
- Google Sheets: Append Row
- Notify: Batch Published