多个Google日历到Google Sheet双向同步问题

function getCalendarEvents(calendarId) {
  var calendar = CalendarApp.getCalendarById(calendarId);
  var events = calendar.getEvents(new Date(), new Date(new Date().getTime() + (7 * 24 * 60 * 60 * 1000))); // 获取一周内的事件
  return events;
}

function writeEventsToSheet(events, sheet) {
  var data = [];
  for (var i = 0; i < events.length; i++) {
    var event = events[i];
    var rowData = [event.getTitle(), event.getDescription(), event.getStartTime(), event.getEndTime()];
    data.push(rowData);
  }
  sheet.getRange(2, 1, data.length, data[0].length).setValues(data);
}

function syncSheetToCalendar(sheet, calendarId) {
  var data = sheet.getDataRange().getValues();
  for (var i = 1; i < data.length; i++) {
    var rowData = data[i];
    var title = rowData[0];
    var description = rowData[1];
    var startTime = rowData[2];
    var endTime = rowData[3];
    var calendar = CalendarApp.getCalendarById(calendarId);
    calendar.createEvent(title, startTime, endTime, {description: description});
  }
}

function syncCalendarsToSheet() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var calendarIds = ["calendarId1", "calendarId2", "calendarId3"]; // 替换为实际的Google日历ID
  for (var i = 0; i < calendarIds.length; i++) {
    var calendarId = calendarIds[i];
    var events = getCalendarEvents(calendarId);
    writeEventsToSheet(events, sheet);
  }
  syncSheetToCalendar(sheet, calendarIds[0]); // 将第一个Google日历作为主日历，将Google Sheet中的数据同步到该日历中
}