육아 꿀팁 모음 🍯

function doGet(e) {
  const sheet = SpreadsheetApp
    .getActiveSpreadsheet()
    .getActiveSheet();
  const rows = sheet.getDataRange().getValues();
  const headers = rows[0];
  const tips = rows.slice(1)
    .filter(r => r[0]) // id 없는 행 제외
    .map(r => {
      const obj = {};
      headers.forEach((h, i) => obj[h] = r[i]);
      return obj;
    });
  return ContentService
    .createTextOutput(JSON.stringify({ tips }))
    .setMimeType(ContentService.MimeType.JSON);
}