mattash

function getTickets() {
 var sheet = SpreadsheetApp.openById("SPREADSHEET_ID").getSheetByName("SHEET_NAME_WITH_SUM");
 var count = sheet.getRange("LOCATION_OF_CELL");
 return count.getValue();
}


function doGet() {
  var result = {
    "TITLE_OF_SUM":this.getTickets()

mattash

  function doGet(request) {
    var output = ContentService.createTextOutput();
    var data = {};
    var id = "ID";
    var sheet = "SHEETNAME";
    var ss = SpreadsheetApp.openById(id);
    if (sheet) {
      data = readData_(ss, sheet);
    } 
    output.setContent(JSON.stringify(data));