Auto color google calendar events
In order to automatically color the events as soon as a new event is created. You follow these steps :
- Deploy this script in code.js your google app script environment. By creating a new project and copy pasting the code there.
- Rename the domain name on line 23 to your own company domain 'const domainName = "example.com";'
- Add more email IDs to the array on line 26. These are all the emails that can be on the invie but still considred as part of the team & not an external attendee
- Add a trigger to the app script
- Add the following color labels in your calendar
That's It.
If your internal meetings are colored as External : do these steps
- Turn on dryrun on line2 and look at the output.
- Run the script and copy the output to a txt file.
- Search for the meeting name that was wrongly colored
- Find and ddd these big email IDs like c_188dno8hkhd1oivwiduhwdn76n9s6@resource.calendar.google.com to the array on line 26, these are meeting rooms. acting like external attendeed
- Identify bots - AI, notetakers, meeting records etc. acting like external attendees & add them to the array
- Turn off dryrun & Run the script again.
- Repeat 1-6 if for meetings that still wrongly tagged.