【GAS】Togglの時間データを抽出するプログラムを作る

var CACHE_KEY          = 'toggl_exporter:lastmodify_datetime';
var TIME_OFFSET        = 9 * 60 * 60; // JST
var TOGGL_API_HOSTNAME = 'https://api.track.toggl.com';
var TOGGL_BASIC_AUTH   = '★自身のTogglのAPIトークン:api_token';
var authData = Utilities.base64Encode(TOGGL_BASIC_AUTH);
var ss = SpreadsheetApp.openById("★自身のスプレッドシートの該当ID")
var sheet = ss.getSheetByName("データ")
var lastRow = sheet.getLastRow();
var lastCol = sheet.getLastColumn();
var p_names = sheet.getRange(1,2,1,lastCol-1).getValues();
var arr = []
var now = new Date();
var date = new Date(now.getFullYear(),now.getMonth(),now.getDate());
date.setDate(date.getDate()-1);
var date_gt = date.getTime();

function watch() {
  try {
    var time_entries = getTimeEntries(date_gt);

    for(var i = 0;i < time_entries.length;i++){
      var start_time = time_entries[i]["start"];
      var month1 = Number(start_time.substr(5,2))
      var time1 = Number(start_time.substr(11,2))
      var start_time_jpn = new Date(start_time.substr(0,4),month1-1,start_time.substr(8,2),time1+9,start_time.substr(14,2),start_time.substr(17,2))
      var start_time_gt = start_time_jpn.getTime();
      var start_time_d = new Date(start_time_jpn.getFullYear(),start_time_jpn.getMonth(),start_time_jpn.getDate())
      var start_time_d_gt = start_time_d.getTime();
      if(date_gt == start_time_d_gt){
        var pid = time_entries[i]["pid"]
        var p_name = getProjectName(pid,authData)
        var stop_time = time_entries[i]["stop"];
        var month2 = Number(stop_time.substr(5,2))
        var time2 = Number(stop_time.substr(11,2))
        var stop_time_jpn = new Date(stop_time.substr(0,4),month2-1,stop_time.substr(8,2),time2+9,stop_time.substr(14,2),stop_time.substr(17,2))
        var stop_time_gt = stop_time_jpn.getTime();
        //var minutes = Math.ceil((stop_time_gt - start_time_gt)/(1000*60))
        var minutes = (stop_time_gt - start_time_gt)/(1000*60)
        //var minutes = (stop_time_gt - start_time_gt)/(1000)
        var flg = false;
        if(arr.length !== 0){
          for(var j = 0;j < arr.length;j++){
            if(p_name == arr[j][0]){
              flg = true
              break;
            }
          }
          if(flg == true){
            arr[j].push(minutes)
          }else{
            arr.push([p_name,minutes])
          }
        }else{
          arr.push([p_name,minutes])
        }
      }
    }

    var arr2 = [];
    for(var i = 0;i < arr.length;i++){
      var min = 0;
      if(arr[i].length > 2){
        for(var j = 1;j < arr[i].length;j++){
          min = min + arr[i][j];
        }
        arr2.push([arr[i][0],min])
      }else{
        arr2.push([arr[i][0],arr[i][1]])
      }
    }

    var arr3 = [];
    arr3.push(date)
   var flg = false
   var data = ""
    for(var k = 0;k < p_names[0].length;k++){
    for(var j = 0;j < arr2.length;j++){
    if(arr2[j][0] == p_names[0][k]){
    flg = true
    data = arr2[j][1]
    break;
  }else{
  flg = false
  }
  }
    if(flg == true){
    arr3.push(data)
    }else{
    arr3.push("")
  }
  }
    sheet.getRange(lastRow+1,1,1,arr3.length).setValues([arr3])
  }
  catch (e) {
    Logger.log(e);
  }
}

function getTimeEntries(unix_timestamp) {
  var uri = TOGGL_API_HOSTNAME + '/api/v8/time_entries' + '?' + 'start=' + unix_timestamp;
  var response = UrlFetchApp.fetch(
    uri,
    {
      'method' : 'GET',
      'headers' : { "Authorization" : " Basic " + authData},
      'muteHttpExceptions': true
    }
  );
  try {
    return JSON.parse(response);
  }
  catch (e) {
    Logger.log([unix_timestamp, e]);
  }
}

function getWorkspaceId(authData){
  var currentUrl = "https://www.toggl.com/api/v8/workspaces";
  var options = {
    'headers' : {"Authorization" : "Basic " + authData}
  }
  var response = UrlFetchApp.fetch(currentUrl, options);
  var json = JSON.parse(response.getContentText());
  return json[0].id;
}

function getProjectName(pid,authData){
  var workspace_id = getWorkspaceId(authData)
  var currentUrl = "https://www.toggl.com/api/v8/workspaces/" + workspace_id + "/projects";
  var options = {
    'headers' : {"Authorization" : "Basic " + authData}
  }
  var response = UrlFetchApp.fetch(currentUrl, options);
  var json = JSON.parse(response.getContentText());
  for(var i = 0;i < json.length;i++){
    if(pid == json[i].id){
      var p_name = json[i].name
    }
  }
  return p_name;
}