International Bloggers’ Association

- Helping #IBAbloggers & Bloggers Everywhere Succeed

  • Why Join?
  • Sign Up
  • My Account
  • Log In
  • Home
  • Build Your Blog
    • Blogging Tips
    • Getting Published & Writing
    • Let’s Make Your Blog Awesome
    • Marketing & SEO
    • Monetize Your Blog
    • Social Media
    • Twitter Chats – Schedule & Recaps for #IBAchat
    • Wall of Fame
  • Share Your Blog
    • Blog Hops and Linky Parties
    • Business
    • Creative
    • Family
    • Food
    • Health
    • Lifestyle
    • Travel
  • Members Only
    • Members Only Blogging Tips
    • New Members Start Here
    • Member Home
    • Affiliate Area & Terms
    • Join IBA’s Tailwind Tribe & Pinterest Group Boards
    • Submit Original Content
    • Submit Syndicated Content
    • Apply for Your Excellence Badge
    • IBA Badges
    • IBA Member Custom Search Engine
  • Meet Our Members
    • Member Directory
    • Member Interviews
  • FAQ
    • What is The International Bloggers’ Association, & Why Does It Matter?
    • Mission Statement
    • Membership Requirements, Disclosure and Privacy Policies
    • IBA Affiliate Terms
    • Awesome Resources – Undergoing Construction
  • Contact
  • Become A Member
You are here: Home / Blogging Tips / Need An Editorial Calendar? Use Google Drive Sheets!

Need An Editorial Calendar? Use Google Drive Sheets!

December 2, 2016 by IBA Member 2 Comments

Pin22
Share20
Tweet2
Flip
44 Shares

Need An Editorial Calendar? Use Google Drive! originally appeared on Fab Working Mom Life by our very own Julie Smeltzer. Thanks for being an IBAblogger and sharing with us Julie!

Did you know you can use Google Drive Sheets as an Editorial Calendar with a simple add-on? Julie from Fab Working Mom Life shows us how!

 

WordPress has a great plugin that shows your draft and scheduled posts on a calendar, and you can drag and drop as needed to move things around. This editorial calendar is incredibly useful.

Did you know you can use Google Drive Sheets as an Editorial Calendar with a simple add-on? Julie from Fab Working Mom Life shows us how!
need-an-editorial-calendar-use-google-drive-sheets

However, what about your list of ideas?

I keep reading that creating a draft post for each idea you have isn’t the best practice. Well, I probably have 10-15 idea drafts just floating around my WordPress – and they’re not even legit drafts, just subject lines, and a blank post.

I decided to instead try to organize and plan my ideas elsewhere, instead of creating a draft post for any idea I had. The problem is, I still wanted to be able to see a calendar view of my scheduled posts with these draft ideas to plan out when to write them.

Since I like to be able to view and edit my plans anywhere (from home, on my phone, on work breaks), and I love spreadsheets (I’m an engineer, after all), I wanted to use Google Drive for this purpose. I recently found out a way to do this! Did you know you can find add-ons for your Google Sheets?

Did you know you can use Google Drive Sheets as an Editorial Calendar with a simple add-on? Julie from Fab Working Mom Life shows us how!

How to Use Google Drive Sheets as an Editorial Calendar with an Add-on

On the menu bar, between “tools” and “help” is a lovely option called “Add-ons”. Click that and search for “template” like I show in the screenshot below, and look for “Vertex 42 Template Gallery”. It is free, so you would just click the “+FREE” and accept the terms. Of course, you can try out any of the other templates, that’s just the one I ended up adding on and using.

 

Did you know you can use Google Drive Sheets as an Editorial Calendar with a simple add-on? Julie from Fab Working Mom Life shows us how!

Once the add-on is installed, you use it by going to “Add-ons”, hovering over the “Template Gallery” arrow on the right and selecting “Browse Templates”.

 

Did you know you can use Google Drive Sheets as an Editorial Calendar with a simple add-on? Julie from Fab Working Mom Life shows us how!

Then you select the Monthly Calendar option. I picked landscape, but there is also a portrait option.

 

google_drive_calendar_3-e1432159231190

Click here to share this post on Twitter and give Julie a shoutout! 😉Click To Tweet

This creates a new Sheet with tabs for each month. You select the year and it populates the dates. Now all you need to do is write in the titles of your planned posts and draft ideas to help organize your editorial calendar. This works like a spreadsheet you would have on your computer, except with the added bonus of being able to access it on any browser or the Google Drive app.

You can see a sample of my Editorial Calendar on Google Sheets below. I filled in some of May 2015 posts. It gives me the option of knowing at a glance what days I’m posting and what days are available while also letting me establish some sort of posting schedule pattern with any post ideas I have floating around in my head.

 

Did you know you can use Google Drive Sheets as an Editorial Calendar with a simple add-on? Julie from Fab Working Mom Life shows us how!

What tools do you use to plan your posts? Have you used Google Sheets and add-ons before for this purpose? Leave us a comment below 🙂

Meet Julie

Julie Smeltzer

30-something; April 13th; Wife; First Time Mom; Engineer; Reader; Blogger; Fangirl

She blogs about her journey at Fab Working Mom Life, including her career, pregnancy, and parenthood.

Pin22
Share20
Tweet2
Flip
44 Shares

Related IBA Articles

  • painted rocks on a table with text overlay "Rock Painting Tricks for Kids of All Ages"Rock Painting Tricks for Kids of All Ages
  • A Call to Action: Stop Procrastinating!
  • Easy Photo Backdrops to Make Your Blog Photos Pop

Filed Under: Blogging Tips, Featured Posts, Syndicated Tagged With: blogging tips, blogging tricks, editorial calendar, Google Drive, syndicated

Subscribe To IBA

IBA NEWSLETTER

  • Bloglovin
  • Facebook
  • Google+
  • Instagram
  • LinkedIn
  • Periscope
  • Pinterest
  • StumbleUpon
  • Twitter
  • YouTube

SEARCH IBA

IBA Member Benefits Become An IBA Member IBA Resources

IBA’s Favorite Tools & Services

CoSchedule: The Editorial Calendar For WordPress Social Warfare the best for Wordpress

Popular Posts

How to Grow your Facebook Page – Organically (without ads)How to Grow your Facebook Page – Organically (without ads)
How To Stand Out On Influencer Networks for BloggersHow To Stand Out On Influencer Networks for Bloggers
5 Important Blogging Stats Easily Found on Google Analytics Home Tab5 Important Blogging Stats Easily Found on Google Analytics Home Tab
Your Blog Needs a Start Here Page – Here’s How to Set It UpYour Blog Needs a Start Here Page – Here’s How to Set It Up
Creative Briefs in Action – Looking at 3 Stellar Landing PagesCreative Briefs in Action – Looking at 3 Stellar Landing Pages
5 Creative Ways to Promote Blog Posts Besides Social Media5 Creative Ways to Promote Blog Posts Besides Social Media
joinloginmember-home
  • Privacy Policy

© 2019 International Bloggers Association LLC // All Rights Reserved// Web Design By, Nicole Orozco

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkRead more