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