Google Workspace - Google Apps Script for Integration and Add-ons

Course Description

Because Google Workspace is a suite of products in the cloud there are nice opportunities to integrate between the various parts of the suite. This module will build on the introduction to scripting and do a real example of an integration task that works with Sheets, Docs, Google Drive and Gmail.
1 Day
Contact us for pricing
 

Prerequisites

Participants should be experienced Google Workspace users or advanced MS Office users.

Integration example

Create a spreadsheet
Add a menu to the Sheets application
Create a script that is launched when you select the menu option
The script will create a document from the information in the spreadsheet and save the file to google drive and that document will be sent as a pdf to a gmail recipient.

Google Workspace Add-ons

Google Workspace is extensible through the use of Add-ons that implement features that are not built into the base products. These Add-ons can be obtained from third parties or you can write your own. We will look at some of the options available.

Adding a MailMerge Add-on from the marketplace

Do a MailMerge task using the Add-on.
Examples of other Add-ons
Creating your own Add-ons
DocsG SuiteGoogle AppsGoogle Cloud PlatformGoogle DocsGoogle SheetsGoogle SuiteGSuiteSlidesGoogleGoogle Apps ScriptGoogle Workspace