【GAS】カレンダー作り エラー

GAS

ソースコード function executeInPosting() { //========================================================== // 設定箇所 //========================================================== var CALENDAR_ID = '○○@gmail.com'; var SHIFT1 = 'B'; var SHIFT1_START_TIME = '8:00'; var SHIFT1_END_TIME = '17:00' var SHIFT2 = 'C'; var SHIFT2_START_TIME = '8:30'; var SHIFT2_END_TIME = '17:30' var SHIFT3 = 'H'; var SHIFT3_START_TIME = '9:00'; var SHIFT3_END_TIME = '20:00' var SHIFT4 = 'D'; var SHIFT4_START_TIME = '9:00'; var SHIFT4_END_TIME = '18:00' var SHIFT5 = 'D`'; var SHIFT5_START_TIME = '9:00'; var SHIFT5_END_TIME = '19:00' var SHIFT6 = 'A`'; var SHIFT6_START_TIME = '6:45'; var SHIFT6_END_TIME = '16:00' var YEAR_COLUMN = 'B'; var MONTH_COLUMN = 'C'; var SHIFT1_COLUMN = 'D'; var SHIFT2_COLUMN = 'E'; var SHIFT3_COLUMN = 'F'; var SHIFT4_COLUMN = 'G'; var SHIFT5_COLUMN = 'H'; var SHIFT6_COLUMN = 'I'; //---------------------------------------------------------- var sheet = SpreadsheetApp.getActiveSheet(); bottom = sheet.getLastRow(); var YEAR = sheet.getRange(YEAR_COLUMN + bottom).getValue(); var MONTH = sheet.getRange(MONTH_COLUMN + bottom).getValue(); var SHIFT1 = sheet.getRange(SHIFT1_COLUMN + bottom).getValue(); var SHIFT2 = sheet.getRange(SHIFT2_COLUMN + bottom).getValue(); var SHIFT3 = sheet.getRange(SHIFT3_COLUMN + bottom).getValue(); var SHIFT4 = sheet.getRange(SHIFT4_COLUMN + bottom).getValue(); var SHIFT5 = sheet.getRange(SHIFT5_COLUMN + bottom).getValue(); var SHIFT6 = sheet.getRange(SHIFT6_COLUMN + bottom).getValue(); var SHIFT1List = String(SHIFT1).split(','); var SHIFT2List = String(SHIFT2).split(','); var SHIFT3List = String(SHIFT3).split(','); var SHIFT4List = String(SHIFT4).split(','); var SHIFT5List = String(SHIFT5).split(','); var SHIFT6List = String(SHIFT6).split(','); // シフト1を登録 for (var i = 0; i < SHIFT1List.length) { var dateStr = year + '/' + month + '/' + SHIFT1List[i]; Logger.log(dateStr); var date = new Date(dateStr); Logger.log(date); createEvent(CALENDAR_ID, SHIFT1, date, SHIFT1_START_TIME, SHIFT1_END_TIME); Logger.log('createEvent() is done.'); } // シフト2を登録 for (var i = 0; i < SHIFT2List.length) { var dateStr = year + '/' + month + '/' + SHIFT2List[i]; Logger.log(dateStr); var date = new Date(dateStr); Logger.log(date); createEvent(CALENDAR_ID, SHIFT2, date, SHIFT2_START_TIME, SHIFT2_END_TIME); Logger.log('createEvent() is done.'); } // シフト3を登録 for (var i = 0; i < SHIFT3List.length) { var dateStr = year + '/' + month + '/' + SHIFT3List[i]; Logger.log(dateStr); var date = new Date(dateStr); Logger.log(date); createEvent(CALENDAR_ID,SHIFT3, date, SHIFT3_START_TIME, SHIFT3_END_TIME); Logger.log('createEvent() is done.'); } // シフト4を登録 for (var i = 0; i < SHIFT4List.length) { var dateStr = year + '/' + month + '/' + SHIFT4List[i]; Logger.log(dateStr); var date = new Date(dateStr); Logger.log(date); createEvent(CALENDAR_ID, SHIFT4, date, SHIFT4_START_TIME, SHIFT4_END_TIME); Logger.log('createEvent() is done.'); } // シフト5を登録 for (var i = 0; i < SHIFT5List.length) { var dateStr = year + '/' + month + '/' + SHIFT5List[i]; Logger.log(dateStr); var date = new Date(dateStr); Logger.log(date); createEvent(CALENDAR_ID, SHIFT5, date, SHIFT5_START_TIME, SHIFT5_END_TIME); Logger.log('createEvent() is done.'); } // シフト6を登録 for (var i = 0; i < SHIFT6List.length) { var dateStr = year + '/' + month + '/' + SHIFT6List[i]; Logger.log(dateStr); var date = new Date(dateStr); Logger.log(date); createEvent(CALENDAR_ID, SHIFT6, date, SHIFT6_START_TIME, SHIFT6_END_TIME); Logger.log('createEvent() is done.'); } } // カレンダーに終日のイベントを作成 function createEvent(calendarId, title, date, startTime, endTime) { var calendar = CalendarApp.getCalendarById(calendarId); //calendar.createAllDayEvent(title, date); var startDateTime = new Date(date.getFullYear(), date.getMonth(), date.getDate(), Number(startTime.split(':')[0]), Number(startTime.split(':')[1])); var endDateTime = new Date(date.getFullYear(), date.getMonth(), date.getDate(), Number(endTime.split(':')[0]), Number(endTime.split(':')[1] )); Logger.log('startDateTime'); Logger.log(startDateTime); Logger.log('endDateTime'); Logger.log(endDateTime); calendar.createEvent(title, startDateTime, endDateTime); }