Web App Development with Google Apps Script

OutlineEdit

  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

TemplatesEdit

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