Google App Script Calendar - MDev 20231213N

We are looking to create a script that bulk creates Google Calendar events from spreadsheet [login to view URL] . Each Row on the spreadsheet should create a single event on Google Calendar. User input is mandatory for Column A (Event Name), Column B (Event Start Date), and Cell H2 (CalendarID). User input is optional for the other columns. After the event is created, the script will generate the event in Column G (Calendar Event). The spreadsheet shows the example events below. • Row 2 is an Example Row and should not be used by the script. The script should begin with user data starting from Row 3. • Row 3 - If only Column A and Column B have data, then script creates an All Day event on that specific date. • Row 4 - If Column C also has data, then script creates an All Day event that spans the date range. • Row 5 - If Column D has data, then script creates an event at that time. • Row 6 - If both Column D and Column E have data, then script creates an event during that time period. • Row 7 - Note that an event can span multiple dates. So Row 7 would start on 2024-01-02 at 8:00 am, to 2024-01-03 at 5:00 pm. Candidates should confirm that they have experience with Google Apps Scripts. Thank you