const SHEET_NAME = "Odpowiedzi";
function doPost(e) {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(SHEET_NAME)
|| SpreadsheetApp.getActiveSpreadsheet().insertSheet(SHEET_NAME);
if (sheet.getLastRow() === 0) {
const headers = ["timestamp", "wiek", "plec", "trans", "orientacja"];
for (let i = 1; i <= 33; i++) headers.push("poz_" + i);
headers.push("wynik_21poz");
sheet.appendRow(headers);
}
const data = JSON.parse(e.postData.contents);
const row = [
data.timestamp || new Date().toISOString(),
data.age || "",
data.gender || "",
data.trans || "",
data.orientation || ""
];
for (let i = 1; i <= 33; i++) {
row.push(data.answers && data.answers[i] !== undefined ? data.answers[i] : "");
}
row.push(data.total_score_21item || "");
sheet.appendRow(row);
return ContentService.createTextOutput(JSON.stringify({status: "ok"}))
.setMimeType(ContentService.MimeType.JSON);
}
function doGet(e) {
return ContentService.createTextOutput("GQ-ASC backend dziala. Wysylaj dane metoda POST.");
}