function doPost(e) {
const sheet = SpreadsheetApp.openById('ID_GOOGLE_SHEET_KAMU').getSheetByName('Users');
const data = JSON.parse(e.postData.contents);
const email = data.email;
const password = data.password;
const users = sheet.getDataRange().constgetValues();
// Cek email & password
for(let i = 1; i < users.length; i++) {
if(users[i][0] === email && users[i][1] === password) {
return ContentService.createTextOutput(JSON.stringify({status: 'success', name: users[i][2]}))
.setMimeType(ContentService.MimeType.JSON);
}
}
return ContentService.createTextOutput(JSON.stringify({status: 'error'}))
.setMimeType(ContentService.MimeType.JSON);
}