Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:04,520 --> 00:00:07,438
If you're using or thinking of using
2
00:00:07,439 --> 00:00:10,980
Google Apps and especially if you've
3
00:00:10,981 --> 00:00:13,230
come over from Microsoft Office you may
4
00:00:13,231 --> 00:00:15,239
be wondering how to automate and enhance
5
00:00:15,240 --> 00:00:17,685
the platform just like you could do with
6
00:00:17,686 --> 00:00:21,060
your previous solution Apps Script is
7
00:00:21,061 --> 00:00:23,880
Google's cloud base scripting language
8
00:00:23,881 --> 00:00:26,009
it can be used to build applications to
9
00:00:26,010 --> 00:00:28,259
extend what you can do with the Google
10
00:00:28,260 --> 00:00:31,050
Apps environment the underlying language
11
00:00:31,051 --> 00:00:33,360
of Apps Script is JavaScript and it can
12
00:00:33,361 --> 00:00:35,879
perform a similar role to that of VBA
13
00:00:35,880 --> 00:00:38,370
for office but it can do so much more
14
00:00:38,371 --> 00:00:40,739
than that it's in the cloud and it runs
15
00:00:40,740 --> 00:00:43,349
on Google servers so it talks very
16
00:00:43,350 --> 00:00:45,209
easily with api's not just those created
17
00:00:45,210 --> 00:00:47,069
by Google but with millions of other
18
00:00:47,070 --> 00:00:49,019
services that are out there just waiting
19
00:00:49,020 --> 00:00:51,899
to be in the grid with your documents
20
00:00:51,900 --> 00:00:53,429
and apps this series of screencasts is
21
00:00:53,430 --> 00:00:55,739
designed to take you step-by-step
22
00:00:55,740 --> 00:00:58,559
through how to work with the complete
23
00:00:58,560 --> 00:01:00,538
Apps Script platform starting with the
24
00:01:00,539 --> 00:01:02,608
architecture of Apps Script and how to
25
00:01:02,609 --> 00:01:05,190
use the development environment it will
26
00:01:05,191 --> 00:01:07,229
show some of the new processes to apply
27
00:01:07,230 --> 00:01:08,430
when working in a shared cloud
28
00:01:08,431 --> 00:01:11,640
environment if you don't already know
29
00:01:11,641 --> 00:01:14,339
JavaScript it will take you through the
30
00:01:14,340 --> 00:01:15,899
fundamentals as a language so you can
31
00:01:15,900 --> 00:01:18,570
learn enough to be able to competently
32
00:01:18,571 --> 00:01:20,729
follow and build on the examples but
33
00:01:20,730 --> 00:01:22,740
also with some hints on the style used
34
00:01:22,741 --> 00:01:24,509
in the course there are just a few
35
00:01:24,510 --> 00:01:26,520
slides throughout the entire series of
36
00:01:26,521 --> 00:01:28,859
screencasts with almost all of the
37
00:01:28,860 --> 00:01:31,020
content concentrate on coding examples
38
00:01:31,021 --> 00:01:33,570
of how to do things in Apps Script in
39
00:01:33,571 --> 00:01:35,460
fact one of the end results of working
40
00:01:35,461 --> 00:01:37,320
through each of the chapters is that
41
00:01:37,321 --> 00:01:39,119
useful code is added to a cumulative
42
00:01:39,120 --> 00:01:41,490
library that's used in subsequent
43
00:01:39,119 --> 00:01:42,160
examples and then your real work when
44
00:01:42,161 --> 00:01:44,290
you come to apply what you've learned
45
00:01:44,291 --> 00:01:46,829
there is a lot of ground to cover there
46
00:01:46,830 --> 00:01:48,840
are over 40 services and advanced
47
00:01:48,841 --> 00:01:50,760
services in the Apps Script platform in
48
00:01:50,761 --> 00:01:53,024
addition to examples of integration with
49
00:01:53,025 --> 00:01:56,609
external API so the pace is very fast
50
00:01:56,610 --> 00:01:59,219
you'll be doing complicated things very
51
00:01:59,220 --> 00:02:01,770
quickly the frost service that's covered
52
00:01:59,219 --> 00:02:02,339
in detail is spreadsheets and by the end
53
00:02:02,340 --> 00:02:04,334
of it you'll be able to manipulate
54
00:02:04,335 --> 00:02:07,079
spreadsheet data in formats write custom
55
00:02:07,080 --> 00:02:09,930
formats pick up there from external API
56
00:02:09,931 --> 00:02:12,450
and create charts the document service
57
00:02:12,451 --> 00:02:14,520
chapter will demonstrate how to navigate
58
00:02:14,521 --> 00:02:17,310
and format Google Documents and
59
00:02:17,311 --> 00:02:18,585
automatically create
60
00:02:18,586 --> 00:02:22,410
and modified content from external AP is
61
00:02:22,411 --> 00:02:25,050
the next major service will look at is
62
00:02:25,051 --> 00:02:27,299
Gmail and how to send messages process
63
00:02:27,300 --> 00:02:29,190
your mailbox followed by chapters and
64
00:02:29,191 --> 00:02:31,380
manipulating contacts and creating
65
00:02:31,381 --> 00:02:33,060
calendar events by now we'll have
66
00:02:33,061 --> 00:02:34,680
covered the major common Apps Script
67
00:02:34,681 --> 00:02:37,200
services and can start to look in more
68
00:02:37,201 --> 00:02:39,569
detail how to get data from external API
69
00:02:39,570 --> 00:02:42,390
so this chapter has a nice example of
70
00:02:42,391 --> 00:02:45,119
getting images from a select camera on
71
00:02:45,120 --> 00:02:46,980
the Mars Lander yes really saving it to
72
00:02:46,981 --> 00:02:49,790
drive and mailing it to someone and
73
00:02:49,791 --> 00:02:52,079
here's the email I just got
74
00:02:52,080 --> 00:02:53,625
moving on to some of the more advanced
75
00:02:53,626 --> 00:02:56,340
services a lesson on Drive shows how to
76
00:02:56,341 --> 00:02:59,579
convert images to text save them to
77
00:02:59,580 --> 00:03:02,879
drive and then search drive for files
78
00:03:02,880 --> 00:03:05,459
containing that text the example uses
79
00:03:05,460 --> 00:03:07,890
this image of a 100 year old document in
80
00:03:07,891 --> 00:03:09,989
the lesson authentication and
81
00:03:09,990 --> 00:03:11,819
authorization are very complex subjects
82
00:03:11,820 --> 00:03:13,980
and can take some time to get your head
83
00:03:13,981 --> 00:03:15,988
around in a cloud environment or apps
84
00:03:15,989 --> 00:03:17,819
often end up being a patchwork of
85
00:03:17,820 --> 00:03:19,950
services and data from different API
86
00:03:19,951 --> 00:03:22,619
providers getting the authentication
87
00:03:22,620 --> 00:03:24,869
right is a major headache Google uses
88
00:03:24,870 --> 00:03:27,569
OAuth 2 for both authentication and
89
00:03:27,570 --> 00:03:29,579
authorization as do many other providers
90
00:03:29,580 --> 00:03:31,920
there is a deep dive in how all this
91
00:03:31,921 --> 00:03:33,810
works and also a library is provided
92
00:03:33,811 --> 00:03:35,839
that can take care of the complications
93
00:03:35,840 --> 00:03:38,640
of the authorization process for you
94
00:03:38,641 --> 00:03:41,220
during this chapter I also cover how to
95
00:03:41,221 --> 00:03:42,899
create a web app in Apps Script yes herb
96
00:03:42,900 --> 00:03:45,090
strip can be used to create web apps
97
00:03:45,091 --> 00:03:47,040
hosted in Google's infrastructure with
98
00:03:47,041 --> 00:03:49,650
access to Google Apps resources but
99
00:03:49,651 --> 00:03:52,440
running in a client browser after that I
100
00:03:52,441 --> 00:03:54,660
cover some examples of native api's with
101
00:03:54,661 --> 00:03:56,880
examples of how to convert files from
102
00:03:54,660 --> 00:03:57,555
Google format to Microsoft format and
103
00:03:57,556 --> 00:03:59,475
write them directly to Microsoft
104
00:03:59,476 --> 00:04:01,935
onedrive directly from Apps Script on
105
00:04:01,936 --> 00:04:04,005
Google Drive and also how to run app
106
00:04:04,006 --> 00:04:05,939
script functions remotely from other
107
00:04:05,940 --> 00:04:08,970
platforms for example from VBA which
108
00:04:08,971 --> 00:04:10,455
opens up an opportunity for a great
109
00:04:10,456 --> 00:04:13,005
incremental migration path finally I
110
00:04:13,006 --> 00:04:15,780
cover add-ons which are extensions that
111
00:04:15,781 --> 00:04:18,719
can be published in the chrome store and
112
00:04:18,720 --> 00:04:21,478
used to extend Google Apps accessible by
113
00:04:21,479 --> 00:04:23,259
anyone that downloads it a business
114
00:04:23,260 --> 00:04:26,105
example on the Google Maps API this
115
00:04:26,106 --> 00:04:28,475
of screencaps was designed to complement
116
00:04:28,476 --> 00:04:30,950
the book going Gus published by O'Reilly
117
00:04:30,951 --> 00:04:33,245
and available from the website or Amazon
118
00:04:33,246 --> 00:04:35,315
or any other book sell the book can of
119
00:04:35,316 --> 00:04:37,070
course go into much more detail in some
120
00:04:37,071 --> 00:04:39,830
of these subjects and as possible in a
121
00:04:39,831 --> 00:04:42,260
screencast and in general contains
122
00:04:42,261 --> 00:04:44,150
different examples but with this video
123
00:04:44,151 --> 00:04:46,010
of course I've tried to touch on
124
00:04:46,011 --> 00:04:47,479
everything you might need to go from
125
00:04:47,480 --> 00:04:49,909
zero to hero and the Apps Script
126
00:04:49,910 --> 00:04:52,000
- platform so welcome to the world of Apps
- Script
9600
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.