Google Apps Script

Presented by Tom Friedhof

Tom Friedhof

What is Apps Script?

It's JavaScript that runs in the Google Cloud to interface Google Apps such as Spreadsheets, Docs, and Forms.

What can you do with Apps Script?

  • Create add-ons to extend Google Apps
    • Spreadsheets, Docs, Forms
    • Calendar
    • Contacts
    • Maps
    • Gmail
  • ...pretty all Google Apps Services

Hypothetical Scenario

You run a sports league and want to send the official end of game score to the players that played.

Google Contact Records

All players are added to your Google Contacts.

Players are grouped by team name.

Contacts Screenshot

Spreadsheet of scores

Example Spreadsheet

Sample Apps Script

Sample script

Execute these scripts externally

The Execution API allows external apps (your website) to execute functions within Apps Script

https://developers.google.com/apps-script/guides/rest/

Learn more

http://script.google.com Apps Script screenshot

Questions?

Send me an email:

tom@activelamp.com

or in IRC #drupal-la