81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199


See the full list of Tutorials to learn from

We have a list of names and maybe we have sort of a lead categories. Maybe we're doing sort of reach out and we want to actually maybe combine like key words.
Learn how to think like a programmer and develop a coding mindset with these expert tips from a seasoned Google Sheets programmer. Don't fall for the common, ineffective advice, and instead follow this practical advice, including learning the process, figuring out how to search, and avoiding memorization. With these habits, you'll be on the path to successful coding. 

It's hard to code. It's even harder to learn to code. This is my thought process to help you become resilient enough to learn, and continue to learn to code.
4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.


Get more things than just the poster and movie title by changing our script a bit. By creating different functions, we can get other data such as movie posters or directors.
Learn how we get information out of a JSON response. I’ll even show you how you can bring in some cool images in Google Sheets!
Use getData and UrlFetchApp functions, as well as Logger to get OMDb API data in our Google Sheet. Learn how to access an API outside of Google Sheets.
Capture data from OMDb in our Google Sheets with a free API Key. It’s easier than it sounds. Let’s do this!
Use any URL to scrape the web or access an API and get that info into your Google Sheet.
We’re getting data on movies and getting it into Google Sheets. Let’s create some magic inside Google Sheets!
Send the same email to different people by using the same Four Loop to figure out which ones we’re sending. Do cool things with this Mail App and email system.
Learn about how to add and delete Triggers very quickly. I’ll teach you how you can send out an email regularly using Triggers.
I’ll walk you through how you can receive an email about tasks that haven’t been done.
Learn about the needed variables for the Mail App to work. In this lesson, I’ll walk you through how you can email yourself or other people the items in a to-do list that hasn’t been done yet.
This lesson will teach you how to email yourself by sending some texts. Learn how to get some data from your sheet and send them into your inboxes or other people’s inboxes.
One of the things to learn: We can only have one onEdit() in our entire spreadsheet file. I’ll also walk you through on how you can use Event and Logger to get cool information.
Let’s talk about the IF formula and the differences. Learn how to insert a checkbox and all the other things it can do for you.
Learn to log any variable you want and get notes inside your log. Debug your code to understand what’s going on and find out where you went wrong.
Learn how and when to use Bracket Notation in an array. No memorization is needed!. You’ll also be able to see the gap between what it is that’s missing.
Learn about the syntax of the For Loop. Find out how to do fantastic automations.
Learn the basics of Arrays – how to create one, how to reference rows and columns of data in a different way, and how to get an entire column or row in Apps Script.

Displaying items 81-100 of 353 in total