We’re going to use our 12 questions to complete a Google spreadsheet, roughly following the 12 question formula, which we’re then going to create FOUR 13 week post cycles out of.
We’re then going to create 13 graphics in Canva - 11 “business“ posts, and 2 “personal“ photos (posted in weeks 7 and 13 of the 13 week cycle).
Then, we’re going to bulk import our questions to our Canva file, creating 52 separate posts.
Finally, we’re going to import these to BrokerOS and schedule them out over the course of the year.
8 personal photos.
3-4 professional headshots.
Your 12 questions answered.
Your primary brand colours.
Take the answers from your 12 questions, and use them to complete this document.
Each row represents one week of the 13 week cycle.
We have 4 rows, so we get 52 posts.
We’re going to intersperse “professional“ and ‘personal‘ photos.
You just need to find 4 ways to say the same thing.
The comments columns can be filled or left blank. We’ll import these into BrokerOS later.
You will see how the post titles match the columns in the Google doc.
Let us know if or when you’d like help with creating your social posts. This is what we need:
Your primary brand colours.
Your brand fonts.
Professional headshots if you have any.
Ideas of
Graphic design best practice:
Adding images to the background looks less shit.
The more headshot/ professional imagery we have the better.
Try and link a background image to the copy.
Match the columns and import. This will create 52 posts.
Remember to add your personal photos in!
Copy the link URLS into the SECOND sheet in the Google doc (be sure to add any comments about your personal photos).
Go to ChatGPT, and using the prompt below, generate the times to be released and paste them into the time column.
Please create a single column of entries with the following information:
Using the format YYYY-MM-DD HH:mm:ss
First entry starting around lunch time at:
Each subsequent entry is 1 week later (please vary by 15 minutes or so):
Number of entries: 52.
All done for a year!
