Sheet Backend Generator

function doPost(e) {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var data = JSON.parse(e.postData.contents);
    
    var headers = sheet.getRange(1, 1, 1, Math.max(1, sheet.getLastColumn())).getValues()[0];
    var row = [];
    
    for (var i = 0; i < headers.length; i++) {
       var header = headers[i];
       if (header) {
           row.push(data[header] !== undefined ? data[header] : "");
       }
    }
    
    if (row.length === 0) {
        // If no headers, just append values in order
        sheet.appendRow(Object.values(data));
    } else {
        sheet.appendRow(row);
    }
    
    return ContentService.createTextOutput(JSON.stringify({"success": true, "message": "Row added"}))
      .setMimeType(ContentService.MimeType.JSON);
  } catch (err) {
    return ContentService.createTextOutput(JSON.stringify({"success": false, "error": err.toString()}))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

function doGet(e) {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var data = sheet.getDataRange().getValues();
    if (data.length <= 1) {
      return ContentService.createTextOutput(JSON.stringify({"success": true, "data": []}))
        .setMimeType(ContentService.MimeType.JSON);
    }
    
    var headers = data[0];
    var result = [];
    
    for (var i = 1; i < data.length; i++) {
      var obj = {};
      for (var j = 0; j < headers.length; j++) {
        if(headers[j]) {
          obj[headers[j]] = data[i][j];
        }
      }
      result.push(obj);
    }
    
    return ContentService.createTextOutput(JSON.stringify({"success": true, "data": result}))
      .setMimeType(ContentService.MimeType.JSON);
  } catch (err) {
    return ContentService.createTextOutput(JSON.stringify({"success": false, "error": err.toString()}))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

// Example POST request to add a row
async function addRow(data) {
  const url = 'YOUR_WEB_APP_URL';
  
  const response = await fetch(url, {
    method: 'POST',
    body: JSON.stringify(data),
    headers: {
      'Content-Type': 'text/plain;charset=utf-8', 
    }
  });
  
  const result = await response.json();
  console.log(result);
}

// Make sure your sheet has headers like "name", "email", "message" in Row 1
addRow({ name: "John Doe", email: "[email protected]", message: "Hello!" });

// Example GET request to fetch all rows
async function getRows() {
  const url = 'YOUR_WEB_APP_URL';
  
  const response = await fetch(url);
  const result = await response.json();
  
  console.log(result.data);
}