TRY ME!
→ Random Tutorial

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

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.
 Easiest Sheet Ever to Sell

Easiest Sheet Ever to Sell

You Must Double Duplicate (If you're selling a sheet you use)

You Must Double Duplicate (If you're selling a sheet you use)

How to turn a spreadsheet in your Google Drive into a sellable product. Step-by-step, I will show you exactly how I do it. If you're selling a sheet you use, then you must do this!
Beginner
Activate A Certain Sheet When Opening a Spreadsheet

Activate A Certain Sheet When Opening a Spreadsheet

Create a short function that runs every time a spreadsheet file is open. Redirects the user to the START tab. You can use this to direct anyone opening your file to a specific tab you want them to start on.
Intermediate
Lock Your Sheets with OnlySheets

Lock Your Sheets with OnlySheets

Understand what you can do, if you use OnlySheets between your payment processor and the buyer.
Intermediate
Weird Idea: Find a Great Sheet Domain Name

Weird Idea: Find a Great Sheet Domain Name

Find a domain to get sheet ideas.
Intermediate
Every Google Drive File Created in Last 24 Hours

Every Google Drive File Created in Last 24 Hours

Create a simple report in a Google Sheet that documents every file in your Google Drive that was created in the last 24 hours.
Intermediate
Add NPS to Your Google Site

Add NPS to Your Google Site

Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.
Intermediate
AVERAGE()
Can I Automatically Rename a Sheet based on a Date?

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.
Intermediate
DAY() MONTH() TODAY() YEAR()
How To Get Someone to look at a Cell in Your Sheet

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in your sheet.
Beginner
Automate Form Response to Confirmation Email

Automate Form Response to Confirmation Email

Create an email automatically when someone fills out a google form. include a url that has a clickable confirmation link and a unique id.
Advanced
Close Form After Certain Number of Responses

Close Form After Certain Number of Responses

Create automatic triggers that close a form after a certain number of responses.
Intermediate
Make a Tour of Your Sheet

Make a Tour of Your Sheet

create a tour of your sheet for users who might be using your sheet and need to know what to do on each tab.
Advanced
Weekly Email Sheet as Lead Magnet

Weekly Email Sheet as Lead Magnet

Create a fun freebie for selling spreadsheets
 SearchLord: One Sheet to Search Them All

SearchLord: One Sheet to Search Them All

I created a new product called SearchLord. It's free for now and really fun to search multiple sites with 1 key word, or 1 phrase. Free for everyone at bettersheets.co/sheetlord

In this video I add 1 more feature to SearchLord to show you how to use a FILTER() function. And we add a custom menu with a little quick apps script function.
Intermediate Beginner
ENCODEURL() FILTER() IFNA() SUBSTITUTE()
Creating a Custom URL Link for Your Spreadsheet

Creating a Custom URL Link for Your Spreadsheet

Create an apps script function that gets the url of your spreadsheet into a cell.
CONCAT() HYPERLINK()
Generate Google Search Phrases

Generate Google Search Phrases

Create a lot of search phrases from one simple automation trick. Generates a lot of phrases without having to ask AI.
Beginner
How To Format Sheets for Notes

How To Format Sheets for Notes

Create sortable notes in Three ways. 
1. By adding the original word over and over again
2. Adding notes all in one cell with CMD + ENTER for new lines
3. Use Apps Script to sort the A column even with groups of rows.
 Get Every Editor on Every Google File I Own

Get Every Editor on Every Google File I Own

Get every editor if you're looking for the sheets and documents you've shared with other people and forgot them! Or just want to get a list of them into a Google Sheet. 
 Scrape Google Maps

Scrape Google Maps

Intermediate

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