How do I modify a google calendar event using google apps script?

Question

I figured out how to add an event to a calendar, but then spent a good 8 hours trying to figure out how to edit an existing event (or delete it, either way would get the job done). Here's what I've got: ``` function UpdateEventTime() { var cal = CalendarApp.getCalendarById("semehjawioe@group.calendar.google.com"); var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 1; // First row of data to process var numRows = 1; // Number of rows to process var dataRange = sheet.getRange(startRow, 5, numRows, 5); var data = dataRange.getValues(); // var oldtstart = SpreadsheetApp.getActiveSheet().getRange('G2'); // var oldtstop = SpreadsheetApp.getActiveSheet().getRange('H2'); // ?????????????????????????????????????????????????? // ?? How do I call up and delete the old event? ?? // ?????????????????????????????????????????????????? for (i in data) { var row = data[i]; var title = row[0]; // First column var desc = row[1]; // Second column var tstart = row[2]; var tstop = row[3]; var loc…

Accepted Answer

It would be better if you manage to save the event Ids in spreadsheet along with those details. If you need to modify or delete those event, just fetch the event by id and do the things.

Modified code For saving

```
var event = cal.createEvent(title, tstart, tstop, {description:desc,location:loc});
var eventid = event.getId();
SpreadsheetApp.getActiveSheet().getRange('I2').setValue(eventid);
```

To fetch the event back at later time

```
var id = SpreadsheetApp.getActiveSheet().getRange('I2');
var cal = CalendarApp.getCalendarById("semehjawioe@group.calendar.google.com");
var event = cal.getEventSeriesById(id);
//Now modify or delete the event
event.addEmailReminder(minutesBefore);
event.addGuest(email);
event.deleteEvent();
.
.
.
```

Hope this will help you

How do I modify a google calendar event using google apps script?

Solution

Problem