Spreadsheet with Google Script App that enables to automatically color events This enables user to automtically color events on google calendar that meet certain criter (title include certain word or received/sent with specific email domains) The Spreadsheet itself includes an explanation, the settings the user need to configure and also menu options to initiailize and run the script To get this solution on your account you can do two things:
- Use this url https://docs.google.com/spreadsheets/d/1308HNWdLj8Xdm73l2e6ytR7T_itsUrlTuVOKHRbyJ9I/copy and make a copy for you
- Create a new google sheet, and enter the code under Extensions > Apps Script (You need to be familiar with App Script)
To use the solution once you did one of above
- The sheet should open automtically after you made the copy. Wait around 15 seconds for the menu to populate
- (First Time) Select Menu SCRIPT_STARTER > Click to Authorize. (You should only need to do steps 2-6 once ever)
- Click continue to authorize
- Select your google account
- You will get a prompt that the app has not been verified. Sorry don't have plans to "verify it". The script is not malicious and code is posted here. Select Advanced, then "Go to ColorToCalendarScript"
- You will get prompted to authorize. Do so
- Review the instructions. The script changes calendar events in a period of time (days before / after it runs). Enter how many days on the appropriate field
- Enter the string you want to match in the title. You can enter several strings comma separated
- Now to run the script manually: SCRIPT_STARTER > Run Manually
- Now to run the script automatically every 5 minutes: SCRIPT_STARTER > Run Automatically every 5 minutes. It will run even if spreadsheet is closed, computer turned off, etc
- If you want to cancel automatic run SCRIPT_STARTER > Cancel Automatic Run
Best to test first to understand how it works:
a. Enter "Gobbledegook" on the spreadsheet under Title for example (C14)
b. Enter gmail.com on the spreadsheet under Domains for example (D16)
c. Create a calendar event with title "The word of the year is Gobbledegook for 2022" for today
d. Create a calenader event and invite somebody with email @gmail.com for today
e. Run script manually