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;
}
iterator