GASでjsonをスプレッドシートに展開

auto-worker.com

function myFunction() {

  const url = "https://mls.js2hgw.com/update.php?base_enb=737280&output=json";

  let response = UrlFetchApp.fetch(url).getContentText();
  let json = JSON.parse(response);

  // headers
  const headers = Object.keys(json[0]);

  // headers をループして生成した配列を body 配列にまとめる
  const body = json.map((row) => {
    return headers.map((key) => row[key] || "");
  });

  // headers と body を結合
  const table = [headers].concat(body);

  // setValues
  const spreadSheet = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = spreadSheet.getActiveSheet();
  sheet.getRange(1, 1, table.length, table[0].length).setValues(table);

}