IT Notes : Using Google Apps Script to update Google Calendar events from Google Sheet
Steps to update Google Calendar from Google spreadsheet 1. Choose Calendar for update. 2. Access the Calendar using Google Calendar ID • var cal = CalendarApp.getCalendarById("xxxxx@gmail.com"); 3. Identify the spreadsheet containing Calendar event data, e.g. sheet name = GetEvents • var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("GetEvents"); 4. Specifiy cells that we want to grab data from • var dataRange = mySpreadsheet.getRange("B2:C46"); 5. Import data from the spreadsheet var data = dataRange.getValues(); 6. Create Calendar events from spreadsheet with sheet name = GetEvents • myCalendar.createEvent(myTitle, myStartTime, myEndTime, {location: myLocation, description: myDescription}); Create a Google Sheet with 5 columns Name of Event, Start date/time, End date/ti...