Guides › Marketing & Social
Run a weekly social posting routine on autopilot
A repeatable system where ideas in a sheet become drafted captions, branded images and scheduled posts each week with very little effort.
When to use it
Set up once, then 30 minutes every Friday
Step by step
Build your idea sheet
In Google Sheets, create columns: Week, Topic, Headline, Caption, Hashtags, Status. Add 10 or more topics you could post about. Share it with anyone who has ideas.
Draft captions on a schedule
If your ChatGPT plan includes scheduled tasks, set a weekly Friday task with this prompt and paste in the week's topics; otherwise run it yourself from a recurring Friday calendar event.
Prompt to copyFor [business], a [type] serving [audience], write posts for these topics: [paste topics]. For each give: Headline (max 6 words), Caption (50-80 words, one call to action: [CTA]), 3-5 Hashtags. Output as a table with columns Topic | Headline | Caption | Hashtags so I can paste it straight into Google Sheets. British English, warm, no hype.Paste results into the sheet
Paste the table into the matching columns and set Status to Drafted. Edit anything that doesn't sound like you.
Make all the images at once
If your Canva plan includes Bulk Create, connect the sheet's Headline column to a template to make every image in one go. Otherwise duplicate one template and paste each headline.
Schedule and mark done
Schedule the posts in Meta Business Suite, LinkedIn or Canva's Content Planner, then set Status to Scheduled. Your Friday calendar event keeps the routine going.
What you get
Friday 3pm: 5 topics pulled from the sheet -> captions drafted -> 5 matching images from Bulk Create -> posts queued Mon to Fri at 8am. Sheet now shows Week 46: 5 Scheduled, 3 ideas left in the bank.
Tips
- Top up the idea bank whenever a customer asks a good question; that's your best source of topics.
- Check every drafted post before it goes out; never fully skip the human read-through.