TRY ME!
→ Random Tutorial

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

Frustrated With Sheets New Dropdown Pills?

Frustrated With Sheets New Dropdown Pills?

3 options to show dropdowns. It looks actually much closer to Airtable, but some people don't want this some sheets sort of fanatics, enthusiasts, people who love Google Sheets and don't really want to look.
Intermediate
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
NEW TOOL Parse Spintax for Content Spinning

NEW TOOL Parse Spintax for Content Spinning

Introductng a new tool from Better Sheets. A free Google Sheets™️ Add-On to parse spin syntax content.

Revolutionize Your Google Sheets writing with Spin Tax Content Spinner! Say Goodbye to Tedious Editing. Get All the Variations You Need. 

  • Spin randomly to get one variation
  • Spin text for all variations
  • Spin text for all variations including duplicates

Spintax is written with pipes separating content you want to randomly select. {Hi|Hello|Hey} would either be Hi, or Hello, or Hey.
SUBSTITUTE()
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
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-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. 
 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
Spreadsheet Automation for Beginners

Spreadsheet Automation for Beginners

I start off this video with the idea to show beginners how to automate emails in their sheets, and also add a little bit of AI. Then half way through the video I have a question... can I write AI and then email myself everyday? We try to do that. So you get to see me struggle, and log, and debug. It's quite intense.


Learn more Automation: https://bettersheets.co/courses/spreadsheet-automation-101

Get the AI GPT-3.5 and GPT 4 code: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4

Better Sheets members can get the code and the sheet in the video below.
Beginner
INDEX() SPLIT()
10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a list of 10 things you can do today to make your sheets more lovable.

The 10 Things I Hate about your Sheets
  1. Squeezed Rows
  2. Garbage Data
  3. Looks The Same
  4. Crazy Column Width
  5. Where’s Waldo 
  6. Of Results
  7. Too Many Clicks
  8. Instructions Unclear
  9. Eye Strain and Headaches
  10. Lazy Conditional Formatting
  11. Too Many Cells
Conditional Formatting Data validation Beginner
IF() ISBLANK() ISEMAIL() ISURL()
Creating a Random Motivational Quote Checklist

Creating a Random Motivational Quote Checklist

I'll show you how to create a motivational quote checklist that generates a random quote every time you check off a task. We'll start from scratch and create a formula that displays motivational quotes from a list of 100 quotes. The quotes can be easily expanded, and the checklist will update accordingly. This tool will add a touch of motivation and productivity to your day. Enjoy!
Beginner
COUNTA() INDEX() RANDBETWEEN()
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
Create Your Own API by Deploying a Web App

Create Your Own API by Deploying a Web App

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.
Advanced
IMAGE()
I Created an Advent Calendar

I Created an Advent Calendar

Just in time for the holidays. Great for making promotion calendars to reveal promotions day to day.
Beginner
IMPORTRANGE()
Maximize Spreadsheet Sales to Startups

Maximize Spreadsheet Sales to Startups

A Review of Gary's AARRR Tracker and Landing Page Strategies that you can employ if you're selling templates, spreadsheets, and google sheets to Startups.

Explore how to enhance a spreadsheet landing page's appeal and effectiveness. Discover innovative strategies for crafting compelling landing pages, learn the art of selling solutions (not just spreadsheets), and get tips on leveraging Google Sheets to create digital products that truly resonate with your audience. 

Whether you're a seasoned spreadsheet seller or just starting out, this video is packed with actionable advice to elevate your sales game. Tune in and transform your spreadsheet into a sellable sensation.

3 Key Takeaways
  • Market spreadsheets as problem-solving solutions, not just as templates or tools.
  • Design landing pages that tell a compelling story and focus on the benefits and solutions offered by the spreadsheet.
  • Utilize Google Sheets' advanced features and automations to enhance functionality and add value to your spreadsheet product.

If you want to automate your spreadsheets more, take the course: Spreadsheet Automation 101.
Intermediate
Selling Spreadsheets Course Introduction

Selling Spreadsheets Course Introduction

Let's go sell great spreadsheet products.
 Explore Your Spreadsheet Selling Options

Explore Your Spreadsheet Selling Options

- Template
- Custom Formulas
- Custom Functions - Apps Script
- Google Sheet Add-ons
 Surprising Things about Selling Spreadsheets

Surprising Things about Selling Spreadsheets

A few things that surprised me when I started selling sheets. From landing page copy that converts, to what people want to know after they buy.
- Adding videos to onboard helps immensely.
- Landing page copy should agitate, not solve everything.
- Sheets aren’t sold, they’re bought.
- Selling a great sheet is selling a great process.
- You can Launch, again and again… seemingly forever.
 SECTION 2 - Your Spreadsheet Blueprint

SECTION 2 - Your Spreadsheet Blueprint

Figure out the framework to consistently come up with spreadsheet-able ideas and make them super easy to execute from your laptop.
 The #1 Mistake Spreadsheet Sellers Make and how to Save People Time

The #1 Mistake Spreadsheet Sellers Make and how to Save People Time

Scope down from an existing problem to a sheet that still solves a juicy problem. If you can solve something in 10x less time, you win. Find out how lack of specificity is the #1 mistake. I’ll share with you a quick way to figure out if you’re really saving people time.

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