Web App Development with Google Apps Script

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();

var x=100;