Uploaded June 2025 | Updated September 2026, 2 weeks ago

---

In the first video ( youtu.be/fAfomDR0pe4 ), we covered the basics of adding/updating/deleting events on your Google Calendar from Google Sheets.
In this video, we're taking it to the next level, starting with adding HTML to your calendar event descriptions, changing the color of your events, and then going on to handling multi-day events and all day events.
At the end of the video, I'll address how to fix a common issue, which is when the time you set in your Google Sheets doesn't match what shows up in Google Calendar.

/** Color Map Code
let colorMap = { "Peacock": "1", "Sage": "2", "Grape": "3", "Flamingo": "4", "Banana": "5", "Tangerine": "6", "Lavender": "7", "Graphite": "8", "Blueberry": "9", "Basil": "10", "Tomato": "11" };
**/

** LINKS **
1) Make a copy of the Google Sheet & Script here (includes original version): bit.ly/48CoOGi
2) Google Documentation: developers.google.com/apps-script/reference/calendar/calendar-app

** TIMESTAMPS **
0:00 Intro
0:26 1. Add Color & Pop to Your Events
0:32 1a. Adding HTML to Descriptions
3:08 1b. Setting the color on the event
9:28 2. Multi-Day Events
12:18 3. All Day Events
20:53 4. Fix: What if the Time is Different?
22:30 Conclusion