TRY ME!
→ Random Tutorial

339 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 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.
 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

How to Count Numbers in a Row

How to Count Numbers in a Row

Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.
Beginner
AND() COUNT() COUNTA() COUNTIF() FILTER() +1 more
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
Move Cells to New Row with Formula

Move Cells to New Row with Formula

Move a range, or a set of cells, to a new area with a simple formula that's just "curly brackets". Very easy and simple to use once you know it.
Beginner
Move Blank Rows

Move Blank Rows

Apps Script function to move all blank rows if a certain column is not filled in. Learn how to automate this script →Here
Intermediate
Automate Move Blank Rows

Automate Move Blank Rows

Intermediate
Count Merged Rows

Count Merged Rows

Count the number of cells or rows in a merged cell. This is a quick little code you can add to your sheets with the onOpen code.
Intermediate
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
Find Column with Header to Bullet Proof your Vlookup

Find Column with Header to Bullet Proof your Vlookup

Make your VLOOKUP formulas flexible and your data move-able with this trick.
Intermediate
HLOOKUP() MATCH() VLOOKUP()
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 221-240 of 339 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