A full-blown social media scheduler on Google Sheets
FREE Assignment Tracker Google Sheets template available through @HHSStudentLife on Instagram.
Is there a way to import data from TikTok into Excel/Google Sheets?
How to collect data from Youtube, Instagram, and TikTok to the spreadsheet?
How can I choose the best social media content calendar template for my needs?
What are the key features to look for when selecting a social media content calendar template?
How often should I update my social media content calendar?
Videos
I run a boutique SM marketing agency and this is what our process looks like:
-
Create social media content (probably the toughest bit, need information/creatives from clients, a lot of Canva, a little bit of Illustrator, some ChatGPT)
-
Put all the images and media on Google Drive and all the text into a Google Sheets
-
Sometimes our clients like to have a look, mostly they do not. Regardless, all of it is in Sheets as it helps us in planning.
-
Take ALL that content and put that into Hootsuite/Later/whatever. We've used different schedulers at different times.
I knew there was a gap. The transferring of content from Sheets to a scheduler seemed redundant and a lot of wasted manpower. I mean sure there are things that a scheduler does that Sheets cannot, but really the main value add for me was just scheduling. Didn't need anything fancy.
I'm not a tech guy, but I got in touch with a friend who was. And we built a scheduler on top of Google Sheets. It does what it says, nothing more nothing less.
-
Put your content into Google Sheets. Images in Google Drive.
-
Fire up the Google Sheets extension. Hit "Schedule Posts" and that's that.
There are some cool things in there that I'm quite proud of. Stuff like, typing in English to set up a date/time to schedule (eg. "tomorrow 4 pm) and also the ability to schedule multiple stories together on Instagram (AFAIK most standalone schedulers don't have this lol).
We've gone through both Google and Meta verification and we're finally at a place where I think we can share what we have with folks.
BTW there is another "scam" the schedulers had that I was annoyed with and wanted to fix. Charging by number of social media accounts or channels. THAT DOES NOT MAKE SENSE. In our Google Sheet scheduler you can add as many accounts as you like, no limit.
I've brought in Instagram, Facebook and TikTok, that's pretty much what I need! And I'm calling it "Sheets to Social", couldn't think of a simpler name.