Better Sheets

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

Weekly Email Sheet as Lead Magnet

Create a fun freebie for selling spreadsheets

VAR vs CONST vs CONSTANT in Apps Script

Level up your variable assignments in this quick video on why there is Var or Const, or a Constant.

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

Advanced Intermediate

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

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

SUM() FILTER() IFNA()

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

Introducing SheetFools

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

Intermediate

Create a Tracking Number Fetcher with Google Sheets and Google Sites

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

Advanced

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.

Advanced

SubSpyHub Subreddit Scanner

I built a subreddit search tool to keep track of subreddits with keywords and interesting conversations.

Intermediate

ISBLANK() IF() HYPERLINK() SUBSTITUTE()

Create Navigation Buttons in Sheets to Other Sheets

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

Intermediate

Upgrade Your Add-on to V8 Runtime Explained

How to and why to upgrade from V5 Rhino to V8 Runtime in Add-ons

Advanced

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.

Advanced

CRM Automations

Simple automations you can add you to your CRM to keep it clean and looking great.

Intermediate

IF() ISBLANK() WORKDAY() DATEDIF()

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

Advanced

Close Form After Certain Number of Responses

Create automatic triggers that close a form after a certain number of responses.

Intermediate

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

Automate Help Desk Ticket Closing

Create a simple automated help desk ticketing system.

Create tickets
Closed dropdown
Calculate time to close
Create dashboard

Advanced

IF() COUNTA() COUNTIF() FILTER() AVERAGE()

How To Change Date Format Automatically

Create automations to change date format based on the format you want, inside your sheet.

Advanced

Make AI-generated Poems Based on Name

Create simple poems based on someone's name with AI.
AI Apps Script Code here: https://bettersheets.co/snippets/updated-open-ai-model-to-omni

Intermediate

Displaying items 21-40 of 635 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

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons