function doGet(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var type = (e.parameter && e.parameter.type) || 'places';
  var ws = ss.getSheetByName(type);

  if (!ws) {
    return output({ data: [], error: 'Sheet not found: ' + type });
  }

  var rows = ws.getDataRange().getValues();
  if (rows.length < 2) return output({ data: [] });

  var headers = rows[0];
  var data = [];

  for (var i = 1; i < rows.length; i++) {
    // 첫 번째 컬럼이 비어있으면 빈 행으로 간주해 스킵
    if (rows[i][0] === '' || rows[i][0] === null) continue;

    var obj = {};
    for (var j = 0; j < headers.length; j++) {
      if (headers[j] !== '') {
        obj[String(headers[j])] = rows[i][j];
      }
    }
    data.push(obj);
  }

  return output({ data: data, total: data.length, sheet: type });
}

function output(obj) {
  return ContentService
    .createTextOutput(JSON.stringify(obj))
    .setMimeType(ContentService.MimeType.JSON);
}