function doPost(e) {
  try {
    const sheet = SpreadsheetApp.openById('1zdv9RpJd1W-FdkpPu_iozdXCdVQqN4IHvaVmNTHHSJw').getActiveSheet();
    const data = JSON.parse(e.postData.contents);
    
    sheet.appendRow([
      data.date,
      data.time,
      data.name,
      data.status,
      data.class,
      data.purpose,
      data.otherPurpose,
      data.email,
      data.timestamp
    ]);
    
    return ContentService.createTextOutput('Success');
  } catch (error) {
    return ContentService.createTextOutput('Error: ' + error.toString());
  }
}