TRY ME!
→ Random Tutorial

350 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀
Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯
Precise: Ensure your data is always accurate and your analysis is clear.
🌈
Creative: Discover new ways to use Google Sheets.
❌
Can't Find a Video?: Members can reach out and ask me anything!

How to Name Sheet Tabs

How to Name Sheet Tabs

Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.
Beginner
Basic CRM - Add a Powerful Script To Move Row Based on Status

Basic CRM - Add a Powerful Script To Move Row Based on Status

we're going to be adding a very powerful script to our CRMs or any database in which you need to move rows between tabs.
Advanced
5 Ways to Create Coupon Codes | Create UUIDs

5 Ways to Create Coupon Codes | Create UUIDs

Generate Coupon Codes with 5 Levels of Difficulty - From Copy-Pasting to Advanced Google Sheets Formulas. Get up to thousands of unique codes easily! Watch now for coupon mastery inside of Google Sheets.
CHAR() DEC2HEX() MID() RANDBETWEEN()
Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

We’re getting data on movies and getting it into Google Sheets. Let’s create some magic inside Google Sheets!
Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script

Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script

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.
Pros and Cons of Sheet Protection and Collaboration

Pros and Cons of Sheet Protection and Collaboration

Learn how to protect your Google Sheets while still collaborating effectively! Discover the three levels of protection and editability, as well as how to set permissions for specific ranges and cells. With Google Sheets, you can have the best of both worlds: a protected and collaborative sheet.
Data validation
Created a GPT function in Sheets

Created a GPT function in Sheets

Unlock the Power of OpenAI: Create Ultimate GPT Prompts for Seamless Interaction! Discover the Formula Inside, Explore APIs, and Boost Productivity. Watch Now!
Advanced
Ultimate Headline Writer with GPT in SHEETS

Ultimate Headline Writer with GPT in SHEETS

Create the Ultimate Headline Writer: Unleash the Power of Google Sheets and OpenAI's API / GPT-3.5-Turbor to Create Compelling Website Headlines. Write in different styles, using different parameters to make the ultimate headline writer for an agency or for your own business.
Advanced
IF() ISBLANK()
Why Different Cell References in AI Integration in Sheets?

Why Different Cell References in AI Integration in Sheets?

Find out How to Optimize your Apps Script functions. Learn the trade offs between flexibility, edit-ability, and protection. Different cell references allow you to do more with your apps script.

In the context of the video we're talking about an AI prompt and how I used different Cell References when writing different Apps Script functions. I'll show you why I chose those syntaxes and why you might choose different ones.

This video is more about Apps Script than writing Prompts but can help you create better web apps inside of Google Sheet, utilizing the best of Apps Script and creating your own custom functions.
Advanced
Create a ChatGPT Cheat Sheet Spreadsheet

Create a ChatGPT Cheat Sheet Spreadsheet

Walk through step-by-step going from a blank sheet to an AI powered prompt engineering cheat sheet of a spreadsheet.

Watch the Upgrade to GPT-4 video to see the differences between GPT-3 and GPT-4 Apps Script

Intermediate
CONCATENATE() COUNTIF() IF() ISBLANK() LEN() +2 more
Create Your Own Pride Flag Easter Egg in Sheets

Create Your Own Pride Flag Easter Egg in Sheets

If you type the letters of PRIDE in the first 5 columns in the first row of your sheets they'll turn the color of the pride flag. If you want to create your own easter egg in sheets then follow along this step-by-step tutorial as I show you how.

This might be better than Conditional Formatting! We're using the onEdit() simple trigger in Apps Script..
Conditional Formatting Advanced
What is an add on? What problems can it solve?

What is an add on? What problems can it solve?

Discover what an Add-on is, what it could possibly do and what kind of problems an add-on can solve. There are much more in depth idea driven videos later in the course. For those who might want to know exactly what an add-on is, this video help you out!
 Add Autocomplete with Custom Function

Add Autocomplete with Custom Function

We'll make sure our additional custom formula acts like a native formula with autocomplete in a cell.
 How to Name Your Add-on

How to Name Your Add-on

The most important part of the whole add-on creating process is naming it correctly. Avoid any and all existing names, as well as avoid any names that might conflict with Google Sheets itself.
 Add-on menu on open

Add-on menu on open

Instead of just adding a custom menu to a sheet, we're going to turn this apps script into an add-on menu operable add-on. 
 Connect to a Google Cloud Project

Connect to a Google Cloud Project

This part can be very confusing. So I show you step-by-step how to do it.
 Add-on Logo Design

Add-on Logo Design

Using Canva, we'll make a quick logo. A very quick logo for our Google Sheets™ Add-on
 Add-on Banner Design

Add-on Banner Design

Create a banner. This is the thumbnail image that will appear in the Google Workspace Marketplace
 Add-on Screenshots

Add-on Screenshots

We need to take screenshots of the add-on in action. These will be available for users to see how the ad-on works with in the Google Workspace Marketplace. We'll also use these same screenshots later on for launching and on our website. 
 Add-on Web Site

Add-on Web Site

Create a Carrd website for our Add-on. In this video I show you the exact template I use to make this process smooth as butter.

Get yourself a Carrd membership and copy the template here: https://24ddb0a6ef0fc2ca.demo.carrd.co

The website needs to include:
  • Privacy Policy
  • Terms of Service
  • Support

Displaying items 221-240 of 350 in total

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons