TRY ME!
→ Random Tutorial

244 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!

Add Title Case to Google Sheets

Add Title Case to Google Sheets

Discover the Ultimate Google Sheets Hack! Transform Text with Title Case Formula. Say Goodbye to 'Proper' and Hello to Easy Capitalization. Find Out How! 
Advanced
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
Run 100 ChatGPTs at One Time

Run 100 ChatGPTs at One Time

Create a ChatGPT prompt inside a sheet, edit that prompt with a single input 100 times over. In this case we're creating a twitter thread prompt and replacing the topic 100 times. so you can use 1 prompt to run 100 ai calls, and then we go further

We make it better.

We add a checkbox and another prompt to take the output of the 1st prompt and run it again. And we can do that 100 times too. So each horizontal row can be it's own ChatGPT.

You can get the ai Apps Script in this video's sheet or in the sheet connected to the GPT-4 upgrade: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4
Intermediate
IF() ISBLANK() SUBSTITUTE()
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 a Waterfall of AI Prompts and Responses

Create a Waterfall of AI Prompts and Responses

This is an attempt to create a waterfall effect in sheets. Where an AI response becomes the prompt in another ai API call.
I show you one way not to do it, that fails with onEdit() but then I do show one particular way it could work. We wrestle with AI a bit in this video and the conclusion is not so sweet.

Get the sheet below with the Apps Script and API code already written for you.
Advanced
IF() INDIRECT() ISBLANK()
Create a Course Outline in Google Sheets

Create a Course Outline in Google Sheets

Wanted to share with members this course outline I am using for my own course making process. I outlined the course then added a bunch of cool little stats to help see my progress and keep me on a certain pace of video creation. 
Beginner
CONCAT() CONCATENATE() COUNTA() COUNTIF() IF() +4 more
Two Things to Know When Starting to Learn Google Sheets

Two Things to Know When Starting to Learn Google Sheets

Beginner
IF() ISBLANK()
Introduction to Google Sheets™ Add-on Course

Introduction to Google Sheets™ Add-on Course

In this course we'll go step by excruciating step how to take a simple apps script from a bound script to your spreadsheet and turn it into a published Google Sheets add-on available to the public on the Google Workspace Marketplace.
 MAKE Your Google Sheets Add-on WORK

MAKE Your Google Sheets Add-on WORK

In this section of the Add-on course we'll be making the apps script work as an Add-on.
 Write Apps Script to Create a New Google Sheets Formula

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our Add-on we'll be publishing to the Google Workspace Marketplace.
 MAKE Your Google Sheets Add-on USABLE

MAKE Your Google Sheets Add-on USABLE

In this section we're going to turn our apps script into an add-on. complete with add-on menu. (Yes it's different than a custom menu, slightly).

The things I go over in this section took a lot of trial and error. The first time I created a Google Sheets Add-on I was flabbergasted that it just didn't work like a Google Sheets Add-on. Until I did all the things I go over in this section.
 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.
 MAKE Your Google Sheets Add-on DISCOVERABLE

MAKE Your Google Sheets Add-on DISCOVERABLE

In this section of our Add-on course we'll get out of sheets for a bit and create marketing materials. I'll show you the templates I use to make websites very quickly. hint: It's CARRD!
I'll also show you how quickly I make the banner and logo. You might be as quick if you have your own company logo or you already have something made.
 MAKE Your Google Sheets Add-on MARKETABLE

MAKE Your Google Sheets Add-on MARKETABLE

In this section we'll put our marketing materials to the test. We'll go through the ENTIRE process of asking for approval, getting rejected, and overcoming rejection to ultimately publish our Google Sheets Add-on to the world!
 Check Your Google Sheets Add On Works

Check Your Google Sheets Add On Works

In this lesson we'll check if the add-on actually works and record a client ID video. A weird little thing that I've now done a few times so can hopefully show you how to easily do it without getting frustrated.
 How to Replace Text with a Blank Cell in Google Sheets

How to Replace Text with a Blank Cell in Google Sheets

Learn the Quick Fix! Replace Text with Blank Cell in Google Sheets Hassle-Free. Say Goodbye to Data Glitches. Super helpful when you need to find and replace in google sheets any text.
Beginner
Creating a Live Message in Google Sheets

Creating a Live Message in Google Sheets

Sit back and enjoy this comprehensive tutorial on how to create a live message in Google Sheets. In this video, we dive deep into the process of live message creation, providing step-by-step instructions and practical examples. Whether you're a beginner or an experienced user, this tutorial will empower you to unleash the full potential of Google Sheets.
Intermediate
The First Thing I Do When Starting a Google Sheet

The First Thing I Do When Starting a Google Sheet

Are you tired of the default look of your Google Sheets? In this video, I'll show you the ultimate way to revitalize your workspace and enhance your productivity. By changing the background and text color in Google Sheets, you can create a more personalized and visually appealing environment that suits your preferences. Join me as I guide you through the simple steps to achieve a vibrant and eye-friendly spreadsheet experience.

Get Sheet Styles here: https://sheet-styles.bettersheets.co/
Beginner
Shaman: AI Blog Writer

Shaman: AI Blog Writer

I will introduce you to the power of AI writing in Google Sheets using a tool called Shaman. If you're a blogger looking to take your writing to the next level, this is the video for you. With Shaman, you can unleash your blogging potential by incorporating AI into your writing process.
Intermediate
How to Power Testimonials with Google Forms and Sheets

How to Power Testimonials with Google Forms and Sheets

I show you how I use a Google Form and a Google Sheet to power the testimonials page on BetterSheets. I walk you through the process of collecting testimonials, approving them, and displaying them on the website. I also explain how I implemented the functionality using Apps Script. If you're interested in learning about spreadsheet automation and how to leverage Google Forms and Sheets for your own projects, this video is for you!

And Spreadsheet Automation 101 is a great way to learn most of what I go over in this video.
Advanced
FILTER() IFNA()

Displaying items 101-120 of 244 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