function doGet(e){ var ss = SpreadsheetApp.getActive(); var sheet = ss.getSheetByName('DATA'); var message = ''; var id = e.parameter.id; var rg = sheet.getRange(2, 1, sheet.getLastRow()-1,sheet.getLastColumn()).getValues(); for(var i = 0;i