function initialiserColonnes() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  if (sheet.getLastRow() === 0) {
    sheet.appendRow(["ID", "Date Saisie", "Logement", "Voyageur", "Dates Séjour", "Plateforme", "Total Payé", "Virement Reçu", "Ménage OTA", "Ménage Facturé HT", "Autres Frais HT", "Motif Frais", "Taxe Séjour", "Com Plateforme", "Frais Bancaires", "Com Conciergerie HT", "TVA", "Total Facture", "Net Propriétaire"]);
  }
}

function traiterRequete(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  initialiserColonnes();
  var rawPayload = (e && e.parameter && e.parameter.payload) ? e.parameter.payload : (e && e.postData ? e.postData.contents : null);
  if (!rawPayload) return ContentService.createTextOutput("Colonnes pretes (En attente de donnees)").setMimeType(ContentService.MimeType.TEXT);
  var data = JSON.parse(rawPayload);
  var rows = Array.isArray(data) ? data : [data];
  rows.forEach(function(r) {
    sheet.appendRow([r.id, r.date, r.property, r.guest, r.stayDates, r.platform, r.totalPaid, r.platformPayout, r.cleaning, r.cleaningReal, r.extraFeesHT, r.extraLabel, r.tax, r.otaComm, r.bankFees, r.conciergeComm, r.vatAmount, r.conciergeInvoiceTotal, r.ownerFinalKeep]);
  });
  if (e && e.parameter && e.parameter.callback) {
    return ContentService.createTextOutput(e.parameter.callback + "({status:'ok'})").setMimeType(ContentService.MimeType.JAVASCRIPT);
  }
  return ContentService.createTextOutput("SUCCES : Ligne(s) ajoutee(s) dans votre Google Sheet ! Vous pouvez fermer cet onglet.").setMimeType(ContentService.MimeType.TEXT);
}

function doGet(e) { return traiterRequete(e); }
function doPost(e) { return traiterRequete(e); }