Original subtitles

If you're using or thinking of using

Google Apps and especially if you've

come over from Microsoft Office you may

be wondering how to automate and enhance

the platform just like you could do with

your previous solution Apps Script is

Google's cloud base scripting language

it can be used to build applications to

extend what you can do with the Google

Apps environment the underlying language

of Apps Script is JavaScript and it can

perform a similar role to that of VBA

for office but it can do so much more

than that it's in the cloud and it runs

on Google servers so it talks very

easily with api's not just those created

by Google but with millions of other

services that are out there just waiting

to be in the grid with your documents

and apps this series of screencasts is

designed to take you step-by-step

through how to work with the complete

Apps Script platform starting with the

architecture of Apps Script and how to

use the development environment it will

show some of the new processes to apply

when working in a shared cloud

environment if you don't already know

JavaScript it will take you through the

fundamentals as a language so you can

learn enough to be able to competently

follow and build on the examples but

also with some hints on the style used

in the course there are just a few

slides throughout the entire series of

screencasts with almost all of the

content concentrate on coding examples

of how to do things in Apps Script in

fact one of the end results of working

through each of the chapters is that

useful code is added to a cumulative

library that's used in subsequent

examples and then your real work when

you come to apply what you've learned

there is a lot of ground to cover there

are over 40 services and advanced

services in the Apps Script platform in

addition to examples of integration with

external API so the pace is very fast

you'll be doing complicated things very

quickly the frost service that's covered

in detail is spreadsheets and by the end

of it you'll be able to manipulate

spreadsheet data in formats write custom

formats pick up there from external API

and create charts the document service

chapter will demonstrate how to navigate

and format Google Documents and

automatically create

and modified content from external AP is

the next major service will look at is

Gmail and how to send messages process

your mailbox followed by chapters and

manipulating contacts and creating

calendar events by now we'll have

covered the major common Apps Script

services and can start to look in more

detail how to get data from external API

so this chapter has a nice example of

getting images from a select camera on

the Mars Lander yes really saving it to

drive and mailing it to someone and

here's the email I just got

moving on to some of the more advanced

services a lesson on Drive shows how to

convert images to text save them to

drive and then search drive for files

containing that text the example uses

this image of a 100 year old document in

the lesson authentication and

authorization are very complex subjects

and can take some time to get your head

around in a cloud environment or apps

often end up being a patchwork of

services and data from different API

providers getting the authentication

right is a major headache Google uses

OAuth 2 for both authentication and

authorization as do many other providers

there is a deep dive in how all this

works and also a library is provided

that can take care of the complications

of the authorization process for you

during this chapter I also cover how to

create a web app in Apps Script yes herb

strip can be used to create web apps

hosted in Google's infrastructure with

access to Google Apps resources but

running in a client browser after that I

cover some examples of native api's with

examples of how to convert files from

Google format to Microsoft format and

write them directly to Microsoft

onedrive directly from Apps Script on

Google Drive and also how to run app

script functions remotely from other

platforms for example from VBA which

opens up an opportunity for a great

incremental migration path finally I

cover add-ons which are extensions that

can be published in the chrome store and

used to extend Google Apps accessible by

anyone that downloads it a business

example on the Google Maps API this

of screencaps was designed to complement

the book going Gus published by O'Reilly

and available from the website or Amazon

or any other book sell the book can of

course go into much more detail in some

of these subjects and as possible in a

screencast and in general contains

different examples but with this video

of course I've tried to touch on

everything you might need to go from

zero to hero and the Apps Script

- platform so welcome to the world of Apps - Script