SPEAKER: Everyone has their own super powers.
SPEAKER: Everyone has their own super powers.

There can be analysts who forecast what the future holds,
There can be analysts who forecast what the future holds,

or help interpret the past, via data visualizations
or help interpret the past, via data visualizations

similar to divinators.
similar to divinators.

Then there are data scientists that
Then there are data scientists that

can build queries, use math to find patterns,
can build queries, use math to find patterns,

and turn raw numbers into insights like transmuters.
and turn raw numbers into insights like transmuters.

Others can automate tasks using macros
Others can automate tasks using macros

or follow DevOp processes like sorcerers do with magic spells.
or follow DevOp processes like sorcerers do with magic spells.

Some folks are also like wizards that can code programs
Some folks are also like wizards that can code programs

from thin air.
from thin air.

Because of this, I wish to share what tools you
Because of this, I wish to share what tools you

can use in G Suite to support all these different talents.
can use in G Suite to support all these different talents.

Let's start with analysts.
Let's start with analysts.

You can copy someone's sheet with a macro that
You can copy someone's sheet with a macro that

automatically creates pivot tables, renames your tabs,
automatically creates pivot tables, renames your tabs,

enters a formatted chart, and can be easily executed
enters a formatted chart, and can be easily executed

via a keyboard shortcut.
via a keyboard shortcut.

You can also autogenerate reports
You can also autogenerate reports

and schedule them to be sent via email on a weekly basis
and schedule them to be sent via email on a weekly basis

using a Google Doc as a template,
using a Google Doc as a template,

or connecting your sheet to a free drag and drop dashboard
or connecting your sheet to a free drag and drop dashboard

builder called Data Studio.
builder called Data Studio.

As for data scientists who need to clean data,
As for data scientists who need to clean data,

they can leverage any of the 400 built-in functions
they can leverage any of the 400 built-in functions

to do things like import data, find duplicates, create
to do things like import data, find duplicates, create

randomized data for testing, translate phrases, and map
randomized data for testing, translate phrases, and map

locations in a Google spreadsheet
locations in a Google spreadsheet

onto Google Earth or Google Maps.
onto Google Earth or Google Maps.

One can also create custom functions
One can also create custom functions

that come on Google Cloud AutoML to train
that come on Google Cloud AutoML to train

custom machine learning models with minimal expertise,
custom machine learning models with minimal expertise,

all from the comfort of a familiar spreadsheet interface.
all from the comfort of a familiar spreadsheet interface.

For those power users of Jupyter notebooks,
For those power users of Jupyter notebooks,

you can use Google Spreadsheets to similarly instruct
you can use Google Spreadsheets to similarly instruct

it to pull data from one tab, perform
it to pull data from one tab, perform

a series of transformations on it,
a series of transformations on it,

and store the results in a different tab.
and store the results in a different tab.

This is thanks to its script editor, its built-in functions,
This is thanks to its script editor, its built-in functions,

and the use of JavaScript, which is a very popular language used
and the use of JavaScript, which is a very popular language used

to make web apps.
to make web apps.

And with the Sheets data connector,
And with the Sheets data connector,

you can pull very large data sets from BigQuery
you can pull very large data sets from BigQuery

without having to do much SQL heavy lifting.
without having to do much SQL heavy lifting.

Moving on to task automation, creating custom
Moving on to task automation, creating custom

UI components becomes especially impactful
UI components becomes especially impactful

when sharing scripts with others since anyone
when sharing scripts with others since anyone

can copy your sheet and run its logic by choosing a dropdown
can copy your sheet and run its logic by choosing a dropdown

option from a custom menu, or enter
option from a custom menu, or enter

data via a custom sidebar, or warn users via a dialog box.
data via a custom sidebar, or warn users via a dialog box.

Also, with the use of time-based triggers or user action-based
Also, with the use of time-based triggers or user action-based

triggers, such as submitting a form response,
triggers, such as submitting a form response,

editing a Google Sheet, et cetera,
editing a Google Sheet, et cetera,

you can further automate tasks on a frequent basis.
you can further automate tasks on a frequent basis.

As a bonus, if you are a G Suite admin,
As a bonus, if you are a G Suite admin,

you can manage everything in your domain programmatically
you can manage everything in your domain programmatically

by using a Directory API, such as monitoring third party
by using a Directory API, such as monitoring third party

applications, taking actions on lost devices,
applications, taking actions on lost devices,

and creating or editing user information.
and creating or editing user information.

As for programmers, you can build
As for programmers, you can build

an app that is synced with a spreadsheet via the REST API.
an app that is synced with a spreadsheet via the REST API.

The Google Drive API, for example,
The Google Drive API, for example,

lets you create mobile, web, and desktop apps that read, write,
lets you create mobile, web, and desktop apps that read, write,

and sync files in Google Drive, and can
and sync files in Google Drive, and can

be connected to Google and non-Google services.
be connected to Google and non-Google services.

You can also build connections to external databases
You can also build connections to external databases

via the JDBC connector.
via the JDBC connector.

Furthermore, there are client libraries
Furthermore, there are client libraries

in a number of programming languages.
in a number of programming languages.

And they support making calls that
And they support making calls that

require user authorization.
require user authorization.

By using them, you can avoid the need
By using them, you can avoid the need

to manually setup HTTP requests and parse the responses.
to manually setup HTTP requests and parse the responses.

And to help users reduce context switching,
And to help users reduce context switching,

you can build add-ons that bring in additional functionality,
you can build add-ons that bring in additional functionality,

such as syncing G Suite products with third party vendors,
such as syncing G Suite products with third party vendors,

and then publishing them on the G Suite Marketplace
and then publishing them on the G Suite Marketplace

to sell, or to only share with people in your own domain.
to sell, or to only share with people in your own domain.

Additionally, you can also reduce contact switching
Additionally, you can also reduce contact switching

by also building helpful chat bots that
by also building helpful chat bots that

integrate an organization's app right into the Hangouts Chat
integrate an organization's app right into the Hangouts Chat

interface.
interface.

This lets users get information from the app,
This lets users get information from the app,

take quick actions, and stay notified
take quick actions, and stay notified

in a conversational and dynamic manner.
in a conversational and dynamic manner.

I hope this summary gave you a better
I hope this summary gave you a better

idea of the tools you can use to customize G Suite,
idea of the tools you can use to customize G Suite,

and maybe inspire you to use one based on your own superpowers.
and maybe inspire you to use one based on your own superpowers.

As a next step, allow me to recommend visiting the G Suite
As a next step, allow me to recommend visiting the G Suite

Solution Gallery and any of the documentation linked
Solution Gallery and any of the documentation linked

in this video's subscription.
in this video's subscription.

Cheers.
Cheers.

[MUSIC PLAYING]
[MUSIC PLAYING]