Google App Script Calendar - MDev 20231213N
Budget: $10 – $30 USD
We are looking to create a script that bulk creates Google Calendar events from spreadsheet https://docs.google.com/spreadsheets/d/1oSqLw9kLrQ6GGmRJuL56MctNB5gTjJrLvwFIeJ_3xXQ/edit?usp=sharing . 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
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