Google Sheets Tutorials · Better Sheets

A Spreadsheet CRM: Automation at work

Check out a CRM built inside of Google Sheets called SheetifyCRM.com

Beginner

SECTION 6 - Spreadsheet Breakdowns

Walk through real life examples of landing pages of spreadsheets for sale, and the actual spreadsheets.

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

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

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

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

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

Open Spreadsheet to Motivational Quote Automatically

Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.

Beginner

COUNTA() INDEX() RAND() ROUNDUP()

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

Go to Specific Cell When Spreadsheet is Opened

Create an automation that goes directly to a cell you pick every time you open the spreadsheet file.

Beginner

Don't Delete My Formulas

How to prevent someone from deleting your formulas. Beyond protecting your range or sheet.

What Sucks About Selling Spreadsheets And How to Solve These Problems

I go through a few of the darkest parts of selling spreadsheets and how you can fix them. I offer how to do updates that generate revenue and what marketplaces to sell on to avoid marketing into the void.

Advanced

Make AI-generated Poems Based on Name

Create simple poems based on someone's name with AI.
AI Apps Script Code here: https://bettersheets.co/snippets/updated-open-ai-model-to-omni

Intermediate

Make a Tour of Your Sheet

create a tour of your sheet for users who might be using your sheet and need to know what to do on each tab.

Advanced

Creating a Custom URL Link for Your Spreadsheet

Create an apps script function that gets the url of your spreadsheet into a cell.

CONCAT() HYPERLINK()

Add Character Count and Character Limit

I'm gonna show you how to make a character counter and then account characters. And then I'm also gonna show you how to make a limit. It's really simple. It's one formula and some conditional formatting

Beginner

LEN()

Roast: Mortgage Calculator for Google Sheets

Reviewing an existing sheet called "mortgage calculator for Google sheets" I point out the really nice "back to dashboard" button. This seems like a minor point but ends up improving the user interface, and user experience. Users tend to get lost in sheets with tabs, and providing another path to a sheet you know your users will want to go to, is great. At the end of the video I point out that you probably want to provide more outputs than inputs. Meaning that if someone puts in a few numbers, they get out of it a few years of statistics, or calculations in this case. Calculators are cool, but generators are even better. Calculators have a tendency to have more inputs than outputs. You're trying to get to one magical result. But a spreadsheet can be so much more powerful and show many more outputs if you do those calculations,. Especially here for a mortgage, you can show a range of calculations in addition to a single calculation.

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Make your Google Sheets visually appealing and easier to understand with our expert tips on using gridlines, border styles, and colors. Learn how to create a professional-looking spreadsheet that effectively communicates your data to your audience. Boost your productivity today! We're gonna be talking about how to communicate better with grid lines, border styles, and border colors. Really interesting thing happens when you hide grid lines. You lose the grid, and I'll show you how to add that in. And some really interesting things you can do with different styles of border.

Beginner

Create Square Cells for Dashboards or Beautiful Information

I offer an alternative design for your dashboards. Any time you want to present information, stats, numbers, it's a good idea to see what else is possible. Design something that makes your sheets stand out from the drudgery we've been dealing with for decades of spreadsheets and dashboards.

Beginner

Displaying items 101-120 of 182 in total

TAGS

FORMULAS

TOPICS

182 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

A Spreadsheet CRM: Automation at work

SECTION 6 - Spreadsheet Breakdowns

Where to Sell Spreadsheets - Marketplace Marketing

How to Sell Spreadsheets on AppSumo Marketplace

Protect Your Spreadsheet IP

Move Cells to New Row with Formula

Automatically Backup a Spreadsheet

Open Spreadsheet to Motivational Quote Automatically

How do I reference a different spreadsheet in Apps Script?

3 Free Tools to Make Your Google Sheets Better

Go to Specific Cell When Spreadsheet is Opened

Don't Delete My Formulas

What Sucks About Selling Spreadsheets And How to Solve These Problems

Make AI-generated Poems Based on Name

Make a Tour of Your Sheet

Creating a Custom URL Link for Your Spreadsheet

Add Character Count and Character Limit

Roast: Mortgage Calculator for Google Sheets

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Create Square Cells for Dashboards or Beautiful Information