Guides › Marketing & Social
Fill a month of social posts in one sitting
A ready-to-use content calendar in a spreadsheet with dates, themes, captions and image ideas for a whole month of posts.
When to use it
Last week of each month
Step by step
List what's coming up
Write down next month's events, offers, launches, holidays and anything seasonal for your customers. Five or six items is plenty.
Ask for a calendar as a table
Paste this into your AI assistant with your details.
Prompt to copyCreate a social media content calendar for [month and year] for [business name], a [type of business] serving [audience]. We post [number] times a week on [platforms]. Key dates and offers: [list]. Mix the posts roughly 40% helpful tips, 30% behind the scenes, 20% customer stories, 10% offers. Output a table with columns: Date, Day, Platform, Theme, Post caption (under 60 words), Image or video idea, Call to action. Use British English and no hype words.Paste it into Google Sheets
Copy the table and paste it into a new Google Sheet. It usually lands in neat columns; if not, ask the assistant to give it as comma-separated text and use Paste special.
Add a status column
Add a column called Status with options like Idea, Drafted, Scheduled, Posted, so you can see your progress at a glance.
What you get
Tue 3 Mar | Instagram | Tip | 'Three ways to make your lunch break count...' | Flat lay of a packed lunch | Save this for later. Fri 6 Mar | Facebook | Offer | 'Mother's Day gift sets now in...' | Gift set on shop counter | Order by 25 March.
Tips
- Keep last month's sheet and tell the assistant which posts did best, so next month leans into what works.