Learn Google Apps Script and Become a Google Sheets Master – Free Udemy Courses
Use Google Apps Script to automate repetitive tasks, create custom functions, import data & connect to external tools
What you’ll learn
Learn Google Apps Script and Become a Google Sheets Master – Free Udemy Courses
- 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
Add Comment