Андрей Шульга "google apps script"
TRANSCRIPT
PAGE 1 OF 15 | DECEMBER 10, 2016
Google Apps Script
by Andrii Shulha
PAGE 2 OF 15 | DECEMBER 10, 2016
What is app script?
● Javascript
● IDE & debugger
● Cloud platform
● Add-ons to extend
Google apps
● Web apps
PAGE 3 OF 15 | DECEMBER 10, 2016
Google ecosystem
● Chrome web store
● Add-on and extensions
store
● Android Play market
● Google cloud platforms
All with single user account
PAGE 4 OF 15 | DECEMBER 10, 2016
What apps can be used?
Web Apps & Standalone Scripts Container-bound Scripts
Services with internal API
PAGE 5 OF 15 | DECEMBER 10, 2016
Advanced serves and external API
Google Cloud APIs
Compute Engine API
BigQuery API
Cloud Storage Service
Cloud Datastore API
Cloud Deployment Manager API
Cloud DNS API
Google Maps APIs
Google Maps Android API
Google Maps SDK for iOS
Google Maps JavaScript API
Google Places API for Android
Google Places API for iOS
Google Maps Roads API
Google Apps APIs
Drive API
Calendar API
Gmail API
Sheets API
Google Apps Marketplace SDK
Admin SDK
Advertising APIs
AdSense Management API
DCM/DFA Reporting And
Trafficking API
Ad Exchange Seller API
Ad Exchange Buyer API
DoubleClick Search API
DoubleClick Bid Manager API
YouTube APIs
YouTube Data API
YouTube Analytics API
YouTube Reporting API
Mobile APIs
Google Cloud Messaging
Google Play Game Services
Google Play Developer API
Google Places API for
Android
Social APIs
Google+ API
Blogger API
Google+ Pages API
Google+ Domains API
Other popular APIs
Analytics API
Translate API
Custom Search API
URL Shortener API
PageSpeed Insights API
Fusion Tables API
Web Fonts Developer API
PAGE 6 OF 15 | DECEMBER 10, 2016
Why is it so cool?
PAGE 7 OF 15 | DECEMBER 10, 2016
The way it used to be
PAGE 8 OF 15 | DECEMBER 10, 2016
The way it looks now
PAGE 9 OF 15 | DECEMBER 10, 2016
Keep calm and just watch
PAGE 10 OF 15 | DECEMBER 10, 2016
How it looks inside
PAGE 11 OF 15 | DECEMBER 10, 2016
What UI extensions do we have?
Custom menu and add-on menu items
PAGE 12 OF 15 | DECEMBER 10, 2016
What UI extensions do we have?
Simple alert and
prompt message with
text field and buttons
PAGE 13 OF 15 | DECEMBER 10, 2016
What UI extensions do we have?
Custom sidebar and modal dialog
PAGE 14 OF 15 | DECEMBER 10, 2016
Daily Quota Limits
Calendar events created
Contacts created
Documents created
Email recipients per day
Gmail read/write (excluding send)
Property Get or Set
Spreadsheets created
Triggers total runtime
URLFetch calls
URLFetch data received
5000 / day
1000 / day
250 / day
100 / day
20000 / day
50000 / day
250 / day
1 hours / day
20000 / day
100mB / day
10000 / day
2000 / day
1500 / day
1500 / day
50000 / day
500000 / day
3200 / day
6 hours / day
100000 / day
100mB / day
Consumer
(gmail.com)
G Suite
Basic/Business/
Edu/Gov
DECEMBER 10, 2016
Thank you for
staying till the end!
Andrii ShulhaAvailable by:
Skype: shoolga.andrey
E-mail: [email protected]