Sign up for a FREE TRIAL to access this course today.


44 Tutorials

You find yourself doing rote tasks. Again and again, day after day. While designing better sheets makes your life in the sheets better. There’s far more life outside the sheets. Here are the videos that help you record simple tasks and repeat them without fail.

Are you tired of doing the same repetitive tasks in Google Sheets day after day? Do you wish you had more time to focus on the bigger picture instead of being bogged down by mundane data entry and formatting? Well, the solution to your problem is simple – automate your Google Sheets workflow! In this article, we will explore the benefits of automating your Google Sheets and provide you with tips and tricks on how to do so efficiently.

What is Google Sheets?

Google Sheets is a cloud-based spreadsheet software that allows users to create and edit spreadsheets online while collaborating with others in real-time. It is a free alternative to Microsoft Excel and offers many of the same functionalities, such as formulas, charts, and pivot tables. With Google Sheets, you can easily organize and analyze your data, making it an essential tool for businesses, students, and professionals alike.

Automating Google Sheets

As mentioned earlier, automating your Google Sheets can help you save time and reduce errors by streamlining your workflows. By automating your Sheets, you can eliminate the need for repetitive data entry, formatting, and calculations. Here are some ways to automate your Sheets:

Macros are a series of actions that you can record and replay in Google Sheets. They allow you to automate tasks such as formatting cells, copying and pasting data, and running calculations. Macros are an excellent way to save time and reduce errors, especially if you perform the same tasks repeatedly.

Google Apps Script
Google Apps Script is a scripting language that allows you to extend the functionality of Google Sheets. With Apps Script, you can create custom functions, automate tasks, and even build web applications that integrate with Google Sheets. Apps Script is an advanced tool that requires some coding knowledge, but it is a powerful way to automate your Sheets.

Triggers are a powerful tool in Google Sheets that allow you to automate repetitive tasks by setting up scripts to run automatically under specific conditions. In essence, triggers work like cron jobs but within Google Apps Scripts, allowing you to start scripts automatically in response to specific events or at designated times.

Types of Triggers

There are two types of triggers that you can set up in Google Sheets: event-based triggers and time-based triggers.

Event Based Triggers
Event-based triggers are triggered by specific events that occur in your Google Sheet, such as a change to a cell, a new row being added, or a form being submitted. You can set up an event-based trigger to run a script automatically when one of these events occurs, allowing you to automate tasks such as data entry or updating calculations.

Time Based Triggers
Time-based triggers are triggered based on a specific time or interval, such as every hour, every day, or every week. You can set up time-based triggers to run a script automatically at the designated time or interval, allowing you to automate tasks such as sending reminder emails or generating reports.

Find out about all the triggers available in Google Sheets, here on Better Sheets.

Add-ons are third-party tools that you can install in Google Sheets to add new features and automate tasks. There are many add-ons available for Google Sheets, ranging from simple data formatting tools to advanced data analysis and visualization tools. Add-ons can help you save time and improve your productivity by automating repetitive tasks and simplifying complex workflows.
I've created Free Google Sheet Add-ons. You can find them here.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you. 

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At, I have everything you need to take your Google Sheets skills to the next level. 
From ARRAYFORMULA() to ZTEST(), Better Sheets has it all. 

At, I have everything you need to take your Google Sheets skills to the next level. 
From ABS() to ZTEST(), Better Sheets has it all. 


Write an apps script to delete lines easily.
Sit back and enjoy this comprehensive tutorial on how to create a live message in Google Sheets. In this video, we dive deep into the process of live message creation, providing step-by-step instructions and practical examples. Whether you're a beginner or an experienced user, this tutorial will empower you to unleash the full potential of Google Sheets.
I'll show you how to set up a super powered checklist that can act like a micro manager. It emails you hourly with the top unchecked item on your To-Do list.
A short 10 minute video to get you started with Apps Script. Showing you menu: Extensions > Apps Script. And shows off how to write a function, do some math, manipulate some text. Members can get Spreadsheet Automation 101 in
I will guide you through the process of creating an onboarding scheduler using Google Sheets and Google Apps Script.

We will automate the sending of emails and granting access to documents based on a schedule.

I will walk you through the script code step by step. By the end of the video, you will have a functional onboarding system that can send checklists and standard operating procedures (SOPS).
Create a sequence of numbers that magically appears as you type in each row. Put this in A1 and start typing in column B: =SEQUENCE(COUNTA(B:B),1,1,1)
If you type the letters of PRIDE in the first 5 columns in the first row of your sheets they'll turn the color of the pride flag. If you want to create your own easter egg in sheets then follow along this step-by-step tutorial as I show you how.

This might be better than Conditional Formatting! We're using the onEdit() simple trigger in Apps Script..
Learn how to email yourself a cell from a Google sheet every day in just a few simple steps! This powerful technique will change the way you manage your data. Follow along and get ready to be amazed! 

Learn to automate an email, with data, from a sheet.
Introductng a new tool from Better Sheets. A free Google Sheets™️ Add-On to parse spin syntax content.

Revolutionize Your Google Sheets writing with Spin Tax Content Spinner! Say Goodbye to Tedious Editing. Get All the Variations You Need. 

  • Spin randomly to get one variation
  • Spin text for all variations
  • Spin text for all variations including duplicates

Spintax is written with pipes separating content you want to randomly select. {Hi|Hello|Hey} would either be Hi, or Hello, or Hey.
I start off this video with the idea to show beginners how to automate emails in their sheets, and also add a little bit of AI. Then half way through the video I have a question... can I write AI and then email myself everyday? We try to do that. So you get to see me struggle, and log, and debug. It's quite intense.

Learn more Automation:

Get the AI GPT-3.5 and GPT 4 code:

Better Sheets members can get the code and the sheet in the video below.
Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
Find out How to Optimize your Apps Script functions. Learn the trade offs between flexibility, edit-ability, and protection. Different cell references allow you to do more with your apps script.

In the context of the video we're talking about an AI prompt and how I used different Cell References when writing different Apps Script functions. I'll show you why I chose those syntaxes and why you might choose different ones.

This video is more about Apps Script than writing Prompts but can help you create better web apps inside of Google Sheet, utilizing the best of Apps Script and creating your own custom functions.
Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".
I'll show you how to create a visual clock in your Google Sheet using conditional formatting. 

By following a few simple steps, you'll be able to see the progress of each hour throughout the day. 

No manual updates required! I'll guide you through setting up the custom formula, applying it to the desired range, and making it work for multiple columns if needed. 

Plus, I'll share a tip on how to reverse the colors if you prefer to track the remaining time instead. 

Let's get started and make your Google Sheet even more efficient! 
Add labels to gmail emails you get from email addresses you put in a Google Sheet list. Great for tagging members, subscribers, users, when you want to prioritize them in your Gmail. Great to see a function laid out that interacts with Gmail inside of Google Sheets Apps Script.
extending Google Sheets in a really fun way. We're gonna be sending emails. I have had literally two people in the past week and a half ask me for this and I answered their question very specifically, but I wanna generally reach out to everyone here, give everyone the opportunity to learn this.
Access the OpenAI API, walkthrough of the way we engineer the Apps Script so that we can play around with temperature and token length. Walk through UrlFectchApp as well and parsing JSON.
Member Richard asks this question. Answer: use Google Script and a Trigger.
Created a daily email with a motivational quote in the subject.
A raw, 1 shot take of figuring out how to automatically delete all sheets not named on a whitelist of sheet names. Using the on Change Installable trigger. This video was tough to make!
Learn to set text wrap, overflow, or clip. Great for designing better text in your sheets.
welcome to the technical walkthrough of VisiCalc 2023. This is the sheet that I released on April 1st for April Fool's Day. Learn how to use the onEdit() function in Apps Script. We learn the Apps Script for: Save a Sheet , Active Cell coloring, and the Out of Memory Toast.
I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.
Editing macros in Google Sheets helps you do more in less time.
we're going to be adding a very powerful script to our CRMs or any database in which you need to move rows between tabs.
Create a Log sheet in Google Sheets
Find out how to automatically delete rows based on a cell's value. We do this in Apps Script
Learn to code in sheets. Automate Your Daily Sales Report with Google Sheets: Learn how to create a script that copies data from one sheet to another, including timestamps. Boost your productivity with this easy guide!
Now that we have a script that we wanna run every day, how do we run this? This is a key part of programming. It's like Cron Jobs in Apps Script
Embed a little HTML into your site to capture Emails straight to a Google Sheet. I've written the apps script and the html and the javascript for you. As easy as copy and pasting. Use my referral link if you choose to use Carrd for this:
Discover how to Save Your Sheets Every Week Automatically
Get this epic script that automatically edits two tabs and keeps them in sync.
Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.
Automate your apps script and macros you can record.
One of the most requested videos, Ever. How to put data, a number, some text, from a Google Sheets onto a website without having to embed the entire Google Sheet. This is the way!
generate random numbers using Google Sheets. Fun ways to figure out how to get random characters. Great to use for creating IDs or Coupon Codes. Nice easy intro to some simple apps script.
Get floor prices into your spreadsheet with URLFETCHAPP. Accessing OpenSea's API directly from google sheets. Get any data you want. from Market Cap to One Hour Volume
Record a macro, to Insert a column every day.
this completes learn to code in Google Sheets and I wanted to finish off by giving you a few more quick concepts that expands your mind of what Google Sheets can do.
Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script
This is one of the most popular asked first "automations". How to move a row of data based on a single criteria in a column. Great for sales teams and maintaining a CRM.
Let’s talk about the IF formula and the differences. Learn how to insert a checkbox and all the other things it can do for you.
Learn how to track every change in your Google Sheets with a simple custom function in this video on "What Changed." Discover how to compare sentences, paragraphs, and more with ease. Follow along as we create the function from scratch. Get ready to streamline your editing process!

We code a little apps script to figure out the difference between two cells.

Start a FREE TRIAL today to access this course.