Web App Development with Google Apps Script

From Wikibooks, open books for an open world
Jump to navigation Jump to search
Logo of Google Apps Script.

Outline[edit | edit source]

  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[edit | edit source]

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