TRY ME!
→ Random Tutorial

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

Create a new Spreadsheet from just a Name in a Sheet.

Create a new Spreadsheet from just a Name in a Sheet.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.
Advanced
Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

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
Advanced
Create a Stop Watch in a Google Sheet

Create a Stop Watch in a Google Sheet

We'll create a stop watch from scratch. Including Apps Script. What it will do is when you click a button (a checkbox) in a sheet, the script on every edit will add a start or a stop time, then add another time and calculate the duration.
Create an Email Campaign Stats Calculator

Create an Email Campaign Stats Calculator

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.
Advanced
CONCATENATE() ROUNDDOWN() UPPER()
How to Trigger Macros Daily

How to Trigger Macros Daily

Automate your apps script and macros you can record.
Advanced
TODAY()
Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

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.

Advanced
Richard Asks: Copy Template Tab and Rename to Date Every Week

Richard Asks: Copy Template Tab and Rename to Date Every Week

Member Richard asks this question. Answer: use Google Script and a Trigger.
Create a CPM Custom Function (Create Better Calculators!)

Create a CPM Custom Function (Create Better Calculators!)

this is gonna be fun because we get to create a calculator with Apps Script.
Beginner
Password Protecting Data In a Google Sheet

Password Protecting Data In a Google Sheet

A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding
Advanced
IF() IMPORTRANGE()
How to Write a Function - Learn to Code in Google Sheets Part 2

How to Write a Function - Learn to Code in Google Sheets Part 2

Continuing to show you how to write a function in Apps Script.
Beginner
Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Find out how to automatically delete rows based on a cell's value. We do this in Apps Script
Advanced
Spreadsheet Automation 101: Introduction to Pre-course Videos

Spreadsheet Automation 101: Introduction to Pre-course Videos

Learn how to automate spreadsheets with Apps Script. The pre-course videos equip you with the fundamentals of coding before you start.
 Spreadsheet Automation 101: Functions

Spreadsheet Automation 101: Functions

Get introduced to Apps Script functions and functions syntax. Learn how to write new functions, how to name functions and call functions from your sheet.
 Spreadsheet Automation 101 Lesson 2: Get Values - Introduction

Spreadsheet Automation 101 Lesson 2: Get Values - Introduction

Get Values is done in the Apps Script. In this lesson, you’ll learn what changing .getValue() to .getValues() do. You’ll also learn about Logger and For Loop, which I mention here briefly.
Spreadsheet Automation 101 Lesson 2: Arrays

Spreadsheet Automation 101 Lesson 2: Arrays

Learn the basics of Arrays – how to create one, how to reference rows and columns of data in a different way, and how to get an entire column or row in Apps Script.
Spreadsheet Automation 101 Lesson 3: Email Other People For Loop

Spreadsheet Automation 101 Lesson 3: Email Other People For Loop

Send the same email to different people by using the same Four Loop to figure out which ones we’re sending. Do cool things with this Mail App and email system.
Tag Emails From A List of Members in Google Sheets

Tag Emails From A List of Members in Google Sheets

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.
Advanced
ChatGPT Clone in Google Sheets Part 1

ChatGPT Clone in Google Sheets Part 1

In this tutorial, learn how to create a ChatGPT-like interface using Google Sheets and Apps Script. Record your questions and get answers from OpenAI's GPT-3 API. Follow this step-by-step guide to build your own interactive GPT-3 interface.

  • Style a sheet like ChatGPT. Use the correct colors and interface design.
  • Add new rows to record the questions/prompts.
  • Add rows for the responses, and answers we get from OpenAI API.
 Building an AI Prompts Playground

Building an AI Prompts Playground

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.
Advanced
Solve The Errors, Learn For Loop

Solve The Errors, Learn For Loop

Learn how to debug a For Loop. These are common errors that happen when coding in Apps Script, specifically around the For Loop. This is Part 1 and 2. Get the goal of capture the flag exercise and I give you hints to each one.
Advanced Intermediate

Displaying items 61-80 of 144 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