Learn Google Apps Script and Become a Google Sheets Master

Learn Google Apps Script and Become a Google Sheets Master, available at $19.99, has an average rating of 4.4, with 11 lectures, based on 213 reviews, and has 5242 subscribers.

You will learn about 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 This course is ideal for individuals who are Google Sheets users interested in becoming more technical It is particularly useful for Google Sheets users interested in becoming more technical.

Enroll now: Learn Google Apps Script and Become a Google Sheets Master

Summary

Title: Learn Google Apps Script and Become a Google Sheets Master

Price: $19.99

Average Rating: 4.4

Number of Lectures: 11

Number of Published Lectures: 11

Number of Curriculum Items: 11

Number of Published Curriculum Objects: 11

Original Price: ￡19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Google Sheets users interested in becoming more technical

Target Audiences

Google Sheets users interested in becoming more technical

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.

Course Curriculum

Chapter 1: Google Apps Script

Lecture 1: Introduction

Lecture 2: Automating repetitive tasks in Google Sheets using Macros

Lecture 3: Introduction to the Google Apps script editor in Google Sheets

Lecture 4: Introduction to the Spreadsheet service: SpreadsheetApp, Spreadsheet, Sheet, and

Lecture 5: Creating custom formulas in Google Sheets

Lecture 6: Creating a custom menu and menu items in Google Sheets

Lecture 7: Trigger Apps Script via the onOpen() function in Google Sheets

Lecture 8: Trigger Apps Script via call-to-action buttons

Lecture 9: Trigger Apps Script via built-in timers (hourly, daily, etc.)

Lecture 10: Fetching external data with Apps Script

Lecture 11: Making API calls to 3rd party tools with Apps Script (Example: Slack)

Instructors

Ruben Portz
Founder of TractionPad

Rating Distribution

1 stars: 3 votes

2 stars: 6 votes

3 stars: 18 votes

4 stars: 83 votes

5 stars: 103 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!