Use Google Apps Script to automate repetitive tasks, create custom functions, import data & connect to external tools
Free tutorial
3,976 students
58min of on-demand video
Created by Ruben Portz
English
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
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
Show less
Course content
1 section • 11 lectures • 57m total length
Google Apps Script11 lectures • 58min
- Introduction02:11
- Automating repetitive tasks in Google Sheets using Macros06:02
- Introduction to the Google Apps script editor in Google Sheets04:03
- Introduction to the Spreadsheet service: SpreadsheetApp, Spreadsheet, Sheet, and05:33
- Creating custom formulas in Google Sheets06:39
- Creating a custom menu and menu items in Google Sheets06:34
- Trigger Apps Script via the onOpen() function in Google Sheets01:15
- Trigger Apps Script via call-to-action buttons01:44
- Trigger Apps Script via built-in timers (hourly, daily, etc.)02:04
- Fetching external data with Apps Script13:25
- Making API calls to 3rd party tools with Apps Script (Example: Slack)08:28