HOW TO MAKE A CONTENT CALENDAR FOR 2021 IN GOOGLE SHEETS

HOW TO MAKE A CONTENT CALENDAR FOR 2021 IN GOOGLE SHEET

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.

GOOGLE SHEETS

So, the first thing you need to do is to go into Google Sheets.

HOW TO MAKE A CONTENT CALENDAR FOR 2021 IN GOOGLE SHEET

Now, click on “go to Google Sheets”

And then, start a new blank spreadsheet!

HOW TO MAKE A CONTENT CALENDAR FOR 2021 IN GOOGLE SHEET

CONTENT CALENDAR 2021

So, you need to start by giving a name to your project.

Alright, let’s rename it “Content Calendar 2021”.

HOW TO MAKE A CONTENT CALENDAR FOR 2021 IN GOOGLE SHEET

Digital Stickers Shop

Sheets

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 FOR 2021 IN GOOGLE SHEET

HOW TO MAKE A CONTENT CALENDAR

Let’s start with what to write into your content calendar.

Categories

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.

HOW TO MAKE A CONTENT CALENDAR FOR 2021 IN GOOGLE SHEET

Colors

So, when this is done, I select each title and add some colors.

HOW TO MAKE A CONTENT CALENDAR FOR 2021 IN GOOGLE SHEET

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.

HOW TO MAKE A CONTENT CALENDAR FOR 2021 IN GOOGLE SHEET

Extra Tip

So you know, use those tools to merge!

HOW TO MAKE A CONTENT CALENDAR FOR 2021 IN GOOGLE SHEET

And just like that, you know all the basics on how to make a content calendar for 2021 in Google Sheets.

Don’t hesitate to DM me on Instagram if you’ve any questions!