Cetak Data Anggota

function doGet(e) { // GANTI dengan ID Google Sheet Anda var sheetId = "ID_GOOGLE_SHEET_ANDA"; var sheet = SpreadsheetApp.openById(sheetId).getActiveSheet(); var data = sheet.getDataRange().getValues(); var headers = data[0]; var rows = []; // Ambil parameter pencarian dari URL (misal: ?q=madiun) var query = e.parameter.q ? e.parameter.q.toLowerCase() : ""; for (var i = 1; i < data.length; i++) { var row = data[i]; var match = false; var rowData = {}; for (var j = 0; j < row.length; j++) { rowData[headers[j]] = row[j]; if (query === "" || row[j].toString().toLowerCase().indexOf(query) > -1) { match = true; } } if (match) { rows.push(rowData); } } var result = JSON.stringify(rows); return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON); }