[MUSIC PLAYING]
WESLEY CHUN: Hello, and welcome to our session Better
Together--
How Google Cloud Makes Google Workspace Better for You.
In this session, we'll show you how you can supercharge
Workspace with Google Cloud.
Hi, I'm Wesley Chen, a developer advocate on Google Cloud.
I've also been a developer advocate on Google Workspace,
and I'm passionate about sharing examples making both product
groups work better for you.
Like me, I hope you're also curious about what's
possible when you leverage both Cloud and Workspace.
I'll be joined by special guests Brett Hughes,
VP of Analytics and Technology at Net Conversion,
and Hervé Oberhauser, Product Manager for S/4HANA at SAP.
By covering various ways you can supercharge Workspace,
we're going to follow that with a quick overview
of both Workspace and Cloud platforms.
Also, we'll take a look at a few use cases
where Cloud can amplify Workspace solutions
and spotlight a report automation example.
Then, we'll hear from Google Cloud Customer Net Conversion
and Cloud partner ICP, on what they've
built using Google Cloud and Google Workspace together.
Finally, we'll wrap up with links and more information
on how to get started using both product groups together.
So let's kick off this conversation
with supercharging Workspace and connecting
to all your data and tools.
Workspaces extensibility allows you
to transform how your teams share and use the data that
powers your business.
Google Cloud provides data analytics and visualization
tools that help you unlock actionable customer insights.
You can add intelligence to your apps
with Google Cloud's AI and ML tools.
Workspace also has open frameworks
where you can connect and integrate
with your favorite DevOps tools in Gmail, Chat, and more.
Finally, you can do all this while
protecting your business data with our hardened platforms
to help keep your data secure.
Workspace is better with Google Cloud
because it gives you access to a variety of solutions
to help make collaborative and data-informed decisions,
create rich data visualizations and dashboards using BigQuery,
Looker, and Data Studio, and get real-time analytics with data
flow or BigQuery BI Engine.
Cloud offers a variety of scalable data
storage solutions to meet your needs.
You might start with Google Drive,
then grow into petabytes with Cloud Storage.
In fact, one code sample I'll link to at the end
lets you implement an intelligent image backup
service from Drive to Cloud Storage.
While it's true that backups don't sound interesting,
it's a whole new ballgame when you
add AI and ML into the picture.
Now, Workspaces in no-code and low-code platforms, AppSheet
and Apps Script, respectively, allow
you to create a variety of intelligent solutions
that connect your data with the third-party applications
that you use for your business.
Build chat apps that can help automate workflows.
Why should your boss look up the sales information for Q3
last year or do ERP resource budgeting manually
when you can have a chat bot do this for you?
Finally, add use of Google Cloud AI and data analysis tools
to see and work even smarter with more intelligent business
applications.
Now, Workspace gives you real-time visibility
into project progress and decisions
to help you ship quality code fast and stay connected
with your stakeholders all without switching
tools or tabs.
By leveraging applications from our partners,
you can pull valuable information out of silos,
making collaborating on requirements, code reviews, bug
triage, deployment updates, and monitoring operations
easy for the whole team.
They can then stay focused on their priorities
while keeping everyone aligned, ensuring collaborators
are always in the loop.
Now, Google Cloud and Workspace are all about
getting things done, leveraging the power
that each platform brings.
Let's do a basic overview of both just in case
they're new to you.
BigQuery is our data warehouse for large-scale data analytics.
Imagine issuing a query across multiple terabytes of data
and getting results in just seconds.
You can give it a try.
Everyone gets 1 terabyte a month of free queries
with a BigQuery Sandbox and no credit card is needed.
App Engine is our original OG serverless 1.0
platform for hosting web apps and mobile backends.
Since then, we've launched serverless
2.0 next-generation platforms, like Cloud Run.
It does what App Engine can do, but adds
the flexibility of containers without requiring
you know Docker.
And it can drop right into a CICD pipeline.
Cloud Functions is another serverless 2.0 platform,
but for specific use cases like where
you don't have an entire app or you
want to avoid using a LAMP stack, a MEAN
stack, or any stack.
It's for small snippets of code, microservices,
or event-driven tasks.
You're probably already familiar with Cloud Storage
as your large-scale data storage solution,
structured or unstructured.
Think of it as your data lake where all your data rivers flow
into.
Our focus as an AI-centric company led to Vertex AI,
AI tools to help data scientists train and deploy models.
It also has APIs for those who are new to ML.
You only need to know how to call an API in order
to leverage the power of machine learning.
From Vertex AI's general platform
to custom solutions like Document AI and Contact Center
AI, Google Cloud has an AI tool to help you build smarter apps.
If you can use Gmail, Google Drive, Docker Sheets,
you're already familiar with Workspace.
But what you may not know is that these apps have
APIs and platform components that let you integrate,
customize, and extend these applications on your own
or to create collaborative applications,
automations, and workflows.
Apps Script is our low-code platform,
usable by both citizen and professional developers
to build tools from simple macros
to complex UI integrated applications
like add-ons and chat apps.
You see the purple gauge at the bottom of the slide?
Well, Google Slides doesn't have a progress bar feature yet.
But you can build one like we did as a Slides add-on
using Apps Script.
Nontechnical app creators can use
AppSheet, our no-code platform to easily build
powerful business web applications.
Finally, the Workspace Marketplace
is a great place to find apps that
let you integrate with the tools that you already use.
Or if you've built a novel solution
you want to share with the world,
productize it by listing it in the Marketplace.
The top tools in the Marketplace have more than 10 million
users.
Now that we've covered the platform basics,
let's look at some possibilities that
can be accomplished with both Cloud and Workspace
for inspiration.
One common use case where we see customers applying
both Workspace and Cloud together
is automated reporting and distribution.
It affects working professionals from data scientists
to operations to knowledge workers.
They need to digitize and automate manual reporting
processes so that they can spend their time more productively.
Below are common tools from Cloud and Workspace
that you may find typically working together in breaking
through bottlenecks.
Let's look at one specific example
of automated report generation using both product groups.
This app is written in Apps Script.
It connects to BigQuery to analyze your data in Cloud
Storage, then uses Looker to help visualize those results.
Data can then be automatically pushed
into Sheets for more analysis and sharing.
From there, data and visualizations
can be imported into Slides.
And when complete, you can use the Gmail API to automatically
send that presentation to all stakeholders
so you're ready for that upcoming meeting.
This is a complete solution from end to end, and guess what?
It's not just an idea.
At the end, I'll take you to a barebones but working version
of this that I built in less than 100 lines of JavaScript.
If you're not a coder but comfortable using Sheets,
Connected Sheets lets you leverage the power of BigQuery,
but with the ease of spreadsheets.
Connected Sheets is a Google Sheets feature
allowing you to connect to BigQuery
to manipulate and transform data for use
in pivot tables, charts, and formulas.
With Connected Sheets, you can access terabytes
of data in BigQuery, then visualize its results
in a sheet, helping you unlock big data insights,
accelerate data workflows, and improve cost efficiency
all while keeping your data safe and secure.
More importantly, you can share these results
with only those you want to share them with.
Earlier, I introduced an app that backs up images
from Google Drive to Cloud Storage.
How do we make backups smarter and let you see more?
Well, it not only copies the images,
but it also calls the AI powered Cloud Vision
API to analyze their content.
And it adds that along with the Cloud Storage
links to [INAUDIBLE] in Sheets so you know exactly what you
backed up and where.
Other examples include developing helpful apps
with no code using AppSheet or write
useful utilities as Chat Apps.
Finally, unlock big data insights
with power analytics and visualization
with BigQuery and Connected Sheets as described previously.
Now, Google Workspace offers many choices to support
your business process needs.
With the power of Google Cloud, you
can supercharge your solutions to meet a variety of challenges
your business encounters.
With the Workspace Marketplace, you
can integrate all your favorite developer and business tools
to access all your critical data in Workspace.
If that integration is a breakthrough
that other enterprises will value,
productize it by listing it in the Marketplace.
But enough from me.
Let's hear how our partners and customers are doing the same.
Please welcome Brett Hughes from our customer Net Conversion.
BRETT HUGHES: Thank you, Wesley.
It's amazing how powerful that toolset is.
I feel like, really, our examples are only
kind of scratching the surface, but we're
excited to jump into them.
So Net Conversion, who I work for,
is headquartered in Orlando, Florida.
We've been around for 15 years.
Really, what I think makes us special as a media agency--
media buying and management agency is our analytics team.
55% of our team is focused on delivering insights
and optimizations on our analytics side, which really
helps drive the $1 billion in media impact that you see here.
Lucky enough to win some awards along the way.
And so, really, our transformation
began a number of years ago, probably even
before this timeline, but I would say it really accelerated
with this timeline.
First focusing on data management and our earliest
adoption was really putting our data and our client data
into BigQuery.
Probably started more on the front
lines of our normal analysts working more
in G Sheets and Connected Sheets.
Dinosaurs like me, we're still using offline spreadsheet
solutions.
But slowly, over two years, really,
the focus being on all data management--
all client data living in BigQuery, [INAUDIBLE]
in BigQuery, and moving towards Connected
Sheets so that we can share math models
that people were working on.
After that, it really started moving into visualization
and moving to Cloud visualization so that data
that we had presenting it to clients with first Data Studio
dashboards.
And then, moving offline presentations to Google Slides
and connecting those directly to G Sheets.
How did we go about doing this?
Well, our own solution was conversionomics.
There are definitely ways to just do this
without a third-party platform.
But 10 years ago, there was a problem.
One of our cofounders was spending
all of his Sunday downloading reports from Google Analytics.
And he said, there's got to be a better way.
So we developed conversionomics.
Later, it was moved into BigQuery.
So it was really--
BigQuery was the backbone of conversionomics
doing the analysis and storage and keeping everything secure.
So conversionomics connects to a number
of different data sources in the Google Cloud and Google Ad
platforms.
And then, we used that to transform and manipulate
data and send that out to our data
warehouse and visualization tools of Data Studio G Sheets
automated reporting.
It also connects to BQML so we can
run automated models off the data that is transformed
in conversionomics.
Additionally, it acts as an activation or [INAUDIBLE]
solution pushing offline conversions or audiences
into our ad platform.
So it's really the backbone of what we do.
All right, another solution that we used Google Cloud for
and Workspace was the optimization logic.
So in this situation, we were trying
to solve for 80-plus locations.
Obviously, Google Ads has done an amazing job
in moving towards automated ML solutions.
But in this case, we had budgets on an individual location basis
of 80-plus different locations.
So within that, we had multiple campaigns
that included pure brand, brand plus other, qualified category,
and category.
And each of those performed differently
from a CPA, impression sphere, and then
budget pacing standpoint.
So really, what the script does and what the logic does
is it pulls that data into central platform,
sorts it, and then, we have a script
run through that data for each location
and recommend optimizations based on how it's pacing
and where we should push spend into.
That loops through 80 different locations.
And really, the output is a script in Google Ads
that updates the budget pacing.
It also creates an accessible change log
saved for historicals that lives in G Sheets.
And then, the changes of that script
are actually emailed out to the client team.
So with that, it really saved, again, us time.
It ensured that we were pacing correctly
across all of these different locations
and with really powerful use of Google integration.
Thank you, everybody, for your time
and allowing me to share that with you.
I'll definitely kick it back over
to Wesley to intro our next event.
WESLEY CHUN: Great.
Thanks so much, Brett.
And I think Ad Scripts is based on App Script as well, too.
So that's pretty exciting.
All right, so that was one example
of how doing things better together
works with both product groups.
Now, let's hear from partner SAP for another.
I'd like to welcome Hervé Oberhauser from SAP.
HERVÉ OBERHAUSER: Hi, Wesley, and hello,
everyone in the audience.
I'm Hervé, and I would like to give you an overview
of the integration project between SAP and Google Cloud.
First of all, I wanted to thank you,
Wesley, for the invitation.
It's great to be part of Google Next.
Before we jump to the topic, a few words about SAP and SAP
S/4HANA.
The purpose of SAP is to help the world run better
and to improve people's lives.
I know that might sound a little bit glib, but this is reality.
By producing software for the management of business
processes, SAP enables every enterprise
to become intelligent and sustainable.
SAP S/4HANA is our next ERP generation
for business suite design for every line of business
and industries.
Many global companies have adopted
SAP S/4HANA Cloud or on-premise, and one of them is Alphabet.
Let me show you one of our customer's stories
and why this integration is so important.
Alphabet has 4,000 SAP S/4HANA users only
in the finance, which is huge.
Many employees are working on a daily basis
with both worlds, SAP and Google Cloud,
which are not connected today.
To cope with Alphabet's growth as a company,
the finance team are working on the intelligent finance, which
includes, for example, applying Google Cloud machine learning
on top of SAP business data, to close their books more
efficiently and with greater accuracy via automatic outlier
detection.
Many of our customers at SAP are moving to Google Workspace
and struggling with exposing data or conversion of files,
importing data from Google Sheets into SAP, and so on.
We will avoid all those manual steps
by providing an implementation of the seamless integration
between SAP S/4HANA and Google Workspace.
We have started the integration project at SAP
and we will deliver an initial set of features
as standard functionality for our customers this year.
So first use case is an export scenario.
You can directly export the SAP data from all UI tables
to Google Workspace in a Google Sheets format.
The second use case is an import scenario
to upload data from Google Sheets into SAP S/4HANA.
This year, only enabled for finance application
called general journal entries.
We are building a native integration leveraging our SAP
business technology platform for a tight integration
and a consistent user experience,
keeping the best functionalities of each business-centric
approach from SAP and the powerful collaboration
from Google Workspace.
Let's get more concrete with a short demo of the export
in the SAP system.
Leveraging the Google Workspace integration
provides you the possibility to export tables
to Google Workspace.
So after opening the Export As dialog,
you can select the Google Sheets format.
With clicking on Export To, a file browser dialog
opens, which gives you the possibility
to browse through your Google Drive repository.
We click on the Export, the file is being generated, transferred
to Google Drive, and then automatically opened
in a Google Sheets format.
Pretty straightforward.
We are working intensively together with Google Cloud
to deliver the best possible integration.
In 2023, we are planning to enhance our SAP
harmonized document management with Google Workspace
integration to be able to link Google Workspace
documents with SAP business objects
to find and work on Google Workspace document
directly from SAP S/4HANA applications.
We will also deliver a broader application adoption for--
of the upload from Google Sheets and more capabilities
for the export.
We are working closely with our customers on their use cases
and involve them during the development phases
to define together the next releases.
Our customers are really pushing this integration,
and it is only the beginning between SAP and Google Cloud.
More to come with projects regarding
an integration with Google Meet, Google Chat, and so on.
Wesley, I'm looking forward.
To the audience, thank you for your attention,
and do not hesitate to reach out to me for further information.
Thank you.
WESLEY CHUN: Thanks, Hervé.
We've just seen some amazing and inspirational stories
on how to supercharge Google Workspace with Google Cloud.
Now, it's time to get you started.
For free skills training for you and your teams,
go to cloudskillsboost.google.
We listed four labs to get started on your journey.
On behalf of Brent, Hervé, and the Google Cloud and Workspace
teams, thank you for watching.
[MUSIC PLAYING]