TRY ME!
→ Random Tutorial

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

Build a Book Recommender with AI in Google Sheets

Build a Book Recommender with AI in Google Sheets

Create an Email form that sends a few books to AI and gets back a book recommendation. Build the backend in Google Sheets Apps Script while using Carrd to easily make an online form.
Advanced
How to Merge Cells in Google Sheets

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why.  Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.
Beginner
CONCATENATE() JOIN()
Quickly Integrate AI and Google Sheets

Quickly Integrate AI and Google Sheets

Intermediate
Saving OpenAI API Calls inside of Google Sheets

Saving OpenAI API Calls inside of Google Sheets

Copy text output and input into a google sheet from your OpenAI API calls. Great way to save AI text into a sheet or start to create your own AI writer, or even clone ChatGPT
Intermediate
Invoicing in Google Sheets for Freelancers

Invoicing in Google Sheets for Freelancers

Introduction to creating a filter so that you can bill for a certain time period of hours. Great sheet for Freelancers or Gig Workers.
Beginner
FILTER() IFNA() SUM()
Build Your Own AI Writer in Google Sheets

Build Your Own AI Writer in Google Sheets

Create your own AI writer with these google sheets tips and tricks and code.
Advanced
SUBSTITUTE()
Build Your Own PROPER() Custom Apps Script Function to Capitalize Each Word

Build Your Own PROPER() Custom Apps Script Function to Capitalize Each Word

There's something wrong with PROPER() the google sheets function. Let's fix it by customizing our own TitleCase() function inside of Apps Script.
Intermediate
PROPER()
Create an Internal Google Sheets Add-on

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internally to your own domain.
Intermediate
How do I reference a different spreadsheet in Apps Script?

How do I reference a different spreadsheet in Apps Script?

I'll show you how to get text from one spreadsheet file to another with Apps Script. Yes you can do this by Importrange() but you might want another way to do it.
Intermediate
IMPORTRANGE()
3 Free Tools to Make Your Google Sheets Better

3 Free Tools to Make Your Google Sheets Better

3 add-ons you can install right now and your Google Sheets life is better!
Tiny Sheets makes it simple to delete excess blank rows and columns.
Sheet Styles makes for less headaches and better text colors.
Button Styles makes awesome buttons for your users to click.
 How to Insert Multiple Rows in Google Sheets (Easy to Hard)

How to Insert Multiple Rows in Google Sheets (Easy to Hard)

Learn how to add multiple rows to your google sheets by hand, and automatically. 
Advanced Intermediate Beginner
Google Sheets Easter Eggs Beyond PRIDE

Google Sheets Easter Eggs Beyond PRIDE

Going beyond PRIDE, to show you some undocumented google sheets hacks that you might call "Easter Eggs"
Advanced Intermediate Beginner
Automated Project Management in Google Sheets

Automated Project Management in Google Sheets

Create automatic notifications when a project is assigned, a project needs review. And move a project from one tab to another tab.
Intermediate
Scoping Functions in Apps Script

Scoping Functions in Apps Script

Create multiple functions that run with the result of other functions.
Advanced
Perfect Use of AI in Google Sheets (Categorize Tasks)

Perfect Use of AI in Google Sheets (Categorize Tasks)

Explore how to use AI for task categorization in Google Sheets, from setting up the environment to using a pre-made code template. Watch as we walk through the process, from generating an API key to fine-tuning the prompt for effective categorization of work and home tasks.

Final code is available in the sheet below. And the original template code is available here:
https://bettersheets.co/snippets/updated-open-ai-model-to-omni
Intermediate
Breaking Through Errors In Apps Script

Breaking Through Errors In Apps Script

See where to find errors in your apps script and how to fix them. You will either get syntax errors ( the way the code is written) or runtime errors (when you actually run the code).
Intermediate
Allow Multiple Selections is in Google Sheets Yay!

Allow Multiple Selections is in Google Sheets Yay!

Now you can select multiple options in a dropdown. Hip Hip Hooray!
Beginner
FILTER() IFNA() JOIN() SEARCH() SPLIT() +1 more
Access Free API's with Google Sheets

Access Free API's with Google Sheets

Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with API's in this 1 hour dive into Free APis available online and accessible in Google Sheets. 
API's here: freepublicapis.com
Intermediate
COUNTIF() IF() IMAGE() ISBLANK()
Study Better With Google Sheets

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.
Beginner
COUNTA() GOOGLETRANSLATE() INDEX() RANDBETWEEN() VLOOKUP()
Built a Cookie Clicker Clone in Google Sheets

Built a Cookie Clicker Clone in Google Sheets

I built a clone of Cookie Clicker, live on YouTube. Watch the full 1 hour live stream here.

In this video I update it a bit, and show off that it works!! 

Learn how to build trigger builders and use user properties to store data you don't want a user to change (easily)
Advanced

Displaying items 141-160 of 351 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