+ 18

144Google Sheet Tutorials

Discover the Power of Productivity

An Exclusive Library of Google Sheet Tutorials!

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

Learn the best Google Sheets formulas and spreadsheet automation techniques to supercharge your workflow. Discover how to automate repetitive tasks effortlessly, saving you valuable time and effort.

🎯 Precise:

Master Google Sheets formulas to ensure your data is always accurate and up-to-date.

🔧 Automate Your Sheets

Delve into the world of Google Apps Script. Automate reporting. Automate your data. Automate your business

Reformat Pasted Cells Automatically

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

Americano Tournament Template With Four Automations

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

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

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.

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

Send Better Email When Google Form Filled Out

Find out how to email all the form entries each time your form is filled out.

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

Advanced Coding in Google Sheets for Programmers

Add a Custom Menu
Create Native-like Functions
Get URL and Sheet ID's via Apps Script
A Few things to know about Developing Google Sheet Add-ons

Advanced Intermediate

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.

Google Sheets Easter Eggs Beyond PRIDE

Going beyond PRIDE, to show you some undocumented google sheets hacks that you might call "Easter Eggs"

Advanced Beginner Intermediate

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 Beginner Intermediate

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.

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internally to your own domain.

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.

Automate Move Blank Rows

Automate the apps script we just created that moves blank rows from one sheet to the other sheet. Original tutorial to write the apps script

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

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.

Automatically Backup a Spreadsheet

Make a copy and rename to BACKUP plus the Date of the backup. Execute this automatically via Triggers in your Apps Script. Two are shown here. to back up a tab or back up a spreadsheet file.

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatically copy a spreadsheet tab to a whole new spreadsheet file, get the url of that new sheet, and make sure the new file is values only. no formulas. A member asked this question and I'm happy to answer it, code it, and let you in on the answer in this short video.

Quickly Build a Daily Random Motivational Quote Website

Build a website from scratch using a little bit of Google Sheets as the backend. Using Carrd to build a html website from the data and display a random quote every time you refresh the page. All the code including the HTML embed is in the sheet below.

Displaying items 1-20 of 144 in total

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons