function getData() {
  const sheet = SpreadsheetApp.openById("YOUR_SPREADSHEET_ID");
  let rows = sheet.getDataRange().getValues();
  let keys = rows.splice(0, 1)[0];
  let data = {};
  rows.forEach(function(row) {
    data[row[0]] = {};
    row.map(function(item, index) {
      if(index > 0) {
        if(keys[index] == "mobileNumber") {
          data[String(row[0])]["mobileNumber"] = "+" + item;
        } else {
          data[String(row[0])][String(keys[index])] = item;
        }
      }
    });
  });
  return data;
}

function upsertUsers() {
  // チャネルトークのOpenAPIを利用するための設定
  const url = "https://api.channel.io/open/v3/users";
  const headers = {
    "X-Access-Key": "YOUR_ACCESS_KEY",
    "X-Access-Secret": "YOUR_ACCESS_SECRET",
    "Content-Type": "application/json"
  };
  let options = {
    "method": "POST",
    "payload": JSON.stringify(getData()),
    "headers": headers
  };
  
  // チャネルトークのOpenAPIに顧客情報を更新するリクエストを送信
  let response = UrlFetchApp.fetch(url, options);
  Logger.info(url + ":responscode>>>" + response.getResponseCode() + ":body>>>" +response.getContentText());
}