When should you use it?
- You plan posts in a spreadsheet
- Design and captioning eat hours
- You want one approval point
Not for: Brands that need custom photography; Regulated claims without legal review
What do you need, and what do you get?
You need
- Content sheet
- Brand rules
- Image tool
- Scheduler account
You get
- A drafted caption plus image for each row
- Approval message
- Scheduled post
How does it work, step by step?
- Structure the sheetColumns for topic, platform, key message, link and status.
- GenerateWrite a caption and image from the row and brand rules.
- Store and write backSave the image and write links back to the row.
- Approve in chatSend a preview to a channel; only approved rows continue.
- ScheduleQueue the post and set the row to scheduled.
The prompt
Our own prompt, inspired by u/willruzMtl on r/automation and written to work in Make and ChatGPT. Values in lime are placeholders.
Fill in the blanks (optional; the copied prompt uses your values)
Write a {platform} caption from this row: topic {topic}, message {message}, link {link}. Brand rules: {rules}. Under {max_chars} characters, one call to action. Also write an image prompt with no text in the image. Do not add claims not in the row.
Inspired by u/willruzMtl on r/automation: I built an automation that writes, designs and posts social content from a Google Sheet in under two minutes. The prompt above is written by playbooks.bot in our own words; nothing from the original is quoted.
What can go wrong?
- Generated images may include text errors; check them.
- Approval by silence is not approval.
Our take
The flow is simple and that is its strength: a sheet everyone understands, one approval point, and a scheduler. Keep approval mandatory and add a check for broken or garbled text in generated images, which is the most common embarrassment. Structure columns for topic, offer, link and status. Never skip approval for paid or brand accounts. Review on mobile preview sizes. Keep a deny list of claims and competitor names. Rotate creative so the same image does not spam followers. Log who approved each row. Pause the flow if the image model starts inserting unreadable text. Prefer brand templates over fully freeform generations for anything customer-facing. Write the caption and image URLs into the sheet first, then approve in chat, and only then schedule. Structure the sheet with topic, offer, link, asset URLs and status columns everyone on the team can read. Generate assets, save them, update those URL cells, get chat approval, and only then hand the row to the scheduler.
Where the time goes back: Planning, writing and design collapse into filling a row and clicking approve.
FAQ
Can it post without approval?
Which image tool?
Source and credit
Inspired by u/willruzMtl on r/automation. We describe the idea in our own words, link to the original, and wrote the prompt ourselves; nothing is quoted.
- Inspired by
- I built an automation that writes, designs and posts social content from a Google Sheet in under two minutes
- Creator
- u/willruzMtl on r/automation
- Published on
- Original date
- Jun 19, 2025
- License
- Not openly licensed (the poster keeps all rights), so we quote nothing and link to the original
- Originally for
- Make
- AI dry run
- Oct 23, 2026: passed. Dry-run tested by our AI test agent on sample input. PASS: Gates held on desk check; no live sends or purchases.
AI dry run on sample data; not run with live connected accounts. The playbooks.bot test agent filled the prompt with synthetic inputs, produced the output and checked it against the page's stated outputs and guardrails. - Verified
- Oct 23, 2026: source link resolves to the original, the credited creator published it, our excerpt or prompt matches it, and the license allows our use.
Are you the creator? Claim or correct this page.