TRY ME!
→ Random Tutorial

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

Combine Filters in One Column

Combine Filters in One Column

Using the ampersand and ARRAYFORMULA to combine two filters into a single column.
Beginner
ARRAYFORMULA() FILTER()
Pick a Raffle Winner with Number of Tickets

Pick a Raffle Winner with Number of Tickets

Pick a raffle winner if you only have the names and number of tickets. And do it in one cell.
Advanced
ARRAYFORMULA() IF() INDEX() JOIN() RANDBETWEEN() +3 more
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
Email Certain Department Based on Google Form Entries

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.
Advanced
Upgrade Your Add-on to V8 Runtime Explained

Upgrade Your Add-on to V8 Runtime Explained

How to and why to upgrade from V5 Rhino to V8 Runtime in Add-ons
Advanced
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
Expense Tracker Template with Data Entry Form Inside Sheets

Expense Tracker Template with Data Entry Form Inside Sheets

Create a data entry form for an expense tracker. Simple dashboard too with sum and sum between two dates.
Intermediate
FILTER() IFNA() SUM()
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()
SheetLord Update: duplicate tab and automatically add Search Term

SheetLord Update: duplicate tab and automatically add Search Term

Updated SheetLord with a new function.
Intermediate
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. 
 Enter Google Drive File Name Get URL

Enter Google Drive File Name Get URL

Create a simple automation with an installable trigger that allows you to enter the Google Drive file name and get the URL inside your Google Sheet.
Intermediate
Scrape Google Maps

Scrape Google Maps

Intermediate
Scrape Google Maps Added Phone and Reviews

Scrape Google Maps Added Phone and Reviews

Added two helper functions to get Phone numbers and reviews of the Google Maps Results.
 Tweet From a Sheet

Tweet From a Sheet

See how to tweet from a sheet and get the code below.
 Google Maps Scraper for Outreach

Google Maps Scraper for Outreach

Get this fun template to search on google maps via API, and quickly message via Whatsapp.  Then Manage the outreach.
Intermediate
Better Sheets Members Tour March 2026

Better Sheets Members Tour March 2026

Walk through what's available in Better Sheets. For beginners and advanced users alike.
Advanced Intermediate Beginner
Create an Email Campaign Stats Calculator

Create an Email Campaign Stats Calculator

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.
Advanced
CONCATENATE() ROUNDDOWN() UPPER()

Displaying items 261-280 of 357 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