function doGet() {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
const data = sheet.getDataRange().getValues();
const headers = data[0];
const approvedIndex = headers.indexOf("approved");
const rows = [];
for (let i = 1; i < data.length; i++) {
const row = data[i];
const isApproved =
row[approvedIndex] === true ||
row[approvedIndex] === "TRUE" ||
row[approvedIndex] === "true";
if (isApproved) {
let obj = {};
for (let j = 0; j < headers.length; j++) {
obj[headers[j]] = row[j];
}
rows.push(obj);
}
}
return ContentService
.createTextOutput(JSON.stringify(rows))
.setMimeType(ContentService.MimeType.JSON);
}
