Workspace: Integrations

Go to class
Write Review

Workspace: Integrations provided by Qwiklabs is a comprehensive online course, which lasts for 7 hours worth of material. Upon completion of the course, you can receive an e-certificate from Qwiklabs. The course is taught in Englishand is Free Certificate. Visit the course page at Qwiklabs for detailed price information.

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

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-o
      • 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 Scrip
      • Learn how to create a simple Google Cha 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.
    • ig Data Analysis to a Slide Presentatio
      • 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.
    • uild a Google Workspace Add-on with Node.js and Cloud Ru
      • In this lab you'll learn how to build a Google Workspace Add-on using Node.js and Cloud Run.