{"id":702,"date":"2022-05-13T00:41:07","date_gmt":"2022-05-12T22:41:07","guid":{"rendered":"https:\/\/contentcory.com\/blog\/?p=702"},"modified":"2022-05-17T22:24:14","modified_gmt":"2022-05-17T20:24:14","slug":"how-to-create-a-social-media-calendar-in-google-sheets","status":"publish","type":"post","link":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/","title":{"rendered":"How to Create a Social Media Calendar in Google Sheets"},"content":{"rendered":"<div class=\"wp-socializer wpsr-share-icons\"data-lg-action=\"show\"data-sm-action=\"show\"data-sm-width=\"768\"><div class=\"wpsr-si-inner\"><div class=\"wpsr-counter wpsrc-sz-40px\" style=\"color:#000\"><span class=\"scount\" data-wpsrs=\"\" data-wpsrs-svcs=\"facebook,twitter,linkedin,pinterest\"><i class=\"fa fa-share-alt\" aria-hidden=\"true\"><\/i><\/span><small class=\"stext\">Shares<\/small><\/div><div class=\"socializer sr-popup sr-count-1 sr-count-1 sr-40px sr-opacity sr-pad\"><span class=\"sr-facebook\"><a data-id=\"facebook\"style=\"color:#ffffff;\"rel=\"nofollow\"href=\"https:\/\/www.facebook.com\/share.php?u=\"target=\"_blank\"title=\"Share this on Facebook\"><i class=\"fab fa-facebook-f\"><\/i><span class=\"ctext\" data-wpsrs=\"\" data-wpsrs-svcs=\"facebook\"><\/span><\/a><\/span>\n<span class=\"sr-twitter\"><a data-id=\"twitter\"style=\"color:#ffffff;\"rel=\"nofollow\"href=\"https:\/\/twitter.com\/intent\/tweet?text=%20-%20%20\"target=\"_blank\"title=\"Tweet this !\"><i class=\"fab fa-twitter\"><\/i><\/a><\/span>\n<span class=\"sr-linkedin\"><a data-id=\"linkedin\"style=\"color:#ffffff;\"rel=\"nofollow\"href=\"https:\/\/www.linkedin.com\/sharing\/share-offsite\/?url=\"target=\"_blank\"title=\"Add this to LinkedIn\"><i class=\"fab fa-linkedin-in\"><\/i><\/a><\/span>\n<span class=\"sr-pinterest\"><a data-pin-custom=\"true\"data-id=\"pinterest\"style=\"color:#ffffff;\"rel=\"nofollow\"href=\"https:\/\/www.pinterest.com\/pin\/create\/button\/?url=&amp;media=&amp;description=\"target=\"_blank\"title=\"Submit this to Pinterest\"><i class=\"fab fa-pinterest\"><\/i><span class=\"ctext\" data-wpsrs=\"\" data-wpsrs-svcs=\"pinterest\"><\/span><\/a><\/span>\n<span class=\"sr-share-menu\"><a href=\"#\" target=\"_blank\" title=\"More share links\" style=\"color:#ffffff;\" data-metadata=\"{&quot;url&quot;:&quot;&quot;,&quot;title&quot;:&quot;&quot;,&quot;excerpt&quot;:&quot;&quot;,&quot;image&quot;:&quot;&quot;,&quot;short-url&quot;:&quot;&quot;,&quot;rss-url&quot;:&quot;https:\\\/\\\/contentcory.com\\\/blog\\\/feed\\\/&quot;,&quot;comments-section&quot;:&quot;&quot;,&quot;twitter-username&quot;:&quot;&quot;,&quot;fb-app-id&quot;:&quot;&quot;,&quot;fb-app-secret&quot;:&quot;&quot;}\"><i class=\"fa fa-plus\"><\/i><\/a><\/span><\/div><\/div><\/div>\n<p>As a social media manager, you already know how crucial it is to have a social media content calendar at your disposal. Not only does it function as a place where you can house your social media lineup for weeks or even <strong><em>months, <\/em><\/strong>but it also helps organize information so that posting is easy and fast.&nbsp;<\/p>\n\n\n\n<p>Below, we\u2019ll go over how to properly set up your social media calendar in Google sheets and include some tips that will help you keep things organized.&nbsp;<\/p>\n\n\n\n<p>So, go ahead! <a href=\"https:\/\/sheets.new\/\" target=\"_blank\" rel=\"noreferrer noopener\">Open up Google sheets<\/a> and get ready to create your first content calendar.\u00a0<\/p>\n\n\n\n<p><em>(Don\u2019t worry, we\u2019ll wait!)&nbsp;<\/em><\/p>\n\n\n\t\t\t\t<div class=\"wp-block-uagb-table-of-contents uagb-toc__align-left uagb-toc__columns-1   uagb-block-4a1379b6 \" \n\t\t\t\t\tdata-scroll= \"1\"\n\t\t\t\t\tdata-offset= \"30\"\n\t\t\t\t\tdata-delay= \"800\"\n\t\t\t\t>\n\t\t\t\t<div class=\"uagb-toc__wrap\">\n\t\t\t\t\t<div class=\"uagb-toc__title-wrap\">\n\t\t\t\t\t\t<div class=\"uagb-toc__title\">\n\t\t\t\t\t\t\tTable Of Contents\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<div class=\"uagb-toc__list-wrap\">\n\t\t\t\t\t\t<ol class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#what-is-google-sheets\">What is Google Sheets?\u00a0<\/a><li class=\"uagb-toc__list\"><a href=\"#why-create-a-social-media-calendar-in-google-sheets\">Why Create a Social Media Calendar in Google Sheets?\u00a0<\/a><li class=\"uagb-toc__list\"><a href=\"#how-to-create-a-social-media-calendar-in-google-sheets\">How to Create a Social Media Calendar in Google Sheets<\/a><ul class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#step-1-open-a-new-spreadsheet-and-designate-a-month\">Step 1: Open a New Spreadsheet and Designate a Month<\/a><li class=\"uagb-toc__list\"><a href=\"#step-2-start-formatting\">Step 2: Start Formatting<\/a><li class=\"uagb-toc__list\"><a href=\"#step-3-fill-in-your-needed-columns\">Step 3: Fill in Your Needed Columns<\/a><li class=\"uagb-toc__list\"><a href=\"#step-4-stretch-columns-and-merge-new-row\">Step 4: Stretch Columns and Merge New Row<\/a><li class=\"uagb-toc__list\"><a href=\"#step-5-add-weekdays\">Step 5: Add Weekdays<\/a><li class=\"uagb-toc__list\"><a href=\"#step-6-reformat-if-desired\">Step 6: Reformat if Desired<\/a><li class=\"uagb-toc__list\"><a href=\"#step-7-copy-for-weeks-2-4\">Step 7: Copy For Weeks 2-4<\/a><\/li><\/ul><\/li><li class=\"uagb-toc__list\"><a href=\"#wrapping-up\">Wrapping Up<\/a><\/li><\/ul><\/ol>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\n\n\n<h2>What is Google Sheets?&nbsp;<\/h2>\n\n\n\n<p>For those who are unaware, Google sheets is an easy-to-use spreadsheet creation software similar to Microsoft Excel. When you open up a blank sheet, you\u2019ll see rows and columns where you can fill in your own information and designate labels to specific fields.&nbsp;<\/p>\n\n\n\n<p>Because of how versatile it is, Google Sheets is used by millions of individuals and businesses for things like list creation, accounting, and client management. You, however, will be using it for a social media content calendar.&nbsp;<\/p>\n\n\n\n<h2>Why Create a Social Media Calendar in Google Sheets?&nbsp;<\/h2>\n\n\n\n<p>Google Sheets makes an excellent social media calendar because of its versatility. Using specific commands and codes, you can tell it to do just about anything. For example, you can clean up values with CLEAN and TRIM commands automatically, and perform quick calculations for a set number of fields.&nbsp;<\/p>\n\n\n\n<p>The most useful part of Google Sheets for you, however, will be the ability to use <a href=\"https:\/\/support.google.com\/docs\/table\/25273?hl=en\">Google Sheets&#8217; formulas<\/a> to get your calendar set up and ready to function.&nbsp;<\/p>\n\n\n\n<p>Let\u2019s get started:&nbsp;<\/p>\n\n\n\n<h2>How to Create a Social Media Calendar in Google Sheets<\/h2>\n\n\n\n<h3>Step 1: Open a New Spreadsheet and Designate a Month<\/h3>\n\n\n\n<p>Depending on when you\u2019re reading this article, the month you use to start will change. You may want to start with the current month or preplan for when your social media will launch a few months from now. Determine the closest date when you will be posting on social media will be and use that month as a starting point. For this example, we\u2019ll start with May.&nbsp;<\/p>\n\n\n\n<p>Now, begin by typing your month in the first box on the top row in the format Month YYYY. By doing this, you\u2019re telling Google Sheets you are going to be working with dates, and it will better understand the commands we tell you to give it later.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/LmTvmykr_NOQpAsJHHCS3FEAePxpp27IBDIIb0lAb7EqeLRGIGgLmmYsDLw3zBCak8c_f6x8aP5V683XUa-nmWAUtCj3ySY4paLXIPL2VB-q4ZigQz0ucl6o3d5nlW1CIeyV2-Hg8g9jPb70Bw\" alt=\"Beginning of a content calendar in Google Sheets\" class=\"img-fluid\"\/><\/figure>\n\n\n\n<h3>Step 2: Start Formatting<\/h3>\n\n\n\n<p>To begin your formatting, you are going to want to highlight the first box you typed in as well as the however many columns you need following it. For one that is exactly like ours, you\u2019ll use eleven 12 total boxes. When you\u2019re finished, you should have boxes A1-L1 highlighted. Then, you\u2019ll click merge.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/w6IU1Yt-UDD441Abw-BsuSI4LAwMVC0x-sHIG3eYwRquYYFW9tYGjc93x-Cf4lXP9tAri7O1gF2RUvHZyY470diFowesQ5Sg2lehl6bEKs1maoR_3ecgkhZ6jxUf_DpAr-E2VDE75hye55hhRA\" alt=\"Creation of a Social media calendar in google sheets\" class=\"img-fluid\"\/><\/figure>\n\n\n\n<h3>Step 3: Fill in Your Needed Columns<\/h3>\n\n\n\n<p>Once your month is set up and the cells have been merged, you\u2019re going to go to row 2 and type in the cells you\u2019ll need to organize your social media content calendar. Be sure to leave the first one blank, or simply put \u201cday.\u201d&nbsp;<\/p>\n\n\n\n<p>Before you begin, add any design elements you\u2019d like and easily set your boxes up by highlighting them and selecting the font size, style, and color before you begin typing.&nbsp;<\/p>\n\n\n\n<p>We also recommend adjusting your month font size so that it is centered and easier to see.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/xjE0dnfWWbKLw5XddjpKaGgB1MECofpMUH-0Mx-TfW6UbIaNVfQ_cBCuKAj1QYuRq2b5XYWCGSbuOlVrY8y3g514DOUCyiiXkLk-9lzVuWPriJhTjZ9-pZ-TOFDInBbK_yUjbKjHUj99a7GFpA\" alt=\"Social media calendar in Google sheets mid-creation\" class=\"img-fluid\"\/><\/figure>\n\n\n\n<h3>Step 4: Stretch Columns and Merge New Row<\/h3>\n\n\n\n<p>Now that you have that finished, you\u2019ll notice that your columns aren\u2019t nearly wide enough to fit any sort of substantial text in them. Let\u2019s change that. Go to each of your columns in row 2 and stretch it to a size that fits your needs.&nbsp;<\/p>\n\n\n\n<p>Next, we need to make a space to designate each week. Go ahead and add the text, \u201cWeek 1\u201d into the first box in row 3. Then, highlight the remaining boxes in that row and merge them just like you did in step 2.<\/p>\n\n\n\n<p>After you format it similarly to your month box, it should look like this:&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/8msIsk_kT-qBHq4EiDPMSoUSREs8TGLofHH160tCue0VFz6SaWotqZvfU-g3kvEheGRUa3McZssp7TQvGY817pmdGrJ7oowjtB23JPN1w_0Z3crECE0oFcknqbkP-cLEf3z-MNcOAQCuK-HUDg\" alt=\"Social media calendar in google sheets with columns defined\" class=\"img-fluid\"\/><\/figure>\n\n\n\n<h3>Step 5: Add Weekdays<\/h3>\n\n\n\n<p>Now you\u2019re ready to add your weekdays! Start with the first box in row 4 and type your beginning day. We\u2019re going to use Monday. Then, go to each subsequent row and add in the remaining days.&nbsp;<\/p>\n\n\n\n<p>Once you\u2019re finished with that, add your dates to the \u201cDate\u201d column. Then, highlight rows 4 through 10 and stretch them to your desired height!&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/Yi4R_cP-gXceTaYP33EUqWbIVDK2S_gw_rGooNlmzWeE61w1mI9kZAQCcN9wUYpQ16dmF-__PKA5XPSSs4ycD5QtITdjwqQPWtc1EOuDPGsQj3Ww8w2VcOBqoVN8nJAo6dgQeL5m44Hlw3PAXA\" alt=\"\" class=\"img-fluid\"\/><\/figure>\n\n\n\n<h3>Step 6: Reformat if Desired<\/h3>\n\n\n\n<p>My favorite part of creating a content calendar is always the design elements! Not only can you use them to make everything look more organized, but having a cohesive design really just pulls everything together.&nbsp;<\/p>\n\n\n\n<p>Whenever I finish my first week set up, I usually do the following:&nbsp;<\/p>\n\n\n\n<ul><li>Grey out every other row to make it more visually appealing<\/li><li>Bold my day numbers<\/li><li>Replace the names of the social media with their respective symbols<\/li><li>Grey out the row below Sunday<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/86gteyNXWVzYaaM2d2pLPbwXIYCvUacboAVPSaDcgdHpfOsGGRODFM6D-hJedALZyt8xPUAb8j5E-9exmhyS-bOFaZqi_ePqh2pShv2qTVVctBf2B0_1lMiXhOG9VjgA6y1IAIwKnbIYB9oLUg\" alt=\"\" class=\"img-fluid\"\/><\/figure>\n\n\n\n<h3>Step 7: Copy For Weeks 2-4<\/h3>\n\n\n\n<p>Now that week one is completed, you\u2019re probably wondering where the other weeks are. \u201cAm I going to have to repeat this process for each one?\u201d You ask.&nbsp;<\/p>\n\n\n\n<p>\u201cNo!\u201d I reply, \u201cI would never make you do that!\u201d Instead, I\u2019m going to show you an easier way.&nbsp;<\/p>\n\n\n\n<p>Simply highlight the spreadsheet beginning with the row titled week 1 and go all the way down to the row below Sunday. Then, right-click and select copy. Go to the row below your Sunday box (for me, it\u2019s row 13) and paste! You\u2019ll have to resize your rows vertically, replace the dates, and change week 1 to week 2, but it\u2019s much easier than reformatting the entire sheet.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/Bgem8e-LVpGiz3Ic1nxTJCdKI5T5oFTYHIzO2E1rqIvnOevT0wUA6vbOjM9hIcna-MFXDb5KvnAlFh9CmwzPruLLfATLDrrFhlwvhYl7vyquKfHVaNEEPg_ZnFCcasGYdOoYF1ygwrCEptAICQ\" alt=\"Finished social media calendar in google sheets\" class=\"img-fluid\"\/><\/figure>\n\n\n\n<h2>Wrapping Up<\/h2>\n\n\n\n<p>Creating your own content calendar in Google Sheets isn\u2019t nearly as difficult as most people believe. However, that doesn\u2019t mean it doesn\u2019t take hard work!&nbsp;<\/p>\n\n\n\n<p>If you\u2019re looking for an easy content calendar you don\u2019t have to make yourself, ContentCory can help you. Check out our recent blog post on the <a href=\"https:\/\/contentcory.com\/blog\/the-ultimate-list-of-free-social-media-content-calendar-templates\/\">Top Free Content Calendar Templates<\/a>, or have a look at our <a href=\"https:\/\/contentcory.com\/#product\">content calendar software<\/a>!&nbsp;<\/p>\n\n\n\n<p>With ContentCory, you can create a beautiful, simple content calendar in no time.&nbsp;<\/p>\n\n\n\n<p>And we can\u2019t wait to see you do it!&nbsp;<\/p>\n<div class=\"wp-socializer wpsr-share-icons\"data-lg-action=\"show\"data-sm-action=\"show\"data-sm-width=\"768\"><div class=\"wpsr-si-inner\"><div class=\"wpsr-counter wpsrc-sz-40px\" style=\"color:#000\"><span class=\"scount\" data-wpsrs=\"\" data-wpsrs-svcs=\"facebook,twitter,linkedin,pinterest\"><i class=\"fa fa-share-alt\" aria-hidden=\"true\"><\/i><\/span><small class=\"stext\">Shares<\/small><\/div><div class=\"socializer sr-popup sr-count-1 sr-count-1 sr-40px sr-opacity sr-pad\"><span class=\"sr-facebook\"><a data-id=\"facebook\"style=\"color:#ffffff;\"rel=\"nofollow\"href=\"https:\/\/www.facebook.com\/share.php?u=\"target=\"_blank\"title=\"Share this on Facebook\"><i class=\"fab fa-facebook-f\"><\/i><span class=\"ctext\" data-wpsrs=\"\" data-wpsrs-svcs=\"facebook\"><\/span><\/a><\/span>\n<span class=\"sr-twitter\"><a data-id=\"twitter\"style=\"color:#ffffff;\"rel=\"nofollow\"href=\"https:\/\/twitter.com\/intent\/tweet?text=%20-%20%20\"target=\"_blank\"title=\"Tweet this !\"><i class=\"fab fa-twitter\"><\/i><\/a><\/span>\n<span class=\"sr-linkedin\"><a data-id=\"linkedin\"style=\"color:#ffffff;\"rel=\"nofollow\"href=\"https:\/\/www.linkedin.com\/sharing\/share-offsite\/?url=\"target=\"_blank\"title=\"Add this to LinkedIn\"><i class=\"fab fa-linkedin-in\"><\/i><\/a><\/span>\n<span class=\"sr-pinterest\"><a data-pin-custom=\"true\"data-id=\"pinterest\"style=\"color:#ffffff;\"rel=\"nofollow\"href=\"https:\/\/www.pinterest.com\/pin\/create\/button\/?url=&amp;media=&amp;description=\"target=\"_blank\"title=\"Submit this to Pinterest\"><i class=\"fab fa-pinterest\"><\/i><span class=\"ctext\" data-wpsrs=\"\" data-wpsrs-svcs=\"pinterest\"><\/span><\/a><\/span>\n<span class=\"sr-share-menu\"><a href=\"#\" target=\"_blank\" title=\"More share links\" style=\"color:#ffffff;\" data-metadata=\"{&quot;url&quot;:&quot;&quot;,&quot;title&quot;:&quot;&quot;,&quot;excerpt&quot;:&quot;&quot;,&quot;image&quot;:&quot;&quot;,&quot;short-url&quot;:&quot;&quot;,&quot;rss-url&quot;:&quot;https:\\\/\\\/contentcory.com\\\/blog\\\/feed\\\/&quot;,&quot;comments-section&quot;:&quot;&quot;,&quot;twitter-username&quot;:&quot;&quot;,&quot;fb-app-id&quot;:&quot;&quot;,&quot;fb-app-secret&quot;:&quot;&quot;}\"><i class=\"fa fa-plus\"><\/i><\/a><\/span><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Shares As a social media manager, you already know how crucial it is to have a social media content calendar at your disposal. Not only does it function as a place where you can house your social media lineup for&#8230;<\/p>\n","protected":false},"author":2,"featured_media":708,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[45],"tags":[81,82],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.5.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Create a Social Media Calendar in Google Sheets - ContentCory<\/title>\n<meta name=\"description\" content=\"Get started creating your social media calendar using this helpful, step-by-step Google Sheets instructional.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create a Social Media Calendar in Google Sheets - ContentCory\" \/>\n<meta property=\"og:description\" content=\"Get started creating your social media calendar using this helpful, step-by-step Google Sheets instructional.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"ContentCory\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ContentCory\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-12T22:41:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-17T20:24:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ContentCoryCom\" \/>\n<meta name=\"twitter:site\" content=\"@ContentCoryCom\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"seo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/contentcory.com\/blog\/#organization\",\"name\":\"ContentCory\",\"url\":\"https:\/\/contentcory.com\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/ContentCory\/\",\"https:\/\/twitter.com\/ContentCoryCom\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/contentcory.com\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2019\/12\/19084803\/contentcory-logo.png\",\"contentUrl\":\"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2019\/12\/19084803\/contentcory-logo.png\",\"width\":500,\"height\":500,\"caption\":\"ContentCory\"},\"image\":{\"@id\":\"https:\/\/contentcory.com\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/contentcory.com\/blog\/#website\",\"url\":\"https:\/\/contentcory.com\/blog\/\",\"name\":\"ContentCory\",\"description\":\"Simple social media content calendar\",\"publisher\":{\"@id\":\"https:\/\/contentcory.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/contentcory.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg\",\"contentUrl\":\"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg\",\"width\":800,\"height\":450},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#webpage\",\"url\":\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/\",\"name\":\"How to Create a Social Media Calendar in Google Sheets - ContentCory\",\"isPartOf\":{\"@id\":\"https:\/\/contentcory.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#primaryimage\"},\"datePublished\":\"2022-05-12T22:41:07+00:00\",\"dateModified\":\"2022-05-17T20:24:14+00:00\",\"description\":\"Get started creating your social media calendar using this helpful, step-by-step Google Sheets instructional.\",\"breadcrumb\":{\"@id\":\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/contentcory.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a Social Media Calendar in Google Sheets\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#webpage\"},\"author\":{\"@id\":\"https:\/\/contentcory.com\/blog\/#\/schema\/person\/f523131d3438a288b7faab882b6fe41c\"},\"headline\":\"How to Create a Social Media Calendar in Google Sheets\",\"datePublished\":\"2022-05-12T22:41:07+00:00\",\"dateModified\":\"2022-05-17T20:24:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#webpage\"},\"wordCount\":1090,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/contentcory.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg\",\"keywords\":[\"Google Sheets\",\"Social media calendar google sheets\"],\"articleSection\":[\"Social media tips &amp; tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/contentcory.com\/blog\/#\/schema\/person\/f523131d3438a288b7faab882b6fe41c\",\"name\":\"seo\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/contentcory.com\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/83db778423bee7fc045de97ac14ce21d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/83db778423bee7fc045de97ac14ce21d?s=96&d=mm&r=g\",\"caption\":\"seo\"},\"url\":\"https:\/\/contentcory.com\/blog\/author\/seo\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create a Social Media Calendar in Google Sheets - ContentCory","description":"Get started creating your social media calendar using this helpful, step-by-step Google Sheets instructional.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to Create a Social Media Calendar in Google Sheets - ContentCory","og_description":"Get started creating your social media calendar using this helpful, step-by-step Google Sheets instructional.","og_url":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/","og_site_name":"ContentCory","article_publisher":"https:\/\/www.facebook.com\/ContentCory\/","article_published_time":"2022-05-12T22:41:07+00:00","article_modified_time":"2022-05-17T20:24:14+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_creator":"@ContentCoryCom","twitter_site":"@ContentCoryCom","twitter_misc":{"Written by":"seo","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/contentcory.com\/blog\/#organization","name":"ContentCory","url":"https:\/\/contentcory.com\/blog\/","sameAs":["https:\/\/www.facebook.com\/ContentCory\/","https:\/\/twitter.com\/ContentCoryCom"],"logo":{"@type":"ImageObject","@id":"https:\/\/contentcory.com\/blog\/#logo","inLanguage":"en-US","url":"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2019\/12\/19084803\/contentcory-logo.png","contentUrl":"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2019\/12\/19084803\/contentcory-logo.png","width":500,"height":500,"caption":"ContentCory"},"image":{"@id":"https:\/\/contentcory.com\/blog\/#logo"}},{"@type":"WebSite","@id":"https:\/\/contentcory.com\/blog\/#website","url":"https:\/\/contentcory.com\/blog\/","name":"ContentCory","description":"Simple social media content calendar","publisher":{"@id":"https:\/\/contentcory.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/contentcory.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#primaryimage","inLanguage":"en-US","url":"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg","contentUrl":"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg","width":800,"height":450},{"@type":"WebPage","@id":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#webpage","url":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/","name":"How to Create a Social Media Calendar in Google Sheets - ContentCory","isPartOf":{"@id":"https:\/\/contentcory.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#primaryimage"},"datePublished":"2022-05-12T22:41:07+00:00","dateModified":"2022-05-17T20:24:14+00:00","description":"Get started creating your social media calendar using this helpful, step-by-step Google Sheets instructional.","breadcrumb":{"@id":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/contentcory.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Create a Social Media Calendar in Google Sheets"}]},{"@type":"Article","@id":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#article","isPartOf":{"@id":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#webpage"},"author":{"@id":"https:\/\/contentcory.com\/blog\/#\/schema\/person\/f523131d3438a288b7faab882b6fe41c"},"headline":"How to Create a Social Media Calendar in Google Sheets","datePublished":"2022-05-12T22:41:07+00:00","dateModified":"2022-05-17T20:24:14+00:00","mainEntityOfPage":{"@id":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#webpage"},"wordCount":1090,"commentCount":0,"publisher":{"@id":"https:\/\/contentcory.com\/blog\/#organization"},"image":{"@id":"https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg","keywords":["Google Sheets","Social media calendar google sheets"],"articleSection":["Social media tips &amp; tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/contentcory.com\/blog\/how-to-create-a-social-media-calendar-in-google-sheets\/#respond"]}]},{"@type":"Person","@id":"https:\/\/contentcory.com\/blog\/#\/schema\/person\/f523131d3438a288b7faab882b6fe41c","name":"seo","image":{"@type":"ImageObject","@id":"https:\/\/contentcory.com\/blog\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/83db778423bee7fc045de97ac14ce21d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/83db778423bee7fc045de97ac14ce21d?s=96&d=mm&r=g","caption":"seo"},"url":"https:\/\/contentcory.com\/blog\/author\/seo\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg",800,450,false],"thumbnail":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets-150x150.jpeg",150,150,true],"medium":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets-300x169.jpeg",300,169,true],"medium_large":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets-768x432.jpeg",640,360,true],"large":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg",640,360,false],"1536x1536":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg",800,450,false],"2048x2048":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg",800,450,false],"underboot-thumb-v-200-270":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets-200x270.jpeg",200,270,true],"underboot-thumb-750-300":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets-750x300.jpeg",750,300,true],"underboot-featured-900-600":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg",800,450,false],"underboot-cover-image":["https:\/\/blog.contentcory.com\/wp-content\/uploads\/2022\/05\/15202914\/google-sheets.jpeg",800,450,false]},"uagb_author_info":{"display_name":"seo","author_link":"https:\/\/contentcory.com\/blog\/author\/seo\/"},"uagb_comment_info":10,"uagb_excerpt":"As a social media manager, you already know how crucial it is to have a social media content calendar at your disposal. Not only does it function as a place where you can house your social media lineup for weeks...","_links":{"self":[{"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/posts\/702"}],"collection":[{"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/comments?post=702"}],"version-history":[{"count":7,"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/posts\/702\/revisions"}],"predecessor-version":[{"id":719,"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/posts\/702\/revisions\/719"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/media\/708"}],"wp:attachment":[{"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/media?parent=702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/categories?post=702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contentcory.com\/blog\/wp-json\/wp\/v2\/tags?post=702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}