Untitled



const SHEET_ID = "1DalaGJ3rGHmagpUqq3aOXSKRkyZQapfw-bCNTW5lgBE";
const SHEET_NAME = "data";
var row = null;

function doGet(e) {
  var params = JSON.stringify(e);
  e.parameter['row'] == null ? row = 1 : row = e.parameter['row'];

  var htmlOutput = HtmlService.createTemplateFromFile('index');
  htmlOutput.params = params;
  htmlOutput.update = 'updated value is: ' + e.parameter['update'];
  htmlOutput.row = 'row is: ' + row;
  htmlOutput.values = read();
  htmlOutput.url = getUrl();
  return htmlOutput.evaluate();
}

function read() {
  var sheet = SpreadsheetApp.openById(SHEET_ID);
  var data = sheet.getSheetByName(SHEET_NAME);
  var range = data.getRange(row, 1, 1, 3);
  var values = range.getValues();
  Logger.log(row);
  Logger.log(values);
  row++;
  Logger.log(row);
  return values;
}

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


<!DOCTYPE html>

<html>

<head>
  <base target="_top">
</head>

<body>
  <h1>iterator</h1>
  <form action="<?= url ?>" method="GET">
    note <input type="text"  name="update" />
    <br>
    <input type="submit" name="Submit" /><br> <br> <br>
    <input type="hidden"   name="row" value="2">
    <span><?= params ?></span> <br> <br> <br>
    <span><?= update ?></span> <br> <br>
    <span><?= row  ?></span> <br> <br> <br> <br>
    <span><?= values ?></span> <br>
  </form>

</body>

</html>