function doGet(e) {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
const data = sheet.getDataRange().getValues();
const rows = data.map(row => ({
time: row[0],
date: row[1],
door: row[2]
}));
return ContentService
.createTextOutput(JSON.stringify(rows))
.setMimeType(ContentService.MimeType.JSON);
}
function doPost(e) {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
const params = JSON.parse(e.postData.contents);
sheet.appendRow([
params.time || new Date().toISOString(),
params.date || new Date().toLocaleDateString(),
params.door || "UNKNOWN"
]);
return ContentService
.createTextOutput(JSON.stringify({ status: "ok" }))
.setMimeType(ContentService.MimeType.JSON);
}
