Here is my Script may be you can help me 
function doPost(e) {
var ss = SpreadsheetApp.openByUrl(e.parameter.File);
var sheet = ss.getSheetByName(e.parameter.Sheet);
ActionsFichier(e,sheet);
}
function ActionsFichier(e,sheet) {
//lock sheet to prevent concurrent changes
var lock = LockService.getPublicLock();
lock.waitLock(5000);
//DELETE STOCK SINGLE RECORD
if (e.parameter.func == "Delete") {
var record = e.parameter.id;
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
sh.deleteRow(parseInt(record) + 1);
return ContentService.createTextOutput("Success");
}
//DELETE SHOP SINGLE RECORD
if (e.parameter.func == "Delete_Shops") {
var record = e.parameter.id;
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
sh.deleteRow(parseInt(record) + 1);
return ContentService.createTextOutput("Success");
}
// Add
if (e.parameter.Action=="Add") {
var qrcode = e.parameter.Qrcode ;
var item = e.parameter.Item ;
var box = e.parameter.Box ;
var inbox = e.parameter.Inbox ;
var outbox = e.parameter.Outbox ;
var oprice = e.parameter.Oprice ;
var sprice = e.parameter.Sprice ;
var category = e.parameter.Category ;
sheet.appendRow([qrcode,item,box,inbox,outbox,oprice,sprice,category]);
return ContentService.createTextOutput("Success");
}
// Add SHOP
if (e.parameter.Action=="Add_Shops") {
var shopname = e.parameter.Shopname ;
var shopphone = e.parameter.Shopphone ;
sheet.appendRow([shopname,shopphone]);
return ContentService.createTextOutput("Success");
}
//EDIT SHOP SINGLE RECORD
else if (e.parameter.func == "Update_Shops") {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
var data = [ [ e.parameter.Shopname, e.parameter.Shopphone]];
sh.getRange("A"+(parseInt(e.parameter.id)+1)+":B"+(parseInt(e.parameter.id)+1)).setValues(data);
return ContentService.createTextOutput("Sucesso");
}
//EDIT STOCK SINGLE RECORD
else if (e.parameter.func == "Update") {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
var data = [ [ e.parameter.Qrcode, e.parameter.Item, e.parameter.Box, e.parameter.Inbox, e.parameter.Outbox, e.parameter.Oprice, e.parameter.Sprice, e.parameter.Category]];
sh.getRange("A"+(parseInt(e.parameter.id)+1)+":H"+(parseInt(e.parameter.id)+1)).setValues(data);
return ContentService.createTextOutput("Sucesso");
}
lock.releaseLock();
}