menu

G Suite: Integrations

Advanced 9 Labs 7h 20m 49 Credits

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 Development Data Gsuite

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

Hands-On Lab

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.

Hands-On Lab

Getting Started - App Maker

Create you own App Maker app that has a Google Cloud SQL Database, Google Maps integration, and a Mobile Responsive Design. And of course, fully published and ready to use.

Hands-On Lab

Write Apps That Access G Suite APIs

This lab introduces you to G Suite (REST/HTTP) APIs. You manage a project in the Google Cloud Platform, obtain the credentials needed, and then write an app to display the first 100 files and folders in your Google Drive using the Google Drive API.

Hands-On Lab

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. It allows you to create and publish web apps and add-ons for products like Sheets, Docs, Forms, and Slides from the command line.

Hands-On Lab

Hangouts Chat bot - Apps Script

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.

Hands-On Lab

Google Sheets as a Reporting Tool: Sheets API

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.

Hands-On Lab

Google Slides API as a Custom Presentation Tool

In this lab, you’ll build a presentation using the Google Slides API and BigQuery to report an analysis of the most common software licenses.

Hands-On Lab

Big Data Analysis to 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.

Hands-On Lab

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.

Enroll Now

Enroll in this quest to track your progress toward earning a badge.

home
Home
school
Catalog
menu
More
More