Web App Development with Google Apps Script

From Wikibooks, open books for an open world
Jump to navigation Jump to search


  1. Why GAS
  2. Hello world for GAS web pages
  3. Templated html
  4. Data from spreadsheets
  5. Responding to users
  6. Data to spreadsheets
  7. Authenticate users
  8. Appendix: syntax
  9. Appendix: exercises


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