Contact Urgence & Géolocalisation

function doPost(e) {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    
    // Parse incoming JSON payload from Next.js API
    var data = JSON.parse(e.postData.contents);
    
    // If sheet is empty, add header row
    if (sheet.getLastRow() === 0) {
      sheet.appendRow(["Date", "Nom", "Téléphone", "Email", "Service", "Ville", "Message"]);
    }
    
    // Append lead data
    sheet.appendRow([
      data.date || new Date().toLocaleString(),
      data.nom || '',
      data.telephone || '',
      data.email || '',
      data.service || '',
      data.ville || '',
      data.message || ''
    ]);
    
    return ContentService
      .createTextOutput(JSON.stringify({ "result": "success" }))
      .setMimeType(ContentService.MimeType.JSON);
      
  } catch (error) {
    return ContentService
      .createTextOutput(JSON.stringify({ "result": "error", "error": error.toString() }))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

function doGet(e) {
  return ContentService
    .createTextOutput("Google Sheets Web App is active and ready to receive leads!")
    .setMimeType(ContentService.MimeType.TEXT);
}