Web App Development with Google Apps Script/templates

• Google Apps Script

  var ss=SpreadsheetApp.getActive();
  var sheet=ss.getSheetByName("test");
  var data = sheet.getDataRange().getValues();

var x=100;