Add Events from Google Sheets to Google Calendar Automatically from Thom Gibson

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.

Notes:

  1. Spreadsheet: You will need to copy his Google spreadsheet to get the FormMULE script.
  2. 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.
  3. Date Time:
    1. 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.  Screen Shot 2018-09-01 at 2.27.04 PM
    2. I used the same end time as the start time.
  4. Updates:  There is a way to update it the calendar, but there is a different Update video.

Have fun!

Blog Posts for the First Days of School!

It’s back to school time!!

Here is a compilation of posts that will hopefully help with all of your “Back To School” planning.  I thought that putting them all in one place would be helpful. Happy planning and welcome back to school!

Customized Sticky Notes and Stickers!

I love the fun stickers that Sam Shah and Allison Krasnow make for their students!  I haven’t created customized stickers for my students in the past. Instead, I usually make customized sticky notes.  I love using sticky notes because the students can return them to me.  My favorite new sticker that I made is one that students write their name and number (for quick alphabetizing) on, and then I stick it on their group folder.  I love that they are sticky because I can easily re-arrange them when I change groups.

Individual Sticky Notes

Name sticker for group folder.

Group folders are another awesome Sam idea that I keep meaning to blog about! At the beginning of the year I use a “Home Enjoyment” sticky note where I can check off improvements I would like to see in their homework.  I have an, “Oops, I’m tardy!” sticky note, where they write the reason for their tardy on the note.  I also made a “See me after class” sticky that they return to me. Once they return them to me, I stick them onto a page in a binder so I can keep an accurate record. These come in handy for parent meetings. Sticky notes are usually cheaper unless there is a sticker sale, especially when you cut them in half!

I completely forgot to order more sticky notes last year.  But seeing Allison Krasnow’s My Favorite at TMC19, reminded me, and even made me want to order stickers!  I can’t wait to encourage students with these stickers, on their best as well as their worst days.

Here are the sticky notes that I created, and the notes and stickers that I created from Allison (and Sam’s) posts.  The round stickers are 1.5″ because they were cheaper.  I usually shop at Vista Print when they have a sale!  The stickers and notes are so easy to create because Vista Print has so many ready made templates!

Julie