TRY ME!
→ Random Tutorial

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

SECTION 6 - Spreadsheet Breakdowns

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

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

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

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
Lock Your Sheets with OnlySheets

Lock Your Sheets with OnlySheets

Understand what you can do, if you use OnlySheets between your payment processor and the buyer.
Intermediate
Weird Idea: Find a Great Sheet Domain Name

Weird Idea: Find a Great Sheet Domain Name

Find a domain to get sheet ideas.
Intermediate
Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

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
Automatically Backup a Spreadsheet

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

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?

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()
Send Better Email When Google Form Filled Out

Send Better Email When Google Form Filled Out

Find out how to email all the form entries each time your form is filled out.
Intermediate
Every Google Drive File Created in Last 24 Hours

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
Add NPS to Your Google Site

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
AVERAGE()
Better Email Form on Google Sites

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.
Advanced Intermediate
Go to Specific Cell When Spreadsheet is Opened

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
Why can't people fill in my Google Form?

Why can't people fill in my Google Form?

The reason is because a new form has a setting to only allow those in your domain to fill in the form. I show you in the settings page where to fix this.
 Create New Worksheet When Google Form Submitted

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inserted into the new sheet.
Advanced
Can I Automatically Rename a Sheet based on a Date?

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.
Intermediate
DAY() MONTH() TODAY() YEAR()
How To Get Someone to look at a Cell in Your Sheet

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in your sheet.
Beginner
What Sucks About Selling Spreadsheets And How to Solve These Problems

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

Displaying items 261-280 of 367 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