My Hotel

function doGet(e) {
  var action = e.parameter.action || 'get';
  var sheet = SpreadsheetApp.getActiveSpreadsheet()
    .getSheetByName('Form Responses 1') || SpreadsheetApp.getActiveSheet();

  if (action === 'get') {
    var data = sheet.getDataRange().getValues();
    var headers = data[0];
    var rows = (res && (res.arrivals || res.data || res.rows || [])) || []; }).map(function(row, idx) {
      var obj = {};
      headers.forEach(function(h,i){ obj[h] = row[i] instanceof Date ? Utilities.formatDate(row[i], 'Asia/Kolkata', 'yyyy-MM-dd HH:mm:ss') : row[i]; });
      obj['Booking ID'] = 'BO-' + String(idx+1).padStart(3,'0');
      if (!obj['Status']) obj['Status'] = 'Pending';
      return obj;
    });
    return ContentService.createTextOutput(JSON.stringify(rows))
      .setMimeType(ContentService.MimeType.JSON);
  }
}