TRY ME!
→ Random Tutorial

361 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
Wrangle Scattered Data with Flatten()

Wrangle Scattered Data with Flatten()

Check out how to use flatten(). Discover the funky formula that makes data wrangling a breeze! Learn how to use Flatten in Google Sheets to organize scattered data and get insights that were previously hidden. Read on to see how this simple trick can save you hours of manual labor. 
Beginner
FLATTEN()
Create a CPM Custom Function (Create Better Calculators!)

Create a CPM Custom Function (Create Better Calculators!)

this is gonna be fun because we get to create a calculator with Apps Script.
Beginner
Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu

Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu

This lesson will get you started on your first trigger. It’s the first real spreadsheet automation you can do. Fun stuff!
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
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.
 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.
 Replace 1,000 Formulas Instantly

Replace 1,000 Formulas Instantly

Learn a cool trick you can do with the ArrayFormula. If you don't know what the ArrayFormula does, I show you how to use it in the first few minutes of this video.  Then show you how to use it better.
Beginner
ARRAYFORMULA() SORT()
How Starter Story Designs Data

How Starter Story Designs Data

Learn how Starter Story, and Pat Walls, created a report that is well designed and packed with information.

Get the report at starterstory.com/solopreneur
Beginner
How to Validate Email Addresses

How to Validate Email Addresses

 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
Intermediate
How to Create a Google Form Automatically

How to Create a Google Form Automatically

How to create a form programmatically using Google Apps Script. I show you step-by-step how to create a form, set the title, add text items, and set the destination of the form to a specific sheet. This tutorial is perfect for anyone who wants to automate the process of creating forms, whether it's for templates, lead magnets, or recurring forms. No prior coding experience is required.
Intermediate
Set up Stripe with Only Sheets

Set up Stripe with Only Sheets

I will guide you through the process of setting up Stripe with Only Sheets. I will show you how to make a copy of Only Sheets in your Google Drive, configure the necessary settings in Stripe, and deploy a web app.

Additionally, I will explain how to create a payment link in Stripe and set up webhooks.

Finally, I will demonstrate how to revoke access to the sheet and answer any questions you may have. Please make sure to follow along and take notes as needed.

Watch the 1st set up video: https://bettersheets.co/tutorials/announcing-onlysheets-2-0

Intermediate
SECTION 1 - You Are The Sheet

SECTION 1 - You Are The Sheet

Selling Spreadsheets Section 1: You are the Sheet Introduction

Over the course of this section of selling spreadsheets, I'm going to share with you some theories that I have of how to bring your entire self into the world. To the spreadsheet that you're selling. Not just the idea, and not just the sheet itself, and not just your time, not just your energy, not just your experience, but everything holistically.
 Customer’s Context Is King

Customer’s Context Is King

How to think about the context, psychological state, of your customer, so that you can sell them a solution.
 Easiest Sheet Ever to Sell

Easiest Sheet Ever to Sell

Displaying items 221-240 of 361 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