Google Workspace - Custom Functions and Automation Introduction

Course Description

This is an introduction to the scripting features that are available in Google Workspace. There are two broad use cases - creating custom functions and automating tasks. Custom functions can make your sheets easier to understand or can do things that are not possible with the built-in functions. Automating repetitive tasks is another use for scripting and can take help you work smarter rather than harder and eliminate potential sources of human error.
1 Day
Contact us for pricing
 

Prerequisites

Participants should be experienced Google Workspace users - or MS Office Advanced users.

Scripting Introduction

Google Workspace scripting is done using Google Apps Script which is a JavaScript variant. This lesson will look at the script editor and introduce the basic scripting syntax.

A Google Workspace custom function

A simple custom function
A more complicated custom function

Automating a task

The Google Workspace custom function second use case is to automate a task.
Perhaps you have to do three operations every time you open a Sheet - you can automate these to become a single operation.
We will create some simple scripts for automating tasks.

Launching a script

When you have a reusable script you will need to launch it. There are various techniques for doing this. We will look at adding a clickable element to a sheet and modifying the menu structure.

Recording a macro / script

A new feature in Google Workspace is the ability to record a macro.
Customising a recorded macro.
Launching a macro.
DocsG SuiteGoogle AppsGoogle Cloud PlatformGoogle DocsGoogle SheetsGoogle SuiteGSuiteSlidesGoogleGoogle Apps ScriptGoogle Workspace