Udemy

Learn Google Apps Script and Become a Google Sheets Master

Use Google Apps Script to automate repetitive tasks, create custom functions, import data & connect to external tools
Free tutorial
Rating: 4.3 out of 5 (171 ratings)
4,109 students
58min of on-demand video
English
English [Auto]

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

Instructor

Founder of TractionPad
Ruben Portz
  • 4.4 Instructor Rating
  • 1,054 Reviews
  • 26,060 Students
  • 6 Courses

I'm the creator of TractionPad. An online platform where I share growth & marketing templates to help startups build repeatable sales systems.

Before that, I worked as the Head of Growth at Seneca Learning which is an online learning platform that I've helped grow to over 6 million users and expand internationally. I've also spent a year in Venture Capital supporting a portfolio of Seed & Series A startups. I'm also a guest lecturer at Imperial College London for the MEng in Design Engineering programme and work as an Entrepreneur in Residence during the yearly London School of Economics startup accelerator.

Top companies trust Udemy

Get your team access to Udemy's top 19,000+ courses