If you have a spreadsheet of your assignments for your students, then have all of the assignments automatically added to a Google Calendar, this post is for you! This post will also help those who have MANY dates they need to enter onto a calendar at one time.
As a mom of three teenaged boys, I have many, many sporting events to attend this fall, 49 in all. The though of adding ALL of these events to our family calendar was daunting, so I decided that I wanted to try to automate it all. Yes, this took much longer the first time as I had to figure it all out. But it was worth it as I’ve since used this method to add other events, en masse, to my google calendar. So, it has saved me tons of time! I’m blogging about it so I won’t forget how to do it the NEXT time (lol) and so you can try it too if you want! I’m a newbie, so I probably won’t be able to answer technical questions if you decide to try it out.
I first tried a Google add on, but the creator was in Paris, so it took me hours to figure it out. Then Thom Gibson tweeted me, so I used his script and it was much easier! This is the one I will use from now on. Thank you Thom! 🙂
To learn how to add Google Calendar events from a Google Sheet, watch Thom’s video.
- Spreadsheet: You will need to copy his Google spreadsheet to get the FormMULE script.
- Permissions: You will need to permit Google to let you use this. It will say it’s unsafe bc it isn’t a Google Add on.
- Date Time:
- Be sure your cell is formatted in the Date Time format if it is not an all day event so you can add the start time.
- I used the same end time as the start time.
- Updates: There is a way to update it the calendar, but there is a different Update video.