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

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

Google Apps Script

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

“JavaScript in the cloud

Apps Script is based on JavaScript 1.6,

plus a few features from 1.7 and 1.8.

Where..

StandaloneSheets DocsForms Sites

“ 3 things that make Google Apps

Script rock

#1 Custom UI

CC-BY Google Inc. Apps Script Menus

#2 Triggers

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

TIME

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

POST/GET

#3 Integration

One liners

One liners

One liners

One liners{ish}

Toast

Auth

Lets play…

…fetch

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

“…fetch

UrlFetchApp.fetch(url, params);

“tags.hawksey.info

“TwtrService: A Twitter

API client library for

Google Apps Script

TwtrService

“Demo…

[tags.hawksey.info/get-tags]

Easy Tweet Sheet

Easy Tweet Sheet

[my link]

Advanced Services

Analytics

Analytics

Analytics

[demo link]

TAGS - Twitter Archiving Google Sheet

Beyond Twitter

Community

developers.google.com/apps-script

Do more

Thank you

+MartinHawksey

@mhawksey