const sheetID = "1DalaGJ3rGHmagpUqq3aOXSKRkyZQapfw-bCNTW5lgBE";
const sheetName = "data";

function doGet(e) {
  var coordinates = [1, 1, 1, 3];         //just grab a few cells from the spreadsheet
  var params = JSON.stringify(e);
  var htmlOutput = HtmlService.createTemplateFromFile('index');
  htmlOutput.params = params;
  htmlOutput.update = 'updated value is: ' + e.parameter['update'];
  htmlOutput.row = 'row is: ' + e.parameter['row'];
  coordinates[0] = row;
  coordinates[2] = row;
  htmlOutput.values = read(coordinates);
  htmlOutput.url = getUrl();
  return htmlOutput.evaluate();
}

function read(coordinates) {
  var sheet = SpreadsheetApp.openById(sheetID);
  var data = sheet.getSheetByName(sheetName);
  var range = data.getRange(coordinates[0], coordinates[1], coordinates[2], coordinates[3]);
  var values = range.getValues();
  Logger.log(values);
  return values;
}

function getUrl() {
  var url = ScriptApp.getService().getUrl();
  return url;
}