Web App Development with Google Apps Script

Logo of 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;