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
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.
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.