Google Workspace - Sheets Automation For Non Programmers
Course Description
Google Workspace (formerly known as GSuite) is a suite of cloud based productivity and collaboration tools that are a competitor to Microsoft Office 365. The suite has a full programing interface and can be customised and automated in a variety of ways. This is a hands-on course that gives participants an opportunity to learn how to program and automate functions in Google Sheets the Google Apps Spreadsheet in Google Workspace.
If you have never done any programming this course will open your eyes as to how you can automate various functions in Google Workspace and Sheets in particular.
3 days
Contact us for pricing
Prerequisites
NoneG Suite Overview
This lesson is an overview of the Google Workspace applications such as Google Documents, Google Sheets,Basic Scripting
Opening the script editorCode.gs.
What computer programming language is gs?
Basic syntax, creating a hello world function.
Calling the function.
Automating a task in Google Documents
Find a problem to solve.Some ideas of things that can be automated
Create a function to solve it.
Various ways of getting the function to run.
Basic programming techniques
Before you can program there are a number of basic concepts that you need to understand. How do we store values? How can we group code into reusable pieces? How do we make decisions? How do we program repetitive tasks? This lesson will introduce these concepts and show you how to do them in the script editor.Variables
Functions
Making decisions - If statement
Repetition - loops
Passing data to a function
Getting an answer from a function
Debugging - What to do when things don’t work
Getting feedback from your codeHow do you know which lines are being run?
How do you know that the computer has calculated the right answer?
How do you determine where things went wrong?
What is a Debugger?
How do I set a Breakpoint?
Stepping through code one line at a time
Viewing the values
Creating a custom function in Google Sheets
Google Sheets has a wide variety of built in functions but they don’t cover everything that you could possibly need. Eventually you may need to create your own function. Often you will end up with an incredibly complex formula that can be vastly simplified by having a custom function. This module will show you how to write your own custom functions.Creating a function
Putting your custom function in a cell
Testing and debugging
Error handling
Programming Spreadsheet tasks
Working with rangesIterating through a range
Reading values from a cell
Writing values to a cell
Reading a formula from a cell
Writing a formula to a cell
Copying a row
Creating a new sheet
Copying data to the new sheet
Google Workspace Integration
Integrating with other parts of Google WorkspaceCreating a Google Docs document from your spreadsheet
Sending this document in an email.
DocsG SuiteGoogle AppsGoogle Cloud PlatformGoogle DocsGoogle SheetsGoogle SuiteGSuiteSlidesGoogle Workspace