Google Sheets Tutorials · Better Sheets

How To Duplicate a Tab and Move it to the End in Google Sheets

Learn how to automate creating a template and moving the tab to the far right, or the end of the google sheets tabs.

You Should Know The Limitations of Data Validation

You should know the difference between Data Validation and Data Veracity (or truthfulness of data)
This video points out some incredibly simple concepts of Data Validation you may want to use in your Google Sheets to make your data analysis better.

Intermediate Beginner

How To Send Two Emails in Same Trigger

Without having to create two functions and two triggers you can combine two email sends into one function.

Intermediate

How to Filter Multi-Select Dropdown Feature

Learn how to harness Google Sheets' new multi-select dropdown feature in this tutorial. We'll guide you through setting up dropdowns that allow multiple selections, using search and filter formulas to analyze and display data efficiently. By the end, you'll be able to create dynamic reports and dashboards, streamlining your workflow and enhancing data management. Perfect for those looking to get the most out of Google Sheets' latest functionality!

Intermediate

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Analyze sales with COUNTUNIQUEIFS Formula.

Intermediate

Better BMI Calculator

Learn how to calculate BMI and create a custom BMI formula in Google Sheets! In this video, you'll explore the basic formula for BMI using weight and height, then dive into Google Apps Script to create a native BMI function. Perfect for anyone looking to enhance their spreadsheet with custom functionality.

Intermediate

Daily Writer's Word Count Tracker

Walk through creating an awesome automatic word count tracker that's easy to use and motivates the writer to keep going. With AI generated quotes from famous writers, along with simple formulas to generate states along the way.

Intermediate

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

Introducing Bigger Brain

10x your expertise driven content. Create new sections and fun additions to your own content. Make your writing more engaging and more educational.

Intermediate Beginner Advanced

Create an Automated Task List

I've created simple automations to make an awesome automatic task list. Add a checkbox when adding a task. Add a timestamp when done. Also emailing every day the top task.

Intermediate

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.

Intermediate

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.

Intermediate Advanced

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

Create a Vote Button from Google Sites to Google Sheets

Connect your published Google Site to Google Sheets with Apps Script and a Button. Great to use for Voting, upvoting, NPS, or anything you want feedback on, at the click of a button from your Google site to a Google Sheet.

Intermediate

Find Column with Header to Bullet Proof your Vlookup

Make your VLOOKUP formulas flexible and your data move-able with this trick.

Intermediate

Reformat Pasted Cells Automatically

Create uniform formatting even if you're copy and pasting data that is differently formatted.

Intermediate

Americano Tournament Template With Four Automations

Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.

Intermediate

Build a Startup Pitch Generator in 20 minutes

Build a fully functioning AI powered startup pitch generator in 20 minutes. I saw a tweet listing startup accelerators and thought it would be cool to build a tool that edits my own startup idea into a personalized pitch to each startup accelerator fund. Get it for your google drive down below
https://docs.google.com/spreadsheets/d/1KevSvdwpONP89eBOe-8fDfp2fGlBafE7BAtI5wgGe2U

Get the AI script here: https://bettersheets.co/snippets/updated-open-ai-model-to-omni

Intermediate

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

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

Displaying items 1-20 of 159 in total

159Google Sheet Tutorials

Discover the Power of Productivity

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

🎯 Precise:

🔧 Automate Your Sheets