In this video I’m going to show you how to create a content planner with Google Sheets and by the end of the video you can use this brain dump, plan, and track your ideas and content for your YouTube channel, your blog, email, and social media.
Watch this video here (don’t forget to like and share): https://youtu.be/RZbdicOVWcw
What we’re creating is a mix of Meghan Minns’ and Catherin Manning’s Google Sheets planners.
And to save time I have everything typed up and ready to customize. We’ll go over the basics then some Advanced tips and shortcuts.
Stick around till the end and I’ll share a YouTube workflow you can use in Asana, Trello, or any other project management tool to organize your content.
To get started, if you’re logged into your Google account, type sheets.new in the address bar to create a new sheet.
If you want this sheet to match your brand, go to Format in the menu then Theme to pick a theme and customize it.
Choose a font and add your brand colors. Custom and paste hex code here and save.
First add your text in the first row. Click the top-left to customize the whole sheet. Pick a font style, font size, text color background color, align to Center, and a add a border.
You can widen the columns by hovering over the right side of the column and double tap to fit the text.
This reference sheet is where you can add your marketing tools affiliate links freebies blog posts or any resources for easy access.
And once you’re done customizing, right-click tab at the bottom and duplicate it, then rename.
The next sheet is the Ideas sheet. Use this sheet to list all of your ideas under a theme or bucket.
For example, if you’re an WordPress expert, this column would be for WP myths, struggles, tips, and how-tos.
If you want to get rid of the extra rows and columns, click the row then hold Ctrl + Shift and down arrow, right click and delete rows below. Or, Ctrl + shift + right arrow then right click and delete columns on the right.
After you’re done brainstorming, add your topic to the next sheet. This is where you’ll map out your content for YouTube or your podcast plus your blog and email for the next quarter.
Add a publish date any events like launches and holidays post your topic/title here, After it’s published post a link to the video.
Add your link to Asana or Google Drive. If there’s a blog post that goes with this, add the title and link to the post. Add your email subject line and the link to the campaign.