An Epic Social Media Content Calendar Template (with Tutorial)

How to Create an Epic Content Calendar for 2018

Free Content Calendar Template for 2018 | Having a hard time figuring out what to share on social media? Use this content calendar template to help you stay consistent and keep track of your promotions. #ContentCalendar #blogging #SocialMediaCalendar #socialmediatipsHaving a hard time figuring out what to post on social media? Do you want a template to organize and plan your content so that you always have something to share?

I’m with you. It’s hard to stay ahead of social media! One thing’s for sure: a social media content calendar template will help you stay on track, post consistently, and keep track of important events and promotions you want to share.

Today, I’m sharing how to create and use a calendar with Google Sheets, with a free content calendar template you can start using right away.

Let’s dig in!

#1: Create Monthly Goals

It’s important to have an end goal for all content you share so that you can track what’s working, which types of content drive your bottom line, and what to change based on campaign performance.

For most of us, our goals fall into the category of generating more leads and sales. Working backward from these long-term goals, we can create short-term goals that will help us achieve them.

The key with short-term goals is to start small, be specific, and set a realistic time frame to achieve each goal. At the end of each month, you want to be able to track your growth, see what worked, and set new goals for the future.

Remember our Blog Profit Series? We’re filling up each of those buckets, plus a fifth one:

  • Content
  • Followers (new!)
  • Traffic
  • Subscribers
  • Sales

Start with a goal setting spreadsheet for your social media calendar template

#2: Determine what you will share

The purpose of a social media content calendar is to provide a framework for sharing content that resonates with your audience and also sells your blog business. Before creating your calendar, be sure to plan content around specific campaigns and goals.

First, determine the types of content that make sense for your business and audience. Some common categories include:

  • Blog posts
  • Quotes + motivation
  • Product promotions
  • Holidays
  • User-generated content
  • Events + announcements

Depending on your business, your categories may look different and can be as broad or specific as you need. For instance, a health club might have these categories:

  • Free trials
  • Challenges
  • Workout videos
  • Holidays
  • Workshops + clinics
  • Recipes + nutrition
  • Daily WODs
  • Fitness tips

Once you’ve chosen your categories, create a separate spreadsheet to use as a working library for the original content, products, events, and promotions you plan to share. It’s helpful to color-code each content type so that you can easily differentiate them on the calendar.

Use a spreadsheet like this to create a content plan for your social media calendar.

Having a hard time coming up with blog ideas? I’ve got 3 places to find them right here.

Make sure you include publishing dates, post descriptions, URLs, images, action items, campaigns, and any other details needed for your workflow. If you have weekly or monthly content themes, add a column to the left of the spreadsheet, and include your theme.

I recommend managing other people’s content, RSS feeds, and Feedly subscriptions with a tool such as SmarterQueue and using the social media content calendar to plan original content, images, and timely promotions that require extensive planning and coordination.

#COLORTIP Use the same color codes for each category in your scheduling tool! Color coding makes it super easy to spot your categories across multiple tools and spreadsheets.

Plan your content on or before the first of each month. Throughout the week, you can fill in by creating content, designing images, manually sharing posts, and adding them to your scheduling tools.

Bonus: If you want, you can use this social media cheat sheet with over 24 days of content ideas. Click the image below to download.

A social media cheat sheet for bloggers and entrepreneurs so you know what to post and when, plus tools to help you automate everything from scheduling, to growth and engagement, and creating images.

#3: Next Up, Create the Calendar

Here’s where the fun starts! Log in to Google Drive to create a new spreadsheet.

To create your content calendar template, start by making a new Google sheet.

Create a sheet by selecting the New tab, and then click the title to rename it. Now it’s time to customize the spreadsheet and create your calendar template.

Since we’ll be working with seven columns, select columns A–G and drag them to the right until they fill the screen. Then delete columns H–Z.

Next, highlight the cells in the first row, and select Format from the top menu to merge the cells (Merge Cells > Merge All). Customize the font style, and center the text.


In the next row, enter the days of the week, beginning with Sunday. If you’d like, you can freeze these two rows so that they remain in view at all times by highlighting them and selecting View > Freeze > Top Two Rows.

Use the Freeze View menu option while you create your marketing calendar template.

In the next row, enter calendar dates, and then select the top three rows and add a bottom border using the border tool from the top menu.

Next, add your social media profiles to each date, leaving one or two rows between each profile to accommodate your posting frequency. Then select each column, and add a right border to each.

Leave a few extra rows, and add a bottom border to the last row in week one. Then copy week one, change the dates, and complete the calendar template.

Social Media Calendar template

Don’t forget to download the done-for-you content calendar template so you can start using it right away. It’s a huge time-saver!


#4: Add content to the calendar

Now it’s time to choose the specific days that you will share each piece of content. Using the same color blocks, add the content from your working library.

A completed social media content calendar

Customize the calendar to suit your posting frequency. For instance, you may want to include specific times you plan to share each post or add email and other distribution channels. I like to use the additional rows each day to highlight important events and promotion dates.

If you publish a large volume of content each month, you may even want to create separate calendars for each social media profile.

I regularly share the same content on each profile and find it helpful to use a simple color-blocked version of my calendar so that I can quickly see what content I plan to share each day.

Simplified version of the content calendar template


#5: Create the Content

Now that your calendar is complete, it’s time to research, gather your content, create blog posts, and design images. If you find yourself struggling to find the time to execute on your social media plan and create the content you need, the tools below will help.


PromoRepublic is a social media content builder with more than 6,000 templates created by designers, writers, and other industry professionals.

With PromoRepublic, you can share stunning visual content to Facebook, Instagram, Twitter, and LinkedIn at the click of a button. What I like about PromoRepublic is that in a matter of seconds I can share posts that would normally take hours to brainstorm and create.

PromoRepublic pricing starts at $9 a month for up to five social profiles.

Use PromoRepublic to help create ontent for your social media calendar


RelayThat is a graphic design platform that makes it easy for nondesigners to create beautiful images.

RelayThat is probably the fastest image creation tool I’ve used to create high-quality social media images. Use the one-click resize function to quickly choose a tall, wide, or square template. Then choose a background, and add your logo and text. Use the remix function to rapidly change the position of your text until you find one you like.

RelayThat is an easy design tool for creating content for your marketing calendar template.

For a complete tutorial on how to use RelayThat, click here.


As a visual person, I’m drawn to the design of Trello. While the Google Docs calendar provides a framework for planning content, I prefer managing the content creation process inside Trello, which is like a whiteboard for content.

In Trello, lists are categories, and cards are individual pieces of content. You can move cards from list to list, color-code your cards to match your calendar, and add images and descriptions to your cards. Setting due dates for cards will automatically place them on the Trello calendar.

Even the free option is useful for businesses and organizations, and you can easily share boards with team members.

Use Trello to organize your social media calendar template.


SmarterQueue has become my go-to scheduler, both for sharing evergreen content and other people’s content.

You can share content from any feed, whether it’s your favorite source, RSS feed, a Pinterest feed, a Facebook feed, or a competitor feed.

If you use Feedly, you can import an OPML file into SmarterQueue and arrange bookmarks from the left sidebar. To schedule Feedly content, add an “other people’s content” or “articles” category to your social media schedules. Then head over to the Add Content tab in the top menu, and select the piece of content you want to share.

Use SmarterQueue to fill your content calendar with other people's content.

Note: SmarterQueue is an evergreen scheduler and will automatically set your post to recycle. Be sure to select One-Time Post when you’re sharing other people’s content. The only content you want to re-share is your own!

Step #6: Track Your Posts + Promotions

Now that you’ve planned the content you want to share each day, it’s important to follow through and ensure that you share it.

Use a spreadsheet to track when and where you’ve shared content on each social media channel. The tracking sheet will also help coordinate content promotion with your team. Use notes to add tweet text and descriptions for each post.

The promotion spreadsheet is also helpful to keep track of older posts that you’d like to share with any new social accounts.

If you want, you can download the blog promotion worksheet here:

Use this blog promotion worksheet to track where and when you keep track of your social media calendar plan.

Final Thoughts

Using a social media calendar will help you plan your content around smart social media goals and coordinate with campaigns and blog content to achieve them. If you use the tools mentioned here to create and share high-quality posts at the right time on each channel, you will likely see more results from social media.

Remember to monitor each channel for engagement, moderate comments, and reply to fans and followers daily. Check the analytics of each platform to see what content resonates with your audience, and use that to inform future marketing campaigns.

Over to you! Do you use a social media content calendar? What tools do you use for creating and scheduling your posts in advance?


18 replies
    • Sandra Clayton
      Sandra Clayton says:

      Hi Jamie! I used to do that too but always felt like I was playing catch up. I think the more content you create, the easier it is to plan because you have more pieces working together, if that makes sense. 🙂

  1. Elise Ho
    Elise Ho says:

    This is a truly excellent post. I love that you offer so many tips and resources but the whole piece is written in a way that is super easy to understand.

    For me, I have set days that I post content to each category of my blog, I have a fairly good idea of what the content will specifically be focused on (a very good idea for the current quarter), but I need to dig into Smarter Queuu or another. I have also been told Trello is awesome for organization so I will check that out too.

    • Sandra Clayton
      Sandra Clayton says:

      Thanks so much for your comment, Elise. SmarterQueue makes it much easier for me to follow through and ensure that I’m actually sharing the content I plan. I used to fall terribly behind and forget to post, so all of that planning went right out the window! I think you’ll love both SQ and Trello.

  2. Teri
    Teri says:

    Wow! These are the kind of tips I thought I wouldn’t be able to afford to get from a pro like you. Thanks for so generously sharing these tips! I need them!

  3. Gretchen White
    Gretchen White says:

    Hello! Thanks for sharing! I love how you showed many ways to do this. I am an old-fashioned girl and still put everything down on paper. I like being able to see it as soon as I walk into my office.

  4. Keri Trueick
    Keri Trueick says:

    What an absolutely brilliant post! So helpful and makes me want to start planning now! We usually just wing it with what we’re posting from day to day if we don’t actually have a blog post to publish, but this is what I’ve been looking for! I love to be organised and so this is perfect! Thank you ????

  5. Shruti
    Shruti says:

    Your posts are so informative and so useful. I love that you give an honest approach to all these curated resources. Keep up the great work! 🙂


Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.