Workspace: Integrations

This Quest of hands-on labs demonstrates the power of integrating Google Cloud services and tools with Workspace (formerly G Suite) applications. With integration technologies like the Clasp Command Line environment, you will create and publish web apps and add-ons for Workspace products: Sheets, Docs, Forms, and Slides. In other labs you'll create direct connections to Google Cloud data sources using the BigQuery API, Sheets, and Slides to collect, analyze and present data.

• 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.
• Creating a Gmail Add-on
• In this hands-on lab you create a Gmail Add-on that allows you to quickly change the labels of an email thread.
• 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.
• The Apps Script CLI - clasp
• The Apps Script CLI, or clasp, is a tool that lets you to create, edit, and deploy Apps Script projects locally and create and publish web apps and add-ons for products like Sheets, Docs, Forms, and Slides from the command line.
• warning Google Chat bot - Apps Script
• Learn how to create a simple Google Chat bot—"Attendance Bot"—using Google Apps Script. The bot integrates with Gmail to set a user's vacation responder and integrates with Calendar to put a meeting on the user's calendar.
• 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.
• Using the Natural Language API from Google Docs
• In this hands-on lab, you will use Apps Script to call the Natural Language API from Google Docs to analyze the sentiment of selected text in the document.
• Build a Google Workspace Add-on with Node.js and Cloud Run
• In this lab you'll learn how to build a Google Workspace Add-on using Node.js and Cloud Run.