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

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.
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.
Scrape Google Maps

Scrape Google Maps

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.
Send a Button from Google Sheets in an Email

Send a Button from Google Sheets in an Email

quick fun video to show you how to add a button to emails when you send emails from Google Sheets.
How To Download All Tabs as CSV in a Zip File

How To Download All Tabs as CSV in a Zip File

Download All Tabs as CSV in a Zip File, instead of downloading each one by hand, one by one.  This apps script is super awesome to implement for those sheets you need a zip file of all the Tabs.
Take Screenshots from URLs in Google Sheets

Take Screenshots from URLs in Google Sheets

Use Screenshot One api to quickly get cached images of Screenshots and then go and download them. Check this out and let me know how you'd use it.
IMAGE()
SheetLord Update: duplicate tab and automatically add Search Term

SheetLord Update: duplicate tab and automatically add Search Term

Updated SheetLord with a new function.
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.
ENCODEURL() FILTER() IFNA() SUBSTITUTE()
Launching SheetOps The Business Operations Task Manager

Launching SheetOps The Business Operations Task Manager

Jump in and watch this quick run through of what is SheetOps. It's not just an automated task list, it's a business operations command center. Command the chaos! Get it at https://BetterSheets.co/tools/sheetops
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.
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.
FILTER() IFNA() SUM()
Introducing SheetFools

Introducing SheetFools

Free google sheets automations pranks you can use right now. Launching publicly April 1st, 2025.
SubSpyHub Subreddit Scanner

SubSpyHub Subreddit Scanner

I built a subreddit search tool to keep track of subreddits with keywords and interesting conversations.
HYPERLINK() IF() ISBLANK() SUBSTITUTE()
Create Navigation Buttons in Sheets to Other Sheets

Create Navigation Buttons in Sheets to Other Sheets

Add a button to go to another sheet inside your sheet.
CRM Automations

CRM Automations

Simple automations you can add you to your CRM to keep it clean and looking great.
DATEDIF() IF() ISBLANK() WORKDAY()
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.
Make AI-generated Poems Based on Name

Make AI-generated Poems Based on Name

Simple Inventory Management Automations

Simple Inventory Management Automations

Create a few simple automations like email notifications and low stock alerts.
IF() ISBLANK()
How to Create AI Images From Google Sheets

How to Create AI Images From Google Sheets

Use the Open AI API and Dall-e-3 to create image in Sheets

Displaying items 1-20 of 180 in total