Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Master Spreadsheet Automation - Google Sheets Masterclass

Name: Master Spreadsheet Automation - Google Sheets Masterclass
Rating: 4.5 (196 reviews)

Add Apps Script to your Skillset. Automate your business tasks → LIKE A PRO!

Created byAndrew Kamphey

Last updated 7/2025

English

What you'll learn

Save thousands of dollars by automating tasks instead of hiring someone
Break free from endless manual tasks in spreadsheets.
Automate your business. Your sheets can work while you sleep
Automate email notifications for timely communication
Unlock the Full Potential of Google Sheets with Triggers
Learn what Google Sheets can't do, so you don't waste time!
Automate data cleaning processes for accurate records
Generate instant reports without manual intervention
Minimize human errors in data entry and calculations
How to write, read, and use Google Apps Script, faster
Build sheets that behave like interactive web apps
Focus on important tasks while routine operations run automatically
Ensure data is accurate and consistent throughout your sheets
Automate data analysis processes for faster insights
Tailor Apps Script to create personalized, effective solutions
Automate complex workflows for seamless operations of your business
Develop coding skills in Google Apps Script
Apply coding practically for everyday tasks
Understand various Google Apps Script triggers for precise automation
Implement error handling techniques for robust scripts
Schedule tasks for specific dates and times automatically

Course content

17 sections • 104 lectures • 22h 13m total length

Where to Start Learning: Master Spreadsheet Automation9:55
Review Me1:35
Feel free to skip the review or let your review be known! Happy to make more videos to add to this course. I really want to make it the best spreadsheet course on Udemy.
Surprising Things I Learned Automating Spreadsheets7:04
What Do You Want to Automate?1:24

Introduction3:00
Dive into the world of App Script with our comprehensive course, Spreadsheet Automation 101. In this pre-course series, Andrew breaks down fundamental concepts such as function syntax, variables, and dot notation, ensuring you have a solid foundation before you start coding. Don't worry if you're new to coding; these videos are designed to eliminate confusion and get you coding right away. Whether you're a beginner or an experienced coder, these tutorials provide valuable insights and troubleshooting tips.
Functions4:59
Variables5:04
Dot Notation2:20
Camel Case4:26
Parentheses5:22

Email Yourself Introduction1:47
MailApp3:43
Email Yourself For Loop5:54
Send Email Every Week Trigger (Great for Reports)4:44
Email Other People For Loop5:16
Optional: Create a MicroManager Email Service For Yourself19:50
I'll show you how to set up a super powered checklist that can act like a micro manager. It emails you hourly with the top unchecked item on your To-Do list.
Create an Onboarding Scheduler17:59

Create Custom Functions that Autocomplete in Your Sheets10:38
Learn how to create custom functions like a pro. Discover the secrets behind abstracting complex calculations and crafting tailored solutions for your sheets. Dive into the world of limitless possibilities. Don't miss out!
Add Title Case to Google Sheets10:12
Watch Now to Learn How to Easily Convert Text to Title Case in Google Sheets! Say Goodbye to Confusing Formulas.
Calculate ROAS and Save as a Custom Function15:54
Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.
VAR vs CONST vs CONSTANT in Apps Script6:04
In this focused video, you'll learn the difference between variables (var), constants (const), and hardcoded constants (like AUTH_TOKEN = "...") in Google Apps Script. Through real examples from an email-sending script, you'll see how to use each type effectively. Whether you're building reusable functions, managing settings, or maintaining clean, flexible code. A great step toward writing smarter, more scalable scripts.

Create Your Own API by Deploying a Web App8:57
See how you can create your own API using Google Sheets' Web App feature. Deploy a web app and write doGet() to enable others to use an API you create yourself.
Integrate OpenAI API into Google Sheets Apps Script27:30
Use the power of OpenAI's GPT-3 inside of Google Sheets. In this quick start tutorial I show you how to take OpenAI's curl commands and change them into Apps Script to use GPT-3 inside of sheets. We write a tweet, we ask questions. And now you can use this power for greater good!
Capture OpenSea Data inside of Google Sheets7:34
Get floor prices into your spreadsheet with URLFETCHAPP. Accessing OpenSea's API directly from google sheets. Get any data you want. from Market Cap to One Hour Volume
Upgrade OpenAI API Integration to GPT-418:33
Upgrade to OpenAI's GPT 4 in your Google Sheets. And use GPT-3.5: Turbo for Powerful AI Prompt Calls!
Learn how the new model enhances chat capabilities, including distinct messages and system prompts. Boost your productivity by integrating AI into your Google Sheets.
How to Validate Emails with an External API17:36
I will show you how to validate email addresses using the Mailboxlayer API and Google Sheets Apps Script.
I will guide you through the process of checking MX records, SMTP checks, and other cool features.
By the end of the video, you will be able to validate up to a thousand email addresses per month.
get your free apikey and 1,000 requests at mailboxlayer.com
Access the Dictionary API to get Definitions for Words in Google Sheets10:22
Get the sheet and code belowl
Use Random Quote API in Google Sheets8:45
Learn how to add random movie quotes and famous quotes to a Google Sheet. We'll use RapidAPI to get the code and just have a little bit of editing to the code to be able to use it in Google Sheets.

Formulas that Seem Like Automation14:05
Automatically Uncheck a Daily Checklist6:17
Automate Google Sheets without any Experience22:21
The Google Sheet that Deletes Itself (Just for Fun)6:47
An Automatically Whitening Spreadsheet9:34
Delete Lines with Apps Script9:53
Create a Pop Up Message in Google Sheets7:03
Automatically Clear Content | Refresh Reuse Recycle Templates16:16
Create a Checklist that Deletes Items if Unchecked9:03
Create a self deleting checklist. If you dont' check off ideas as done, they will be destroyed.
Automatically Open a Tab to a Random Motivational Quote Every Time4:02
Each time you open a sheet, you can active a certain tab automatically. This starts the user on the same tab no matter what URL they use. The automation uses a simple onOpen trigger you can just type as your function name.
Create Calendar Event With Natural Language in Google Sheets8:28
Learn how to automate the creation and management of Google Calendar events directly from Google Sheets using Google Apps Script. This tutorial walks you through scripting functions to create, log, and delete events with natural language descriptions, enhancing your productivity and project management. By the end of this video, you'll be able to generate calendar events based on textual input and manage them efficiently, all within Google Sheets.

Requirements

Internet Access
Access to Google Sheets
Basic knowledge of Google Spreadsheet
No programming experience needed
A strong desire to code is preferred
A Google Workspace Account is preferred

Description

Too much of your time is spent in spreadsheet hell. Learning, researching, functions and formulas can feel like a lonely job.

Build magical & effective sheets by learning how to automate with Apps Script -- saving you thousands of dollars, hours, and therapy sessions.

Key outcomes

Learn to automate Google Sheets, so your sheets perform like web apps

Learn to automate almost anything, from data analysis to email notification. You can make Google Sheets do your bidding, even while you sleep. I call this Advanced Sorcery.

You'll learn how to write, read, and use Google Apps Script, faster.

You'll learn how to write actual code in Google Apps Script. Also learn how to read code and do more, faster. We use practical, every day uses of code to learn how it can be used most effectively. I've used code for more than 8 years.

Automate anything, so that your sheets work while you sleep.

I'll show you all the triggers possible for your Apps Script. Trigger scripts to run while you sleep. Trigger email sequences. Trigger reports. Trigger nearly anything.

Learn what Google Sheets can't do, so you don't waste time!

I've lived to tell the tale. I've broken Google Sheets and run up against its limits. Find out what's actually impossible to do in Google Sheets. You can learn to overcome some of these limits.

Who this course is for:

Ideal for entrepreneurs managing various aspects of their business data.
Managers who want to automate their team updates, and keep on top of projects better.
Startup Founders who want to build an MVP organization that will last through the first five years of their newest venture.
Small business owners who want to keep on top of their metrics.
Google Sheet Nerds who want to take their Google Sheets skills to the next level.
Essential for professionals diving deep into data patterns and trends
Useful for marketers analyzing campaign performance data.
Beneficial for optimizing processes and workflows.
Helpful for project managers tracking project progress and budgets.
Great for sales teams managing customer data and sales figures.
Valuable for students studying data analysis or programming.
Useful for freelancers managing diverse clients and projects.
Essential for researchers analyzing research data efficiently.
Beneficial for those involved in data entry tasks, improving efficiency.
Indispensable for managing donor information and fundraising data.
Great for managing property listings, client information, and sales data.
Useful for organizing events, managing guest lists, and budgets.
Valuable for healthcare workers managing data.
Great for optimizing stock levels and managing inventory data.
Useful for entrepreneurs launching and scaling their startups.
Indispensable for managing various aspects of small businesses.
Valuable for tracking customer issues and feedback data.

Master Spreadsheet Automation - Google Sheets Masterclass

What you'll learn

Explore related topics

Course content

Get Started Automating4 lectures • 20min

Google Apps Script Fundementals6 lectures • 25min

Get Data From a Google Spreadsheet: GetValue5 lectures • 28min

Get More than a Single Piece of Data From a Google Spreadsheet: GetValues7 lectures • 52min

Send Email From Google Sheets7 lectures • 59min

Access APIs6 lectures • 21min

Create Your Own Custom Functions in Google Sheets4 lectures • 43min

Optional: Additional API Examples7 lectures • 1hr 39min

Simple Automations in Google Sheets11 lectures • 1hr 54min

Automation Examples4 lectures • 49min

Requirements

Description

Who this course is for: