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

Automatic Screenshots in Apps Script

Automatic Screenshots in Apps Script

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.
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.
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.
Create a Tracking Number Fetcher with Google Sheets and Google Sites

Create a Tracking Number Fetcher with Google Sheets and Google Sites

Build a tracking number google site with Google Sheets as a backend.
Proof of Life

Proof of Life

Create a script that sends an email to ask for proof of life every month, or it will destroy the google sheet.
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
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.
Form Automations: Close Multiple Forms When Over Limit

Form Automations: Close Multiple Forms When Over Limit

Adding to the Form Automations:
Allow User to Reopen form without Apps Script access
Set Limit in a Sheet, not in Apps Script
Set Limits for different Forms
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.
Automate Help Desk Ticket Closing

Automate Help Desk Ticket Closing

Create a simple automated help desk ticketing system.
  • Create tickets
    Closed dropdown
  • Calculate time to close
    Create dashboard
IF() COUNTA() COUNTIF() FILTER() AVERAGE()
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.
Embed Email Form and Name Form into Website to Google Sheets

Embed Email Form and Name Form into Website to Google Sheets

Add names to the Email2Sheet apps script and code.
What Sucks About Selling Spreadsheets And How to Solve These Problems

What Sucks About Selling Spreadsheets And How to Solve These Problems

I go through a few of the darkest parts of selling spreadsheets and how you can fix them. I offer how to do updates that generate revenue and what marketplaces to sell on to avoid marketing into the void.
Add Tasks to Google Tasks From Google Sheets

Add Tasks to Google Tasks From Google Sheets

Create tasks in Google Tasks from Google Sheets using Apps Script
Built a Cookie Clicker Clone in Google Sheets

Built a Cookie Clicker Clone in Google Sheets

I built a clone of Cookie Clicker, live on YouTube. Watch the full 1 hour live stream here.

In this video I update it a bit, and show off that it works!! 

Learn how to build trigger builders and use user properties to store data you don't want a user to change (easily)
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.
INDEX() IF() REPT() ARRAYFORMULA() SPLIT() +3 more
Introducing Bigger Brain

Introducing Bigger Brain

10x your expertise driven content. Create new sections and fun additions to your own content. Make your writing more engaging and more educational.
Create New Worksheet When Google Form Submitted

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inserted into the new sheet.

Displaying items 1-20 of 106 in total