Better Sheets
Tools, Templates, & Tutorials

Better Sheets Academy

Free Resources ↓

Member Login
Pricing
→ Random Tutorial

Tags

Formulas

131Google 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

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
Automate Move Blank Rows
Intermediate
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
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
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.
Intermediate
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.
Intermediate
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.
Intermediate
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
Weird Idea: Find a Great Sheet Domain Name
Find a domain to get sheet ideas.
Intermediate
Lock Your Sheets with OnlySheets
Understand what you can do, if you use OnlySheets between your payment processor and the buyer.
Intermediate
Protect Your Spreadsheet IP
Tips and tricks to make sure people don’t resell your sheet. Or if they do, catch them. 
- Brand the heck out of your Awesome Useful sheets
- Add your business info everywhere (I mean everywhere!)
- Consider selling more than the sheet (advice/consulting/onboarding/auto email series/videos)
Intermediate
How to Sell Spreadsheets on AppSumo Marketplace
Get this tool: Coupon Code Maker to make it insanely easy to launch and sell on marketplaces like AppSumo Marketplace.

Intermediate
Six Figure Secrets
Repliers are buyers. Regularly build an email list with freebies, and giveaways so that you can resell later. This email list is a secret that I think only the six figure sellers selling spreadsheets actually do well. There are two known examples of Etsy sellers making 6 figures. Both of them mention email lists in their interviews.
Intermediate
Customer Service is Marketing
You’d be surprised about the questions you get asked once you start selling a Google Sheet. Take each and every one of those and turn them into marketing materials. Turn any and all questions into FAQ’s. Update your FAQ’s and your marketing frequently.
Intermediate
Where to Sell Spreadsheets - Marketplace Marketing
Understand the perks and nuances of marketplaces like Etsy, Gumroad Discover, and AppSumo Marketplace. How to sell the same sheet on any online marketplace.
Intermediate
SECTION 5 - Marketing Mastery
Promote and Profit from Your Google Sheets
Intermediate
OpenAI API Prompt with Array of Cells
Create a prompt to OpenAI with an array of cells
Intermediate
Quickly Integrate AI and Google Sheets
Intermediate
Avoid A Multi-Tier Approach
Reasons you may want to avoid the tiered approach, if you’re looking to sell your first spreadsheet. A tiered version can cause more confusion than you can ever imagine. You’re so familiar with your sheet, you know the ins and outs. Buyers and potential customers do not.  You can almost always change just about everything at nearly any time.
Intermediate
Upselling and Cross-Selling Techniques
Know what to add, what to take away, and ultimately how to create a spreadsheet anyone can buy at any price.  For example you can create a free template, add in custom formulas and automations into a Pro version.
You can also create an ideal version first at a higher price and release simpler versions for a lower price later.
Intermediate

Displaying items 1-20 of 131 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