Copy button to copy the code snippet.function doGet(req) {
// ✅ Get active spreadsheet and target sheet
var doc = SpreadsheetApp.getActiveSpreadsheet();
var sheet = doc.getSheetByName('sheet1'); // ensure sheet name is exact
var values = sheet.getDataRange().getValues();
var output = [];
// ✅ Loop through each row (skip header)
for (var i = 1; i < values.length; i++) {
var rowObject = {};
// ✅ Loop through columns until empty cell or 100 columns
for (var j = 0; j < 100; j++) {
if (!values[0][j]) break; // stop if header cell is empty
if (typeof values[i][j] === 'undefined') break;
rowObject[values[0][j]] = values[i][j];
}
output.push(rowObject);
}
// ✅ Return JSON response
return ContentService
.createTextOutput(JSON.stringify({ data: output }))
.setMimeType(ContentService.MimeType.JSON);
}