function doPost(e) {
  try {
    var data = JSON.parse(e.postData.contents);
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    
    // Create header row if sheet is completely fresh/empty
    if (sheet.getLastRow() === 0) {
      sheet.appendRow([
        "Booking ID", 
        "Date & Time Slot", 
        "Therapist Name", 
        "Therapist Gender", 
        "Employee Name", 
        "Employee Email", 
        "Department", 
        "Focus Area", 
        "Timestamp"
      ]);
    }
    
    // Append the dynamic booking response
    sheet.appendRow([
      data.id,
      data.slotLabel,
      data.therapistName,
      data.therapistGender,
      data.name,
      data.email,
      data.department,
      data.focusArea,
      data.bookedAt
    ]);
    
    return ContentService.createTextOutput(JSON.stringify({ 
      "status": "success", 
      "message": "Response updated to Sheet!" 
    })).setMimeType(ContentService.MimeType.JSON);
    
  } catch (error) {
    return ContentService.createTextOutput(JSON.stringify({ 
      "status": "error", 
      "message": error.toString() 
    })).setMimeType(ContentService.MimeType.JSON);
  }
}

function doGet(e) {
  return ContentService.createTextOutput(JSON.stringify({ 
    "status": "online", 
    "message": "Pamper Bubbles integration active!" 
  })).setMimeType(ContentService.MimeType.JSON);
}