Workspace: Integrations for Data

5 hours Introductory universal_currency_alt 3 Credits

This Quest of hands-on labs demonstrates the power of integrating Google Cloud services and tools with Workspace applications. You will create direct connections to Google Cloud data sources using the BigQuery API, Apps Script, Sheets, and Slides to collect, analyze and present data.

Badge for Workspace: Integrations for Data

When you complete this activity, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!

Lab

Connected Sheets: Qwik Start

With Connected Sheets, you can analyze billions of rows and petabytes of data in Google Sheets without specialized knowledge of computer languages like SQL. In this hands-on-lab, you will learn how to connect a BigQuery dataset to Google Sheets and analyze your data.

Lab

Examining BigQuery Billing Data in Google Sheets

Use Google Workspace Connected Sheets to harness the power of BigQuery. Connected Sheets lets you access and use data analytic functions to run queries and analyze data. You could create a Sheet to access and analyze your sales data, for example, then configure your Sheet to always reflect current data.

Lab

Introduction to APIs in Google

This lab will teach you about the architecture and basic functioning of Application Programming Interfaces (APIs). This will be supplemented with hands-on practice, where you will configure and run Cloud Storage API methods in Cloud Shell.

Lab

Big Data Analysis to a Slide Presentation

This lab leverages two Google developer platforms: G Suite and Google Cloud Platform (GCP). It uses GCP's BigQuery API, Sheets, and Slides to collect, analyze and present data.

Lab

Google Apps Script: Access Google Sheets, Maps & Gmail in 4 Lines of Code

In this lab, we'll introduce you to one of the easiest ways to write code that accesses Google developer technologies, all by leveraging one of the mainstream web development languages, JavaScript.

info

Quest Info

Prerequisites

This quest assumes familiarity with Workspace apps (Docs, Sheets, Calendar, Gmail, Hangouts Chat) as a power user. Before taking the labs in this quest, you should have developed a familiarity with basic Google Cloud Platform services and tools by also taking the labs and earning a badge for the Google Cloud Essentials quest.

Available languages

English, 日本語, español (Latinoamérica), français, and português (Brasil)

What do I do when I finish this quest?

After finishing this quest, you can explore additional content in your learning path or browse the learning catalog.

What badges can I earn?

Upon finishing a quest, you will earn a badge of completion. Some quests test your ability to apply your knowledge via a final assessment challenge lab. For these quests, you will receive a skill badge. Badges can be viewed on your profile and shared with your social network.