G Suite: Integrations

Advanced11 Steps1 day33 积分

This Quest of hands-on labs demonstrates the power of integrating Google Cloud Platform services and tools with G Suite applications. With integration technologies such as App Script and the Clasp Command Line environment, you will create and publish web apps and add-ons for G Suite products: Sheets, Docs, Forms, and Slides. With App Maker you will build a ready-to-use app that has a Google Cloud SQL Database, Google Maps integration, and a Mobile Responsive Design. Other labs create direct connections to GCP data sources-- using the BigQuery API, Sheets, and Slides to collect, analyze and present data.

Application DevelopmentDataGsuite

Prerequisites:

This Quest assumes familiarity with G Suite 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 GCP Essentials Quest.

Quest Outline

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.

In this lab, you will receive hands-on practice with the Google Drive (REST/HTTP) API. After enabling the API and obtaining the credentials needed, you will make an API request through an application that lists the first 100 files and folders in your Drive.

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.

Learn how to create a simple Hangouts 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.

In this lab, you'll learn how you can use Google Sheets as a custom reporting tool for your users. You’ll be modifying a sample order tracking application to export to spreadsheet and build visualizations using the Google Sheets API.