TRY ME!
→ Random Tutorial

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

Ultimate Headline Writer with GPT in SHEETS

Ultimate Headline Writer with GPT in SHEETS

Create the Ultimate Headline Writer: Unleash the Power of Google Sheets and OpenAI's API / GPT-3.5-Turbor to Create Compelling Website Headlines. Write in different styles, using different parameters to make the ultimate headline writer for an agency or for your own business.
Advanced
IF() ISBLANK()
Why Different Cell References in AI Integration in Sheets?

Why Different Cell References in AI Integration in Sheets?

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.
Advanced
Create a ChatGPT Cheat Sheet Spreadsheet

Create a ChatGPT Cheat Sheet Spreadsheet

Walk through step-by-step going from a blank sheet to an AI powered prompt engineering cheat sheet of a spreadsheet.

Watch the Upgrade to GPT-4 video to see the differences between GPT-3 and GPT-4 Apps Script

Intermediate
CONCATENATE() COUNTIF() IF() ISBLANK() LEN() +2 more
Create Your Own Pride Flag Easter Egg in Sheets

Create Your Own Pride Flag Easter Egg in Sheets

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..
Conditional Formatting Advanced
Connect to a Google Cloud Project

Connect to a Google Cloud Project

This part can be very confusing. So I show you step-by-step how to do it.
 Find a Value in a Range

Find a Value in a Range

I'll show you how to easily find a specific value in a range using two powerful formulas: VLOOKUP and INDEX MATCH. 

With VLOOKUP, we can search for a value in a column and retrieve information from the same row. 

I'll explain how to set it up and why the "false" parameter is important. Then, I'll introduce INDEX MATCH, which allows us to search for a value in one column and retrieve information from another column.

 I'll demonstrate how to use it to find a name based on a number and vice versa. This technique is incredibly useful when you need to look up information based on a specific value. 

Plus, I'll share a neat trick to make the search even more dynamic. So, let's dive in and master these versatile formulas together! 🚀
Beginner
INDEX() MATCH() VLOOKUP()
Twitter Sort Tool

Twitter Sort Tool

I'll show you how I created a Twitter tool sort to organize my list of every tool I use to run better sheets.
Paste a list into Sheets and using a simple formula, I was able to determine the length of each item.

Then, I sorted the list in ascending order based on the length column. I even experimented with sorting it in descending order too!

Finally, I deleted the original list and pasted the sorted one using the "paste values" option. It's all done and ready to be shared. Check it out and let me know what you think! Don't forget to tweet about it if you find it helpful. Enjoy

Beginner
LEN() SORT()
How to Create a Google Form Automatically

How to Create a Google Form Automatically

How to create a form programmatically using Google Apps Script. I show you step-by-step how to create a form, set the title, add text items, and set the destination of the form to a specific sheet. This tutorial is perfect for anyone who wants to automate the process of creating forms, whether it's for templates, lead magnets, or recurring forms. No prior coding experience is required.
Intermediate
Set up Stripe with Only Sheets

Set up Stripe with Only Sheets

I will guide you through the process of setting up Stripe with Only Sheets. I will show you how to make a copy of Only Sheets in your Google Drive, configure the necessary settings in Stripe, and deploy a web app.

Additionally, I will explain how to create a payment link in Stripe and set up webhooks.

Finally, I will demonstrate how to revoke access to the sheet and answer any questions you may have. Please make sure to follow along and take notes as needed.

Watch the 1st set up video: https://bettersheets.co/tutorials/announcing-onlysheets-2-0

Intermediate
SECTION 1 - You Are The Sheet

SECTION 1 - You Are The Sheet

Selling Spreadsheets Section 1: You are the Sheet Introduction

Over the course of this section of selling spreadsheets, I'm going to share with you some theories that I have of how to bring your entire self into the world. To the spreadsheet that you're selling. Not just the idea, and not just the sheet itself, and not just your time, not just your energy, not just your experience, but everything holistically.
 Easiest Sheet Ever to Sell

Easiest Sheet Ever to Sell

You Must Double Duplicate (If you're selling a sheet you use)

You Must Double Duplicate (If you're selling a sheet you use)

How to turn a spreadsheet in your Google Drive into a sellable product. Step-by-step, I will show you exactly how I do it. If you're selling a sheet you use, then you must do this!
Beginner
Activate A Certain Sheet When Opening a Spreadsheet

Activate A Certain Sheet When Opening a Spreadsheet

Create a short function that runs every time a spreadsheet file is open. Redirects the user to the START tab. You can use this to direct anyone opening your file to a specific tab you want them to start on.
Intermediate
Lock Your Sheets with OnlySheets

Lock Your Sheets with OnlySheets

Understand what you can do, if you use OnlySheets between your payment processor and the buyer.
Intermediate
Weird Idea: Find a Great Sheet Domain Name

Weird Idea: Find a Great Sheet Domain Name

Find a domain to get sheet ideas.
Intermediate
Vertically Stack and Sort Data

Vertically Stack and Sort Data

It's a common problem: combining two lists of scores to identify top performers using Google Sheets. We demonstrate how to sort data from two different ranges using the VSTACK function and also using curly brackets. Learn the step-by-step process to create a single, vertically stacked dataset that can be sorted effectively.
Beginner
SORT()
Send Better Email When Google Form Filled Out

Send Better Email When Google Form Filled Out

Find out how to email all the form entries each time your form is filled out.
Intermediate
Every Google Drive File Created in Last 24 Hours

Every Google Drive File Created in Last 24 Hours

Create a simple report in a Google Sheet that documents every file in your Google Drive that was created in the last 24 hours.
Intermediate
Add NPS to Your Google Site

Add NPS to Your Google Site

Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.
Intermediate
AVERAGE()
Better Email Form on Google Sites

Better Email Form on Google Sites

Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.
Advanced Intermediate

Displaying items 201-220 of 318 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