TRY ME!
→ Random Tutorial

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

One Weird Google Sheet Formula for Bulk Publishing With AI

One Weird Google Sheet Formula for Bulk Publishing With AI

'll show you a game-changing Google Sheet formula that will make your day, especially if you're into bulk publishing and chat GPT. With this formula, you'll be able to insert lists of keywords into prompts effortlessly. I'll guide you step-by-step on how to set it up and use it effectively. Get ready to become faster, better, and more efficient in your publishing tasks. Let's dive in!
Intermediate
IF() ISBLANK() SUBSTITUTE()
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.
 Problems Everywhere, and the Spreadsheets that Solve Them

Problems Everywhere, and the Spreadsheets that Solve Them

In my video, I talk about how common problems are and how Google Sheets can help solve many of them in business. I discuss the different ways Google Sheets can be used, from simple to complex tasks, and plan to share five specific ways to use it effectively in future videos for better planning, tracking, and managing tasks.
 DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

Create dark mode with Conditional Formatting.
Conditional Formatting Beginner
Idea Graveyard - Create a Decaying Checklist

Idea Graveyard - Create a Decaying Checklist

Build a simple function that deletes undone items in our checklist.
Intermediate
Create Your Own NIGHT Mode (like PRIDE)

Create Your Own NIGHT Mode (like PRIDE)

Create easter eggs in your sheets.
Conditional Formatting Intermediate
AND()
How to Make Good Looking Spreadsheets

How to Make Good Looking Spreadsheets

Create nice colorful sheets (contrasting colors) that look and feel like an extension of your site. Add some padding around text. Decrease text and make your sheets awesome.
Intermediate
Create a Branded Lead Magnet from Qualitative Data

Create a Branded Lead Magnet from Qualitative Data

Find out how to turn some data you can copy/paste from the web into a branded lead magnet for yourself.

Check out Josh's Tweet about the sheet.
and check out his Podia.
 
The video shows the importance of adding personal touches to a Google Sheet to connect better with users. It explains how to analyze the sheet's data to find trends and best practices for website content. Lastly, it discusses ways to share the sheet widely while still giving credit to its creator.
Intermediate
AVERAGE() COUNTA() COUNTIF() FIND() HYPERLINK() +7 more
How do I prevent people from sharing my spreadsheets by making a copy?

How do I prevent people from sharing my spreadsheets by making a copy?

A video I did summarizing the 3 things you can do to help people who share your sheet, not do it, or at least get some value from it.

More info on the course: sellingspreadsheets.com

→ Get OnlySheets

Beginner
SECTION 3 - How to Make a Spreadsheet

SECTION 3 - How to Make a Spreadsheet

Crafting High-Demand Sheets from Scratch. Turn templates into tools to make sellable spreadsheets.
Intermediate
Build a Book Recommender with AI in Google Sheets

Build a Book Recommender with AI in Google Sheets

Create an Email form that sends a few books to AI and gets back a book recommendation. Build the backend in Google Sheets Apps Script while using Carrd to easily make an online form.
Advanced

Displaying items 81-100 of 188 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