G Suite script for integration and G Suite Add-ons
Because GSuite 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.
Contact us for pricing
PrerequisitesParticipants should be experienced GSuite users or advanced MS Office users.
Integration exampleCreate 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.
GSuite Add-onsGSuite 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 marketplaceDo 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 Script