menu

G Suite: Integrations

Advanced 8 个步骤 6 个小时 21 个积分

This Quest of hands-on labs demonstrates the power of integrating Google Cloud services and tools with G Suite applications. With integration technologies like the Clasp Command Line environment, you will create and publish web apps and add-ons for G Suite 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.

Application Development Data Gsuite

预备知识:

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

实操实验

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.

Deutsch English español (Latinoamérica) français Italiano 日本語 Polski português (Brasil)
实操实验

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.

Deutsch English español (Latinoamérica) français 日本語 português (Brasil)
实操实验

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.

Deutsch English español (Latinoamérica) français 日本語 português (Brasil)
实操实验

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.

Deutsch English español (Latinoamérica) français 日本語 português (Brasil)
实操实验

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.

Deutsch English español (Latinoamérica) français 日本語 português (Brasil)
实操实验

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.

Deutsch English español (Latinoamérica) français 日本語 português (Brasil)
实操实验

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.

Deutsch English español (Latinoamérica) français Italiano 日本語 Polski português (Brasil)
实操实验

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.

Deutsch English español (Latinoamérica) français 日本語 português (Brasil)

立即注册

注册该挑战任务,系统会全程跟踪进度,直到您赢得徽章为止。