Web App Development with Google Apps Script/templates

Templates edit

  • Google Apps Script
  var ss=SpreadsheetApp.getActive();
  var sheet=ss.getSheetByName("test");
  var data = sheet.getDataRange().getValues();
var x=100;