Outline

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

Templates

• Google Apps Script

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

1 var x=100;