TRY ME!
→ Random Tutorial

367 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()
You Should Know The Limitations of Data Validation

You Should Know The Limitations of Data Validation

You should know the difference between Data Validation and Data Veracity (or truthfulness of data)
This video points out some incredibly simple concepts of Data Validation you may want to use in your Google Sheets to make your data analysis better.
Intermediate Beginner
Add Columns Automatically

Add Columns Automatically

Create your own "Add Columns" button just like the add rows to the bottom.
Intermediate
How To Change Date Format Automatically

How To Change Date Format Automatically

Create automations to change date format based on the format you want, inside your sheet.
Advanced
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
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
I Created an Automatic Emailer

I Created an Automatic Emailer

While creating SheetOps, a new product, I came up with this idea of an automatic emailer that I can just enter an email and select a series of emails to send them. Needs an unsubscribe link. And so I made it in less than 45 minutes. Here it is. You can start using this right now for free if you're a member.
Advanced Intermediate
Weekly Email Sheet as Lead Magnet

Weekly Email Sheet as Lead Magnet

Create a fun freebie for selling spreadsheets
 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
Automatic Screenshots in Apps Script

Automatic Screenshots in Apps Script

Advanced
Build a Better ChatGPT Prompt Builder

Build a Better ChatGPT Prompt Builder

In this sheet review I take another YouTuber's ChatGPT prompt builder through the Better Sheets Sheet Makeover process. We make it more useful and more branded. Make it really look and feel cool to use. Saves users time. And makes them want to share it with others.
JOIN() SUBSTITUTE()

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