google apps script: the authentic{ated} playground

38
Google Apps Script The authentic{ated} playground + MartinHawksey @ mhawksey h awksey.info This work is licensed under a Creative Commons Attribution 3.0 Unported License. CC-BY mhawksey

Upload: martin-hawksey

Post on 08-Jul-2015

8.834 views

Category:

Technology


1 download

DESCRIPTION

Slides for Devfest London introducing developers to Google Apps Script as playground for integrating with Google and other services

TRANSCRIPT

Page 1: Google Apps Script: The Authentic{ated} Playground

Google Apps Script

The authentic{ated} playground+MartinHawksey

@mhawksey

hawksey.info

This work is licensed under

a Creative Commons Attribution

3.0 Unported License. CC-BY

mhawksey

Page 2: Google Apps Script: The Authentic{ated} Playground
Page 3: Google Apps Script: The Authentic{ated} Playground

CC-BY-NC-ND lukexmartin https://flic.kr/p/9dL4vY

Page 4: Google Apps Script: The Authentic{ated} Playground

Google Apps Script

CC-BY Google – Google Apps Script, 13-03-2012

Page 5: Google Apps Script: The Authentic{ated} Playground

“JavaScript in the cloud

Apps Script is based on JavaScript 1.6,

plus a few features from 1.7 and 1.8.

Page 6: Google Apps Script: The Authentic{ated} Playground

Where..

StandaloneSheets DocsForms Sites

Page 7: Google Apps Script: The Authentic{ated} Playground

“ 3 things that make Google Apps

Script rock

Page 8: Google Apps Script: The Authentic{ated} Playground

#1 Custom UI

CC-BY Google Inc. Apps Script Menus

Page 9: Google Apps Script: The Authentic{ated} Playground

#2 Triggers

CC-BY-NC-ND https://flic.kr/p/8G7fD

TIME

CC-BY https://flic.kr/p/5QNDcr

POST/GET

Page 10: Google Apps Script: The Authentic{ated} Playground

#3 Integration

Page 11: Google Apps Script: The Authentic{ated} Playground

One liners

Page 12: Google Apps Script: The Authentic{ated} Playground

One liners

Page 13: Google Apps Script: The Authentic{ated} Playground

One liners

Page 14: Google Apps Script: The Authentic{ated} Playground

One liners{ish}

Page 15: Google Apps Script: The Authentic{ated} Playground

Toast

Page 16: Google Apps Script: The Authentic{ated} Playground

Auth

Page 18: Google Apps Script: The Authentic{ated} Playground

…fetch

BY-NC-SA https://flic.kr/p/adCUQtBY-NC-SA https://flic.kr/p/bAoEyi

Page 19: Google Apps Script: The Authentic{ated} Playground

“…fetch

UrlFetchApp.fetch(url, params);

Page 20: Google Apps Script: The Authentic{ated} Playground

“tags.hawksey.info

Page 21: Google Apps Script: The Authentic{ated} Playground
Page 22: Google Apps Script: The Authentic{ated} Playground

“TwtrService: A Twitter

API client library for

Google Apps Script

Page 23: Google Apps Script: The Authentic{ated} Playground

TwtrService

Page 24: Google Apps Script: The Authentic{ated} Playground

“Demo…

[tags.hawksey.info/get-tags]

Page 25: Google Apps Script: The Authentic{ated} Playground

Easy Tweet Sheet

Page 26: Google Apps Script: The Authentic{ated} Playground

Easy Tweet Sheet

Page 27: Google Apps Script: The Authentic{ated} Playground
Page 30: Google Apps Script: The Authentic{ated} Playground

Analytics

Page 31: Google Apps Script: The Authentic{ated} Playground

Analytics

Page 33: Google Apps Script: The Authentic{ated} Playground
Page 34: Google Apps Script: The Authentic{ated} Playground

TAGS - Twitter Archiving Google Sheet

Page 35: Google Apps Script: The Authentic{ated} Playground

Beyond Twitter

Page 36: Google Apps Script: The Authentic{ated} Playground

Community

developers.google.com/apps-script

Page 37: Google Apps Script: The Authentic{ated} Playground

Do more

Page 38: Google Apps Script: The Authentic{ated} Playground

Thank you

+MartinHawksey

@mhawksey