Gesundheitsprotokoll

const SHEET_ID = 'DEINE_SHEET_ID_HIER';

function doGet(e) {
  try {
    const d = e.parameter;
    const ss = SpreadsheetApp.openById(SHEET_ID);
    const ts = new Date().toISOString();
    const out = (v) => v || "";

    if (d.type === "ernaehrung") {
      ss.getSheetByName("Ernährung").appendRow([
        ts, d.datum, d.uhrzeit, d.mahlzeit,
        d.lebensmittel, out(d.menge), out(d.notizen)
      ]);
    } else if (d.type === "symptom") {
      ss.getSheetByName("Symptome").appendRow([
        ts, d.datum, d.uhrzeit, d.typ,
        out(d.ort), d.schweregrad, d.beschreibung,
        out(d.ausloeser), out(d.stimmung),
        out(d.schlafstunden), out(d.schlafqualitaet), out(d.notizen)
      ]);
    }

    return ContentService
      .createTextOutput(JSON.stringify({status:"ok"}))
      .setMimeType(ContentService.MimeType.JSON);
  } catch(err) {
    return ContentService
      .createTextOutput(JSON.stringify({status:"error",msg:err.toString()}))
      .setMimeType(ContentService.MimeType.JSON);
  }
}