function myFunction() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('西予市'); sheet.clear(); var row = 1; //新着 var url = 'http://www.city.seiyo.ehime.jp/index.update.json'; //緊急情報 //var url = 'https://www.city.seiyo.ehime.jp/kinkyu/index.update.json'; var result = UrlFetchApp.fetch(url); var json = result.getContentText(); var items = JSON.parse(json); items.forEach(function(item){ sheet.getRange(row, 1).setValue(item.page_name); sheet.getRange(row, 2).setValue(item.url); sheet.getRange(row, 3).setValue(item.publish_datetime); row++; }); }