Automating G Suite: Apps Script & Sheets Macro Recorder (Cloud Next ’18)

ArticlesBlog

Written by:


[MUSIC PLAYING] MARY LESBIREL: Hello, everyone. Welcome to our Next session,
Apps Script and the Sheets Macro Recorder. My name is Mary Lesbirel. I’m a Cloud Customer
Engineer at Google. I’m joined by Stephanie, also
a Cloud Customer Engineer. Matt Powers, he’s
a Senior Consultant at Maven Wave, and
Ted Bradley, he’s a Product Manager at Google. For today’s agenda, I’m
going to start us off with recorded macros, a
new feature in Sheets. Then, we’re going to do a
deeper dive into Apps Script. So Stephanie is going to
present an overview on what Apps Script is and
highlight some use cases on how you can start
using it in your businesses. We’re also going to
highlight some companies that are currently using Apps Script
today to transform and enhance their business processes. Matt’s going to do a demo
of an application built almost entirely in Apps Script. And then last, but
not least, Ted’s going to share with us some new
features, as well as a roadmap to see what’s ahead
for Google Apps Script. For recorded macros, we
all know that spreadsheets are a core part to business
today in getting things done. We can think about
probably all departments in one way or another using
spreadsheets every single day. From our perspective,
considering the amount of time that we’re all individually
spending in spreadsheets, the goal of recorded
macros is to start eliminating some of
these repeatable tasks that we could easily
automate away. So you can think about
spending more time doing a complex analysis instead
of spending time formatting that chart over and over again. So this April, to
try and reduce some of those repeatable tasks
that we can automate away, we launched Record a Macro. It’s a cloud-based
feature which will record your tasks automatically
and write them to Apps Script. So you can think about
using it when you’re doing the same formatting on
a tab over and over again, or when you’re performing
some sort of analysis on similar data sets. We know we get this data
weekly, monthly, for example, and we’re performing the same
task over and over again. This can add up to
hours of time wasted for doing something that
could easily be automated away using Record a Macro. So when you use Record a
Macro, once you record it, you can play it back on
demand without having to write any code. You can also create
a more complex macro by recording the macro,
going into the Apps Script in the background, and
then adding some more Apps Script code into it to creating
a more advanced complex macro, and saving even
more time for you. I’m going to queue
up a quick demo to show you how you can
do this today in Sheets. OK, so imagine we all
get this spreadsheet, and we’re probably doing
the same formatting. For example, this is a
quarterly sales report. And I’m going to do
some formatting on it that I constantly do
on a regular basis. I’m going to go
into Tools, Macros, Record a Macro to initialize it. And as you can see, it’s already
recording all of my actions on the sheet. So I’m going to do some
things that I typically do in this spreadsheet,
such as bold the row. I’m going to clean
up this sales data and add currency to make it look
like an actual currency value. Doing things like
cleaning up that date, and then let’s do
some more things, like freezing that first
row, creating a filter on it. And then let’s clean this up to
make it a little more readable. OK, once done, I’m just going
to hit Save, and call this macro something like format demo. You can also assign
it a hotkey, so when you want to run it again, you
could just use the hot key. We’ll save it. Now, it’s running the Apps
Script in the background. And then, let’s try redoing
this on the Q2 sales sheet. So I’m going to go into Tools,
Macros, hit that format demo. As you can see, it’s
just going to go through all of those tasks
that I’ve been running already, and it’s eliminating
this manual work for me. Another thing I can do is– let’s say I like to perform the
same analysis over and over. So I’m going to go into Tools,
Macros, record that macro, and then let’s do something
like create a bar chart. Aggregate column D. All right,
now, I’ve got my bar chart. And then I’m sure we all are
used to creating pivot tables. So let’s do Data, Pivot Table. Let’s make that row stores,
and let’s add the value to the sales for that store. So I’m going to save
this once again. We’ll call this analysis demo. It just saved. And then let’s run
this again on Q2. So I’m going to go into Tools,
Macros, perform that analysis. As you can see, it’s just
going over the exact actions that I’ve done and creating
that bar chart for me as well as that pivot table. So you could start
using this as quickly as just recording something. But then also, you
can go into the Apps Script in the background. And as you can see, these
were all the actions that were recorded
in the Apps Script itself, that format demo as
well as the analysis macro. So you can always go in
and add some more code and create a more
complex macro behind it. Could we switch
back to the slides? OK, and now Stephanie is
going to highlight a more in-depth overview
on Apps Script. STEPHANIE: Thank
you so much, Mary, for showing us just how
exciting and impactful the Sheets Macro Recorder is
and how it actually utilizes Apps Script under the covers. So I’m actually
here to just talk more about what Apps
Script actually is. So Apps Script is actually a
serverless developer platform that’s used for integrating,
extending, and automating G Suite applications,
and it allows you to build line of
business applications very easily and quickly. It’s actually including
a built-in tech stack utilizing JavaScript,
so that there’s no need to learn a new language or
build and manage and invest in another tech stack. So that means that your team can
get up and running much faster, and you don’t have to
invest in a new tech stack. And just to illustrate just
how impactful Apps Script is in the industry today, we
actually have 3.3 billion weekly executions,
8.7 weekly end users, 27,000 weekly active
domains, and 27,000 weekly active domains, and
270,000 weekly developers. Apps Script allows
you to integrate with over 30-plus G Suite
and Google services and APIs. In addition, it also
allows you to have access to additional
utilities services. So your developer teams
can actually access G Suite and non-G Suite services,
including Google Maps, Google Analytics, YouTube,
and several GCP APIs– for example, Cloud SQL. So this really allows you
to enable rapid development, including integrated monitoring
and a very generous quota system, so you can
reduce overhead costs. And this allows you to increase
productivity and efficiency. It opens the doorway
for your developer teams to spark innovation
while reducing IT costs. Both professional
and novice developers alike can create business
critical applications, while reducing and not dealing
with the complexity of IT traditional systems costs. As I mentioned, it enables
new rapid development with integrated monitoring
and a generous quota system. And I’ll go into some examples
of how our customers are really reducing overhead
costs in just a moment. With Apps Script,
you can actually build add-ons, for example. Many applications that
live within G Suite can be consumed either
internally or deployed directly to the G suite marketplace
for public consumption, and to reach new customers. You can also build and deploy
scaled web applications, so that you can use
them internally or use for public access. And you can also extend
G Suite applications and include an agent that will
respond to and take action on changes that
happen within G Suite without you actually
having to lift a finger. As I mentioned, you have access
to 30-plus G Suite and Google services and APIs
plus utility services. And so that actually
is something that allows you to
increase efficiency, but we’re actually constantly
adding additional services that benefit the user. In addition, you also have
built in OAuth management, so you can get up and
running very quickly without having to worry
about OAuth token requests for storage, because
all of that is handled for you automatically. Events can also be sent to
and queried by applications that are running in
traditional text stacks, meaning that you can build more
intelligent applications that integrate with and extend
G Suite applications and take action and
respond to changes, so that you can actually build
in background automations. So with Apps Script, the code
that you write in Apps Script is actually utilizing
JavaScript, as I mentioned. It includes a
sandbox interpreter. And all of that code
is actually being run in the cloud, not your browser. The only thing that you’re
doing in the browser is writing your code. So that means that
you can get up and running quickly with
fast and reliable execution. The Cloud IDE means that you
have a code editor for you to deploy your scripts,
and deploy them directly to the G Suite marketplace
for consumption. You also have a dashboard
that allows your developers to have a launchpad for you
to access your projects, or do things like monitoring
and troubleshooting. With the CLI, you have a
command line interface for you to run and deploy
your scripts, and also do things like local
development and version control. So now that I talked
a little bit more about what Apps
Script is, I’d love to highlight a couple of
our key customer examples that are leveraging
Apps Script today. Our top three use cases
include enterprise workflows, resource management, and
automation and integration. The customer examples that
I’m going to highlight should highlight and really add
color to these three use cases. So our first customer is
Whirlpool Corporation. They are an American
multinational company that manufactures and
markets home appliances. This Fortune 500 company has
more than 70-plus technology research centers and
manufacturing centers around the world. Their account
managers usually need to review open order reports
that are generated in SAP. This information is essential
for their account managers before they engage with
their trade partners. So prior to utilizing
Apps Script, they had SAP write this
open order information into their Notes database. And then their account managers
would have to go into SAP, log in, and download
these reports via Excel. So now, Apps Script
actually does three things. It has SAP send the outstanding
order reports and information as a CSV attachment to a
dedicated Gmail service account. That dedicated service
account processes who the correct account
manager recipient should be. And then it converts the CSV
document into a Google Sheet, and gives the recipient
the correct share permissions so they
have immediate access to that report. So Apps Script provides
them with reliability. It showcases how Apps
Script can be integrated with an enterprise
system like SAP and G Suite, which is a highly
collaborative productivity suite. And now their business
is more efficient. The sheet is delivered directly
to their account managers. They don’t have to manually log
into SAP anymore and download the reports. Now, 200 account managers
receive these emails. The information
is essential prior to engaging with
trade managers, and it contains millions of
dollars worth of product ordered, not yet received. One other use case at
Whirlpool Corporation is for tracking field call
rates for their parts. Prior root cause analysis
for these field calls were very time
consuming and required a manual reading of their calls. Given they’re
running on G Suite, their analyst team
decided to use Apps Script to use a
web application that launched a dashboard
and gives them this information
on the fly, which was much more automated,
faster, and easy to consume. So you can see
here, Apps Script is being used to build
an HTML service that launches this web app. It manages all of the
user data in JSON, posted in Google Drive. It also manages all data
gathering from Google Drive as well. And you can see
here, it’s being used to power this heat map
showing their field call rates corresponding to the
parts and various issues that might be found. They could have built this
in many different ways, but they chose Apps Script
for a number of reasons– its ease of use, its built-in
development platform and tools, built-in user authentication,
and the user data is hosted in G Suite. Now this tool is being used
by over 120 users across North America. It’s one of their most highly
used cross-functional tools. And it reduced analysis
from four to six hours to five to 10 minutes,
which is pretty impressive. And now, it’s being used in
their leadership meetings to investigate customer issues
and progress on the fly. Daniel A. Marshall, their
senior quality analyst, has said that, “Apps Script has
lowered the barrier of entry for us to do new and exciting
things at little cost with a speed that
shatters previous systems implementations.” Now, PWC is a multinational
professional services network headquartered in London. It’s one of the largest
professional services firms in the world. PWC Australia is working
on a project that enables their employees
to quickly locate the correct document template
to use with their clients. The solution provides
a simple wizard, collaboration via Google
Docs, and a simple transition to Gmail so that they can send
the document to the client. This solution has two parts. The first part is a
published web application that presents the user
with a custom form that they fill out to give to
the right person, the client, using a template. It uses a Google Sheet
as a data back end. And once the user
fills out a form, Apps Script is used to
produce a Google Doc template, and it lands in
the user’s My Drive so they can start
collaborating on the document. The second part
is an add-on that shows up as a side panel when
the Google Doc is created. And that gives them
instructions on how to fill out the
template, and it includes a button that actually publishes
all the contents of the Google Doc into the body of an email. Now, as I mentioned,
this is actually moving the entire
contents of the document into the email, which really
streamlines their client interactions, because
they no longer have to open an attachment. And they’re using
integrated APIs that actually push the email
directly into the user’s inbox drafts folder. This is really powerful,
because Apps Script has enabled them to do much more
complex formatting than what is normally achievable in Gmail. Now with Apps Script, they
have built-in integrations with Google Docs and Gmail, so
their client-facing employees now consensually
collaborate in a Google Doc. And it’s really furthered
their goal as a company to digitize the firm. Michael Benz, their Google Cloud
technical solutions engineer, has said that, “The end
result is our employees start engagements G Suite, and
Apps Script gave us the ability to hit the ground running.” Air Liquide is a French
multinational company which supplies industrial
gases and services to various industries. And their goal was to improve
the safety on their grounds, on the factory grounds. And they needed to do risk
analysis of their facilities by collecting risk
assessment data, and then the
resulting action plans would help them better comply
with their internal safety standards. They needed to
build an application to help keep track of
these risk assessments while still using their existing
IT infrastructure and tools. So they built it using
Apps Script, which produces HTML and CSS and
fetches the risk assessment data from a set
of Google Sheets. And depending on the
user and language, that app gives them
the questionnaire to fill out about
risk assessment. So you can see here on
the left, the HTML service generates a questionnaire
out of Google Sheets. The app pulls the data
from the questionnaires, and it adds it to a dashboard. And they actually use the
Google Visualization API to help with
graphing and charts. Different Google
Drive folders contain staging versus production
sets of sheets and scripts. And then on the
right-hand side, even when safety and risk assessments
change and there’s progression, they can actually visualize
that in the dashboard over here and monitor it on
several levels. Now, on multiple company
levels, Air Liquide management has a constant
insight into how far the factories are getting
matured in their safety assessments. So they chose Apps Script for a
number of reasons, once again. They had limited
budget, but they were able to get from
presenting the problem to an actual working
application within four months. And since they’re all on G
Suite, everything was included. They didn’t need any
IT safety procedures. Everything was immediately
in the application by using Google Sheets
as a data back end. And they had built-in
user authentication with Google accounts. The huge advantage
for them was being able to implement and deploy
feedback from management and end users on the fly. And now, they have
850 registered users and 300 monitored facilities. Dennis van Lemmeren, their
industrial management system specialists, has said that,
“Rapid Apps Script development has enabled us to improve
local industrial risk awareness and mitigation. And management now has
the necessary information to focus resources.” Now, the examples
I just talked about were all internal use cases
to increase productivity, but I did want to
highlight a company who’s using Apps Script to create a
new tool to reach new customers on the G Suite marketplace. Smartsheet is a SaaS
company and application that enables you to add emails
and attachments directly to a specific row. And that’s all used to
manage project progress, manage calendars,
share documents. And what they created
is a Smartsheet for Gmail add-on,
which enables you to add emails and
attachments directly to a specific row in a sheet,
so that pertinent information about your project stays
in the context of what you’re doing rather than
getting buried in your inbox. Now, they have almost 600,000
installs and 8.2 million users, which is one of the
highest number of users of all the listed applications
on the G Suite marketplace. A lot of times,
important decisions are made or approved over email,
and record of that decision lives in your email. And having to store and
track down the approvals every time it needs
to be referenced is very time-consuming
and error-prone. So now when you get an approval,
you can stay in your inbox and use this add-on
to add the contents of the email or any attachments
to the applicable row in your Smartsheet. Now, everyone working on that
Sheet can quickly reference it in real time, and
it makes it possible for you to increase
execution and productivity. So Casey Bryson, who’s the CIO
of one of their key customers, from Hurley Medical
Center, is working on a project for public
health initiatives in response to the Flint water crisis. And they’re using the add-on. And he said that, “With the
Smartsheet for Gmail add-on, we have increased execution
speed, because users can stay in Gmail and
easily attach emails to an applicable
row in Smartsheet. Also, everyone working
from that sheet can quickly reference it instead
of searching for an inbox or trying to track it
down from a teammate.” So hopefully you got a great
idea of all the enterprise use cases that Apps
Script can enable you to do, along
with how you can create tools to reach new
customers on the G Suite marketplace. Now, I’m going to pass it off
to Matt from Maven Wave who helped us work on
a tool together, a people skills demo that
we built together at Google. MATT POWERS: Awesome. Thank you, Stephanie. I think it was a
really good overview of the different types
of things that you can do with Apps Script. As Stephanie mentioned,
some of the demo here is an application
or a process that we built, the four
of us, and it’s around a people skills use case. So something that we’ve seen
internally in our group, and something that
in our previous jobs, we’ve seen other
corporations struggle with is how do you keep track of
the different skill sets that are within your organization? So up here, we just
have a fun graphic of just a small portion
of the different GCP products that are out there. And then you extrapolate
the different programming languages, the different
marketing skill sets that people
can have, and trying to understand what skill
sets, what knowledge bases are within your company as
both technology grows and the amount of
different skill sets that people can have grows
is becoming a bigger and bigger challenge for companies. So we thought it’d be
something, an interesting demo for this presentation
to basically look at how can Apps Script– and I’ll show a little
bit of App Maker– how can Apps Script
and App Maker solve at least a small
part of this challenge. So we wanted a solution that
really had three key pieces of functionality. So we wanted to
take an inventory of any new employee that
joins an organization, what is their skill set? We wanted to then organize that
inventory in an easy to grab, easy to digest way. We then wanted to
integrate that inventory in interesting and
meaningful ways. And we’ll show what we think
is a cool use case of that. And the end result. So
jumping to the end before I get to the demo, but
we used Apps Script to integrate seven different
G Suite applications and services. And really, it was the four of
us working two weeks part-time to put this process
together, and we think we got to a pretty
good, minimum viable product. So with that, could we
turn it over to the demo? Ted, what is your password? [LAUGHTER] Awesome. All right, so this is
a fictitious company, Organic Villa. I’m a new employee. I’ve just started. And right off the bat, I’m going
to get a Google form asking me for my skill set. So again, this is
an inexhaustive list of all the skills that
you’d want to gather. But just for demo
purposes, let’s say I’ve got application development
and machine learning skills, and I want to learn a little
bit more about algorithms. App Maker hopefully
I know, because I’m talking about it today. And then business analytics. So I’ll submit this form. And then a few things
are going to happen after I submit this form. There we go. So based on what I said
in the Google form, I said I know a little
bit about machine learning and a little bit about
application development. And using Apps Script, we
actually automatically did a few things. The first thing
we did is we send an email saying, hey, looks
like you know machine learning. Here’s a Google
Calendar of our machine learning group for different
meet-ups in the organization. Please add this to
your calendar if you’re interested in attending. The second thing that
automatically happened, only based off that
initial Google form, is you can now see that
I’m part of a app dev and a machine
learning user group. So instead of having
the form filled out, and it goes to some
type of admin who then needs to add
them to user groups and needs to populate
a back end database, this is now all done
automatically using Apps Script. So let’s refresh this here. That is my app. There we go. OK, so as you can see, so
this is the second part. So our user’s joined
an organization. They have a Google form. Now, this second piece,
this is App Maker. This is where you can constantly
update any new skills you get. So you can see, based
on the initial survey, I said I have application
development and machine learning skills, and then I
came back at some other point throughout the duration of while
I was at this organization. I said I have Cloud SQL skills. They’re just SQL skills. So now, if I gain, let’s say,
business analytics skills– and the internet
connection is good. There we go– it’ll populate
in the skills list here. So that’s the first part of it. And then I think we were
talking earlier about, what’s a useful way to serve
this inventory to the rest of your organization. And that’s under
the second piece of what App Maker can offer. So let’s say I want to
find other people that know machine learning, because
I have a big machine learning project. So I’ll click on this
machine learning dropdown, and I can see everyone in my
organization who at some point, either in this application or
in the initial Google form, has said they know
machine learning. So I can click on
Mikhail here, and it looks like Mikhail has got
a few different skills. So he says he knows Python,
machine learning, project management, and SQL. And I can then– let’s
say I work with Mikhail. I say it looks like he has
machine learning skill set, and I want to work
with him on a project. I can then endorse him
after I’ve worked with him. He says he knows
machine learning. I worked with him. He definitely does, and I can
endorse him for that skill set. So it’s one thing to say
you know these skills, but then as you work with other
people in your organization, they can endorse you
for that skill set. And it kind of
validates that they know what they’re talking about. The last piece of– let me refresh this, make
sure it’s up to date. Yeah, so the last
piece of functionality I want to talk about is now we
have this underlying database of everyone in
your organization, the different skill
sets they have. What are some other
useful ways we can service that information? So one, we showed
App Maker and how you can search for people
with other skill sets, you can endorse them. But I think once you have
that inventory of skills, there’s some other
things you can do. So here’s just an example. It’s titled meeting
notes, but you can think of this as
some type of proposal or RFP that’s out there. And if we look at this, OK,
machine learning has come up. So I can see, OK,
machine learning, I don’t know anything
about machine learning. Let’s see if anyone in
my organization does. So what we did, again,
with Apps Script is we created a Google
Doc add-on where you could search for people
that have different skill sets. So I need to find someone
that knows machine learning, because this is a proposal
that needs to get out tomorrow, next week, whatever it may be. I’ve already used Mikhail,
so let’s go with Stephen. So when I click on
Stephen here, a few things are going to happen. I’m going to write him a note. So I’ll say, hey,
Stephen, or Stephan, could you take a look
at this proposal? Take a look at the
first paragraph. I’ll write him a little message
here, and I’ll click OK. And then again
using Apps Script, two automated things
are going to happen. One, he’s going to get an
email with that message, and then a second email
sharing this document with him. So just a really efficient
way to find different skill sets in your organization. I think some other branches
or some other things you could do with this
inventory, especially at companies of larger
sizes, is start forecasting. We’re at a Google
conference, so let’s say I know TensorFlow’s going
to be big the next three to five years. I want to know how many
people in my organization actually know TensorFlow. And then from an
HR standpoint say, this is a skill set we’re going
to need to go out and find. And those insights
are really only possible by having an
underlying database that collects all this information. So switching back over
to the slides now. So I’ll just jump in a little
bit into the architecture. So I showed a new employee
joining Organic Villa, our fictitious company. The initial Google form
collects those skill sets, and then it’s going to do
a few things automatically, like I showed. It’s going to add them
to the Google Groups based on what they
said their skills were. They’re going to get
an email linking them to the Google Calendar
associated with that group. And again, all of
that information is pushed at Cloud SQL database. The Cloud SQL database acts
as the back end for App Maker. So App Maker, again, where
you can search for skills and add new skills, there’s
a bidirectional connection there between Cloud
SQL and App Maker, and then finally our
Google Doc add-on. So Cloud SQL, again, is the back
end for that Google Doc add-on where you can see
other people’s skills and add them to Google Doc. So just to tie it all
together, all these blue arrows you’re seeing are Apps Scripts. So this entire process, the glue
of the process was Apps Script. So that’s the first point. The second point being
this took the four of us 2, 2 and 1/2 weeks
of part time work. And we feel like we
go to a pretty good minimum viable product. So just highlighting, this
stuff is pretty easy to use, and the connections between
all these different G Suite products is fairly simple. So yeah, a good demo
to highlight, I think. So with that being
said, I’m going to turn it over to Ted
to talk a little bit more about the roadmap and
some other cool stuff coming down the pipeline
with Apps Script. TED BRADLEY: Thanks
so much, Stephanie, for sharing some
example use cases of how top organizations
are using Apps Script. And thanks, Matt, for
that great overview, a deep dive on how
easy it is to use Apps Script for internal use cases. I’m Ted Bradley. I’m the project manager
for Apps Script. Excited to share with you guys
today some of the improvements we’ve made to the product
over the last 12 months, and also share with you a
roadmap of what’s to come. So first off, at the
backbone of Apps Script are the APIs and the events. And this is really
what enables you to create applications that
are more powerful and more intelligent. We’re always looking
for opportunities to expand the features that
are available in these APIs and these events. And to that end, we’ve actually
introduced 150 new methods over the last 12 months in
Sheets, Gmail, Google Groups, Calendar, and Google Slides. We’ve also introduced a new
event in Google Calendar so that your applications
can get pinged every time a user
introduces a new meeting or updates an existing meeting. Additionally,
Stephanie mentioned that you can create three
things with Apps Script. You can create web applications,
automations, and add-ons. And add-ons are essentially
these mini-applications that live inside of
c-suite G Suite apps. And when the platform
initially launched, we supported Google Docs
add-ons, Google Sheets add-ons, and Google Forms add-ons. However, late last year, we
also introduced the ability to create add-ons for
Gmail and Google Slides. And this year already, we
have released the ability to create Google Calendar
add-ons and also Hangout Chat Bots with Apps Script. One of our top
priorities is making sure that when you create
applications on Apps Script, they’re both secure
and enterprise ready. And part of
enterprise ready means that it’s manageable in
the Google Admin console. So to that end, we have
a number of new features. First off, fine-grained
OAuth scopes. So what this means
is that essentially when an application
is requesting access to the data of one of the
users in your organization, it’s going to ask for the
absolute limited amount of data access that it needs to
perform the action at hand. So an example is instead
of asking for access to an entire user’s
email inbox, we now have a fine-grained scope, such
that an application will access just the information
for a specific email and for a finite
expiring amount of time. Meaning that your
organization’s data stays safer. Additionally, we’re working on a
project called Manage Projects, which means that the Google
Cloud projects behind each Apps Script is actually going to
be brought into the domain policies, so it can
be managed along with all the policies of the
other Google Cloud projects as well. And we are very excited
to announce today that we’re launching a brand
new feature called OAuth whitelisting for Apps Script. OAuth whitelisting is
actually an existing tool within the Google Admin console. It’s a very powerful tool
for OAuth management. However, we’re launching a new
control so that you can use that tool to essentially control
which Apps Script applications can and cannot run
in your organization. Essentially, you can disable
specific APIs or products. And then if you
decide to do that, you just whitelist specific
Apps Script projects. Otherwise, they can’t run. Additionally, we
understand that if you want to create enterprise-grade
mission critical applications, you need the ability to
use professional workflows and professional
development tools. So to that end, in
Q1 of this year, we launched clasp, which
is the command line interface for working
with git your local IDE. And you can do everything
you’re seeing in the demo there, create projects, pull, push,
clone, deploy, view logs. This is actually an
open source project. So this has been well
received by a lot of our professional developers. Similarly, we launched
TypeScript for Apps Script in Q2 of this year,
which is going to introduce a number of new
features into your local IDE, including autocomplete,
structural typing, type inferences, interfaces,
and ECMAScript 6 features. We’re always looking
for opportunities to expand the use cases that
you can support with Apps Script projects. And so to that end, we are
excited to announce that today, for all business
enterprise SKU users, we’re lifting the cap from
six minute maximum execution time up to 30 minutes. So this is going to
mean you’re going to be able to do larger,
more complex scripts that can work on larger data sets. Additionally, we’re working on a
feature called flexible quotas, which is essentially going to
eliminate hard daily quotas and replace them with a
high cap rate limit, which will effectively eliminate
quotas altogether for all but the most extreme use cases. We’re also working
on Apps Script V8. This is the first time
that we’re announcing this. And it’s a modernized
and more performant run time that’s going to
run underneath Apps Script. So it’s going to come with a
number of significant features. First off, you’re going to be
able to use modern JavaScript. So you’re going to really
use ECMAScript 2017 with all the modern JavaScript
features, including the ability to run and use modern
JavaScript libraries. We’re expecting
performance gains of 10x for CPU bound executions,
significant improvements in reliability, so
you can confidently run enterprise
grade applications. And we’re also
introducing a brand new feature along with Apps
Script V8 called the job service. And this is going to take
your especially long-running processes, and
you’re going to be able to break them up into
parallel processes that can fan out. Meaning that your projects
are going to run faster, and they’re also going
to be able to cover a lot more ground. Additionally, in Q1
2018, we launched a new product for Apps
Script called the Apps Script dashboard. And this satisfied a
number of use cases. So first off, previously,
your Apps Script projects might have been
scattered around, hidden behind Google
Sheets, Google Docs, maybe found in Google Drive. We brought them all in one
place behind the Apps Script dashboard. We also introduced
monitoring features for you to see usage data and
graph error rates, and introduced troubleshooting
tools for execution logs and Stack driver log in. And today, I am very
excited to announce that we are going to be
relaunching the Apps Script dashboard as the G
Suite Developers Hub. And this is going to have– it’s no longer just going
to be for Apps Script. It’s actually going to be the
launchpad for all your G Suite integrations, including
App Maker; going to come with a number
of new features, including templates, so you
can get your projects up and running faster,
starred projects, so you can not only get quick
access to your projects, but also see a portfolio
overview of the projects you care about for monitoring. And we’re also introducing
trigger management, which is going to give you the
ability to debug triggers, manage triggers,
including notifications. So with that, I’m actually
excited to show you guys a demo of the new G
Suite Developer Hub. Great. So first off, this is the home
page of the Developer Hub. You can see I’ve got all
my projects in one place. If I click on the Getting
Started link over here on the left, I’m going
to be able to see I have quick access to
a number of resources. I also have a
variety of templates for add-ons, for App Maker web
apps, for a Google Chat Bot. In this case, I actually want
to check out a specific project. I’m going to go
back to My Projects. I’m going to check out
customer issues, is a project that I personally work on. And since I work on this
project pretty frequently, I want to make sure
that it’s starred. Looks like it already
has a star here. So I’m going to
be able to go over into Starred
Projects on the left, and I’m going to be able to see
all my starred projects in one place. In addition to the starred
projects and quick access, I’m actually going to
be able see a roll up summary of all the
data associated with my portfolio of projects. So here’s customer issues. And here’s the roll up summary. Across all my projects, I have
7,800 users, 29,000 executions. And I can see here
that there’s actually a spike in the error rate
of my customer issues graph. So why don’t we dive in
and take a look at that? So now we get to the
project details page of the customer issues app. I see all the same data,
error rate, executions, users. I get my familiar graphs. I also see the OAuth scopes
associated with the project, as well as the metadata
on the right-hand side. I’ve got a number of
different quick access links, like Stackdriver
and Cloud Project, and I can also see all
the different deployments for my projects at the top
in this tabbed interface. So in this case, I’m seeing my
error rates spike on July 19, and I want to go
ahead and take a look at the executions
associated with this project so I can debug that project. So I’m going to go ahead and go
to Executions, Status, Failed Executions. I see here my executions
associated with July 19. This is time driven. This is fired by a
time driven trigger, so I can actually
pivot over to view the trigger that was responsible
for firing this execution. And then from there, I can
pivot to see all the failed executions associated with
this specific trigger, so I can debug it. And then with one
click, I can actually load up the Stackdriver logs
for this specific execution, and I’m going to be able
to see that, in this case, this failure was caused by an– external database
quota was exhausted. So I think we can go
back to the slide deck. Essentially, today, we
have covered record macros and how they can save
you time when you’re working in Google Sheets. Stephanie gave an excellent
overview of Apps Script and how it can be used to
save development time costs, increase productivity, and spark
innovation in the organization. We showed you six different use
cases of Apps Script in action, and we covered 16 new
features that we have improved over the last 12 months,
as well as the new launch of the G Suite Dashboard. So thank you so
much for your time, and we are excited to have
you as users of Apps Script. [APPLAUSE] [MUSIC PLAYING]

2 Replies to “Automating G Suite: Apps Script & Sheets Macro Recorder (Cloud Next ’18)”

  1. Dimu Designs says:

    Awesome announcements!! Especially support for EcmaScript 2017!

  2. Siddhesh Mishra says:

    Can i get the slides?

Leave a Reply

Your email address will not be published. Required fields are marked *