Calendar Event Automation with Bold Text Formatting for Google Sheets

This script is currently being utilized by a division within a large educational company to automate the management of events in a Google Calendar. It serves as an automation tool for managing calendar events based on data stored in a Google Sheets spreadsheet. Specifically designed to streamline event creation and updates, the script extracts essential information from the spreadsheet, including dates, times, event names, and descriptions. With this data, it interacts with a Google Calendar to check for existing events that match the same name and start time. If such an event exists, the script updates its description to reflect any changes. In cases where no matching event is found, it proceeds to create a new event. Furthermore, the script offers a user-friendly feature that enables team members to emphasize text by simply enclosing words with double asterisks (**). This approach allows even team members with no HTML coding experience to effortlessly apply bold formatting to text within the event descriptions. To utilize this script effectively, users can customize the sheet name, calendar ID, and column references to align with their specific data structure, ensuring seamless automation of calendar events.