Copy â Extensions â Apps Script â Paste â Deploy â Web App (access: “Anyone”)
function doGet(e){return handleRequest(e)}function doPost(e){return handleRequest(e)}function handleRequest(e){try{var a=e.parameter.action,r;switch(a){case'getStructure':r=getSheetStructure();break;case'getRows':r=getAllRows();break;case'updateRow':r=updateRow(parseInt(e.parameter.rowIndex),JSON.parse(e.parameter.data));break;case'addRow':r=addNewRow(JSON.parse(e.parameter.data));break;case'deleteRow':r=deleteRow(parseInt(e.parameter.rowIndex));break;default:r={error:'Invalid action'}}return ContentService.createTextOutput(JSON.stringify(r)).setMimeType(ContentService.MimeType.JSON)}catch(err){return ContentService.createTextOutput(JSON.stringify({error:err.toString()})).setMimeType(ContentService.MimeType.JSON)}}function getSheetStructure(){var s=SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();return{headers:s.getRange(1,1,1,s.getLastColumn()).getValues()[0],sheetName:s.getName()}}function getAllRows(){var s=SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(),d=s.getDataRange().getValues(),h=d[0],rows=[];for(var i=1;i