You are here because you want to know how to make a content calendar for 2021 in google sheets.
Well, New Year, new goals, right?
What's a content calendar, and why do you need one?
A content calendar is a written schedule of when and where you plan to publish upcoming content. It can be blog posts, YouTube videos, or Instagram posts.
So, you need a content calendar to be able to schedule in advance, your content. That way, you can make sure to always publishing something.
Also, your content calendar will help you remember your old post. It will prevent reposting the same content over and over.
More Content Calendar
For your information, I have filmed a video on my YouTube Channel on how to make a content calendar for social media on Excel. If you are more of a Microsoft person, you can watch that video.
Ok, let’s dive right into how to make a content calendar for 2021 in Google Sheets.
Now, click on “go to Google Sheets”
And then, start a new blank spreadsheet!
CONTENT CALENDAR 2021
So, you need to start by giving a name to your project.
Alright, let’s rename it “Content Calendar 2021”.
Digital Stickers Shop
Obviously, your sheet will be empty! But, we are going to filling it up with what you’ve to do.
So, into one project, you can add a couple of sheets.
Now, look at the bottom of your document, you will find “sheet 1”
So, click on the “+” and add as many sheets as you want.
I usually do one sheet per social media and I rename them.
Here, I choose to start my content calendar 2021 with my blog posts and YouTube videos.
HOW TO MAKE A CONTENT CALENDAR
Let’s start with what to write into your content calendar.
So, in the first line, you will write the title of each category.
Now, here is how I do mine for my YouTube videos content calendar.
For example: Month, date, video title, video description, tags, thumbnail, filmed, edited, complete.
So, when this is done, I select each title and add some colors.
Once you’re done filling up your titles with color, you can start adding your month, dates, etc.
So, obviously into the month, you will add January, February …
Then, into the date, you will have to add all the dates of the month you’re going to publish.
I will publish once a week. So, 4 times a month, meaning in January, I will have to add 4 dates.
So you know, use those tools to merge!