Google Sheets のデータを JSON 形式で取得する Web API をサクッと作る - Qiitafunction getData_(sheetName) { const sheet = SpreadsheetApp.getActive().getSheetByName(sheetName); const rows = sheet.getDataRange().getValues(); const keys = rows.splice(0, 1)[0]; return rows.map(row => { const obj = {}; row.map((item, index) => { obj[String(keys[index])] = String(item); }); return obj; }); } function doGet() { var data = getData_('Sheet1'); return ContentService.createTextOutput
