Social Posting KitBuilt
Social Content – AI Planner (fills Content Queue)
Once a week, AI writes the week's captions and images and adds them to the content queue as pending approval.
Workflow file is complete and imports inactive. No live run is recorded in the files.
Flow
Every Monday 08:00
Manual Test Run
Read Content QueueGoogle Sheets
Need New Posts?
OpenAIOpenAI
xAI GrokxAI
OpenRouterOpenRouter
Validate & Normalize
Generate image
Skip image
Upload to ZernioZernio
Append to Content QueueGoogle Sheets
Planner logGoogle Sheets
TriggerApp stepLogic stepResult
How it works
- Reads the queue to see which topics and time slots are already taken this week.
- Asks the chosen AI provider for the remaining posts as structured JSON.
- Validates each post and always sets it to pending approval, never approved.
- Optionally generates an image and uploads it to Zernio media for a public image URL.
- Appends the drafts to the queue and writes a planner log row.
At a glance
Setup notes
- Add a planner_log tab (time, posts_created, notes) to the content Sheet.
- Create credentials only for the AI provider you'll use, plus Google Sheets and Zernio if images are on.
- Set ai_provider and image_provider in Config.
- Review drafts in the Sheet and set the good ones to approved for the posting workflow.
Good to know
Zernio upload URLs expire after 7 days unless a post uses them, so approve and publish within the week.