DMM英会話スケジュール自動登録スクリプト

dmmEikaiwa.js

/*
 * DMM英会話のスケジュールを登録する
 */
var CALENDAR_NAME = 'YOUR CALENDAR NAME';
var SEARCH_QUERY = 'is:unread subject:"【DMM英会話】レッスン予約完了のお知らせ"';
 
function registDMMEikaiwaCalendar() {
  // 指定したカレンダーを取得
  var calendars = CalendarApp.getCalendarsByName(CALENDAR_NAME);
  var calendar;
  if (calendars.length === 0) {
    Logger.log(CALENDAR_NAME + "カレンダーが見つかりません");
    return;
  } else {
    calendar = calendars[0];
  }
  var threads = GmailApp.search(SEARCH_QUERY, 0, 1);
  if (threads.length === 0) {
    Logger.log("メールが見つかりません");
    return;
  }
  
  var thread = threads[0]
  var messages = thread.getMessages();
  var message = messages[messages.length-1];
  var body = message.getBody();
  body = body.replace(/<br \/>/g, "");
  // Logger.log("message body: " + body);
  
  var teacher = null;
  var teacherName = null;
  var teacherSkypeName = null;
  var reservedDate = null;
  var startAt = null;
  var date = null;
  var startTime = null;
  
  var rows = body.split("\n");
  for (var i in rows) {
    var row = rows[i];
    if (row.indexOf("講師名") === 0) {
      teacher = row;
      teacherName = teacher.replace("講師名：", "");
      Logger.log(teacherName);
    } else if (row.indexOf("講師Skype名") === 0) {
      teacherSkypeName = row;
    } else if (row.indexOf("ご予約日") === 0) {
      reservedDate = row;
      date = row.replace("ご予約日：", "");
      date = date.replace("年", "/");
      date = date.replace("月", "/");
      date = date.replace("日", "/");
    } else if (row.indexOf('開始時間') === 0) {
      startAt = row;
      startTime = startAt.replace("開始時間：", "");
      startTime = startTime.replace("時", ":");
      startTime = startTime.replace("分", "");
    }
  }
  
  var startDateStr = date + " " + startTime;
  var startDate = new Date(startDateStr);
  var endDate = new Date(startDate);
  endDate.setMinutes(endDate.getMinutes() + 25);
  
  Logger.log("startDate: " + startDate);
  Logger.log("endDate: " + endDate);

  if (teacher && teacherSkypeName && reservedDate && startAt && date) {
    var title = "DMM英会話 " + teacherName + "先生";
    var contents = [teacher, teacherSkypeName, reservedDate, startAt];
    var content = contents.join("\n");
    Logger.log(title);
    Logger.log(content);
    // カレンダーに追加
    calendar.createEvent(title, startDate, endDate, {description: content});
    thread.markRead();
  }
}