Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Google Apps Script and Become a Google Sheets Master
Rating: 4.2 out of 5(224 ratings)
5,260 students

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
Created byRuben Portz
Last updated 1/2021
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

Course content

1 section • 11 lectures • 57m total length

  • Introduction2:11
  • Automating repetitive tasks in Google Sheets using Macros6:02
  • Introduction to the Google Apps script editor in Google Sheets4:03
  • Introduction to the Spreadsheet service: SpreadsheetApp, Spreadsheet, Sheet, and5:33
  • Creating custom formulas in Google Sheets6:39
  • Creating a custom menu and menu items in Google Sheets6:34
  • Trigger Apps Script via the onOpen() function in Google Sheets1:15
  • Trigger Apps Script via call-to-action buttons1:44
  • Trigger Apps Script via built-in timers (hourly, daily, etc.)2:04
  • Fetching external data with Apps Script13:25
  • Making API calls to 3rd party tools with Apps Script (Example: Slack)8:28

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

Report abuse