2024 Social Media Planner Calendar in Google Sheets [FREE Template]
Вставка
- Опубліковано 25 сер 2024
- TL;DR How to set up the social media planner
- Make a copy of the template (you need a Medium account) / new-2024-2025-beyond-s...
- Duplicate the tab & rename it to "Jan" "Feb" "Mar" or whichever month you're planning.
Changing 3 settings:
1. In D2, write the year you're planning out content for
2. In F3, select whether you want your week to start on Sunday or Monday
3. In the pink box in J8, take the first calendar week of the month you want to plan content for (e.g. for January 2024, take calendar week 1. For February 2024, take calendar week 5).
Done! :) All dates etc will update according to your settings. Happy post planning!
📈 GET the FREE template: / new-2024-2025-beyond-s...
✍🏼 Contribute to the blog with your own Google Sheets templates: / google-sheets
🤓 Support me on Etsy: www.etsy.com/d...
I won't be updating future templates, that's why I shared templates for free for those on Medium and only for the symbolic price of ( little over) $1 on Etsy in case you'd like to support me financially
There's only a monthly version of the 2024 Social Media Calendar. You can set it up in just 3 clicks.
I won't be updating future versions. This is the final update of the template. You should be able to reuse it year upon year.
Thanks for the support!
This is a straightforward template. I am not too versed in using Excel, but I get excited by the formulas and how everything comes together. Thank you for sharing it with us. One question. Would that mess up the formulas if I wanted to add a sheet to it just to keep track of my hashtags?
This is super helpful, thank you!
This is exactly what I was looking for! Thank you so much for sharing your expertise and creativity!
omg thankssssssss!!!! may God blesses u huhu appreciate ur help
Lovely. Thank you
Thank you so much! This is very helpful x
Thank you so much !, this is wonderful
Hey, thankyou so much for this content calendar. it helps me a lot.
THANKS
This is super helpful!!!!! Thank you so much, allow me to use this as my reference
Of courseee 😊 Have fun with the template 🌻
Wow!! His is exactly what I was looking for! Thank you.
yay! Good luck content planning ✨
@@GoogleSheetsGeeks Thank you!😁
This is AMAZING...! Thank you so much! ✨
Thank you so much. I love you. You're an angel. :)
TY so much!!!!!!!!!!!!!!!!!!!!!!
You're welcome 😊
This is wonderful, thank you
Hi, thank you so much for the tutorial it's really helpful. 😊
Glad to hear 😊
Thanks!
🙏
this is awesome! thank you
Thank you so much! It's so clean - I love it.
Thank you so much
It’s really helpful ❤
thanks a lot I think really help me to start
Glad to hear :) Good luck habit tracking 🙏
Although I love perfect streaks, I don't have those every day, at all. But using the template as a reminder to do things that are good for you helps :)
This is what i was looking for, thank you so much
Thanks a lot for your sharing, thats very usefulll, thank
Thanks for the content sister
You're welcome😊
You are amazing, so glad I found you, thank you so much
Thank you 👏👏👏
Very helpful. Thank you!
This is really helpful. Thanks for sharing this template. I've been using your template since 2022. Good to see the final version. Super easy to use
How cool, thank you! 🙏
thank you so much. it's really help me
Awesome to hear 😊
Thank You!
I LOVE U SM THANK YOU HUHUUUUUUUU 😭😭😭😭😭
Love ya back 🌻
HiI When copying/pasting copy for a post into cells under "Post' columns, the text spreads across multiple cells. I tried unmerging, but it doesn't give me the option to do this. I tried text wrapping and it doesn't change anything. Could you advise what I am doing wrong? Driving me nuts
This is awesome, thanks, do you perhaps have one for blog post and tracking affiliate links?😅 if at all possible, will be very helpful, thank you
I have a Medium blog post tracker. You could maybe take this one and customize it to fit your needs? medium.com/google-sheets-geeks/2023-medium-writing-progress-tracker-with-149-publications-word-counter-top-writer-tags-a5e1d921b348
@@GoogleSheetsGeeks awesome, thank you very much
Thank you so much. I am just wondering how am I able to see the the Calendar week on my Google calendar?
Nvm I got it thx :)
hey how did you do it?
Ahoii, how do you mean? The calendar week's always visible on Google Calendar, I manually added it to the Sheet
@@GoogleSheetsGeeks I have the same problem. my Gcalendar won't show the calendar week :( Edit: I got it. Go to Setting- Go to View Options and add Show week numbers.
@@Veeartistry Go to Setting- Go to View Options and add Show week numbers.
If I plan to post multiple times a day, is there a way I can use this template?
A workaround: You could insert extra rows, only the mini calendars won't look that nicely.
I'm unable to access it, it's asking me to upgrade
Did you try again? What upgrade do you mean?
I mean it is asking me to pay the amount to access it
im having trouble changing the months that start on the same number, pls can you help me?
All you need to change is
- the year above
- And the calendar week in the pink box. Let's say you want to start your calendar in March this week. That's calendar week 10 (for 4 march to 10 March). Input the 10, and everything else will update automatically :)
the '10' goes in the pink box
can you do a project/task management planner? say you're managing different teams or projects and need calendar reminders of specific tasks. how would this be created in a workbook
I don't have any sheets for this purpose yet! 🙏
in my country the week start from Saturday. How can I change it? Would you help me with that?
Ufff, didn't consider Saturdays yet. I'll add it to the backlog and share on the channel once it's done
Hey thanks for this how do you get things to automatically update with the correct data based on selecting the week start - what’s the function?
It's a hacky way but I did this so you could all set up your own sheets in future and I wouldn't have to manually update them every year 😏
I don't even believe in God but.. you are God sent!
my calendar does not show me The first week. how to find it?
download in here the free template. and go to google calender press gear icon (setting) in that activate week numbers. then week numbers will be visible
Which first week? You have to choose which month you want to display in the spreadsheet. Instructions are all in the blog, link is in the description box :)
What font do you use ? Tks
Century Gothic
@@GoogleSheetsGeeks Thank you !
link is showing invalid
Did you try again? I checked it, it's working🙏
Hii, I really like this calendar, unfortunately when I download it to excel, everywhere where `Mon or Monday`stands turns to DDD/DDDD.,. how can I change??
Unfortunately I have no idea, I only work with Google Sheets🧐
😔 'promo sm'
What do you mean?
Thanks!!
Thank you so much
Thank you so much. I am just wondering how am I able to see the the Calendar week on my Google calendar?
I didn't look into that, this calendar's meant to use in Google Sheets only. But I'm sure there's a way to sync it to Google Calendar somehow