Learn Google Apps Script and Become a Google Sheets Master

Name: Learn Google Apps Script and Become a Google Sheets Master
Rating: 4.2 (224 reviews)

Use Google Apps Script to automate repetitive tasks, create custom functions, import data & connect to external tools

Created byRuben Portz

Last updated 1/2021

English

English [Auto],

What you'll learn

Create a Slack message bot in Google Sheets
Write custom formulas in Google Sheets
Automate repetitive tasks using Macros or scripts
Make API requests to external sources for data collection
Send spreadsheet data to 3rd party tools
Understand the SpreadsheetApp service in Google Sheets
Change the layout of Google Sheets with sidebars & menus
Connect multiple 3rd party tools via Apps Script

Course content

1 section • 11 lectures • 57m total length

Introduction2:11
Learn to automate repetitive tasks in Google Sheets using Google Apps Script, start with custom formulas and menus, and import export data with triggers and practice examples.
Automating repetitive tasks in Google Sheets using Macros6:02
Learn to automate repetitive tasks in Google Sheets by recording macros, applying array formulas and regular expression extraction to update first names via Google Apps Script.
Introduction to the Google Apps script editor in Google Sheets4:03
Explore Google Apps Script and the editor in Google Sheets to automate tasks, create scripts and macros with functions, run them from the editor, and set time-driven triggers.
Introduction to the Spreadsheet service: SpreadsheetApp, Spreadsheet, Sheet, and5:33
Learn to use spreadsheet service with SpreadsheetApp, get the active spreadsheet and Sandbox sheet, read A1 and B1, multiply them, and write the result to C3.
Creating custom formulas in Google Sheets6:39
Learn to create custom formulas in Google Sheets with Apps Script. Build a first name function to extract and capitalize the first name from a full name.
Creating a custom menu and menu items in Google Sheets6:34
Learn how to create custom menus and a custom sidebar in Google Sheets using Google Apps Script, triggering a multiplication script from the menu with on open.
Trigger Apps Script via the onOpen() function in Google Sheets1:15
Explore triggering Google Sheets actions with the onOpen function in Google Apps Script, define onOpen to access the UI and create menus, and review other triggers like onInstall and onEdit.
Trigger Apps Script via call-to-action buttons1:44
Learn how to add buttons to Google Sheets that trigger Google Apps Script functions with a custom menu and a sidebar, along with on open triggers for intuitive use.
Trigger Apps Script via built-in timers (hourly, daily, etc.)2:04
Explore built-in time-driven triggers in Google Sheets that run automatically, even when your laptop is off. Set a daily morning trigger for the multiplication script and receive email reports.
Fetching external data with Apps Script13:25
Fetch external data with Google Apps Script to pull third-party data via API calls, convert JSON responses, and insert titles into a Google Sheet.
Making API calls to 3rd party tools with Apps Script (Example: Slack)8:28
Post data from a Google Apps Script to a Slack channel using a post request, with a dynamic payload built from sheet values.

Requirements

Good understanding of Google Sheets
Basic understanding of JavaScript

Description

Google Apps Script for Google Sheets

In this course, I'll show you how to create:

Custom functions
Ways to automate repetitive tasks
Fetch data from external sources
Send data from sheets to external tools like Slack
Trigger scripts automatically while asleep
Change the spreadsheet layout with menus, sidebars and popups

To help you navigate the world of Apps Scripts, I've created a cheat sheet with the most important functions. This should take you through to the end of the course even if you've never worked with JavaScript.

Who this course is for:

Google Sheets users interested in becoming more technical