← Back to library

Turn one sheet row into an approved social post

u/willruzMtl made a no-code flow where one Google Sheets row becomes a published post: a caption and matching image are generated, stored, written back to the sheet, sent to team chat for approval, then scheduled through a posting tool. We keep the row-to-post flow with the approval step required.

  • OutcomeGenerate a caption and image from a spreadsheet row, write both back, ask for approval in team chat, then schedule the post.
  • SetupUnder an hour
  • LevelIntermediate
  • Creditu/willruzMtl on r/automation
View original
Works with
MakeChatGPT

Published Oct 23, 2026Updated Oct 23, 2026AI dry run on sample input: passed Oct 23, 2026Source verified Oct 23, 2026

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?

  1. Structure the sheetColumns for topic, platform, key message, link and status.
  2. GenerateWrite a caption and image from the row and brand rules.
  3. Store and write backSave the image and write links back to the row.
  4. Approve in chatSend a preview to a channel; only approved rows continue.
  5. 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)

Prompt6 variables
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?
We do not recommend it.
Which image tool?
Any; keep it swappable.

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
Reddit
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.

More in Marketing

All 97 Marketing playbooks →

Related playbooks

MarketingWorkflow✓ AI dry run

Get fixes for pages that lost Google traffic last month

Every Monday, the pages that lost clicks and rankings in Search Console arrive in Slack with the reason, three new title ideas and the one missing section to add.

Credit: Shun Nakayama

Under an hour
MarketingWorkflow✓ AI dry run

Send a topic by Telegram and get a researched post

Message a topic to a bot and get a researched infographic or slideshow drafted for your social channels, then approve it.

Credit: u/Minute-Neck486 on r/n8n

Under an hour
MarketingWorkflow✓ AI dry run

Split SEO article writing into stages with a fact-check

Run research, outline, draft, fact-check and polish as separate agent stages so made-up claims are caught before publishing.

Credit: u/GonkDroidEnergy on r/Agentic_SEO

An afternoon+
MarketingWorkflow✓ AI dry run

Keep AI steps in an n8n content workflow from breaking

Build an n8n article pipeline from small single-purpose AI steps (brief, outline, section writing, page metadata), require structured JSON from each, check every output before it moves on, retry and alert on failures, publish as a draft for a human look, and run the lighter steps on a less expensive model.

Credit: Amin_Mahmodi

An afternoon+