148 Google Sheet Tutorials

Learn how to import DropCatch data with 100,000 domains into a Google Sheet. Find out how to get a filtered list of domains with sheet in them. And how to generate ideas of what to build based on these found domains.

Leveraging Expired Domain Names for Google Sheets Business: The speaker discusses using expired domain names to create and sell Google Sheets templates or tools. He demonstrates how to find domain names related to 'sheets' and suggests creative business ideas around them.

Importing and Analyzing Data in Google Sheets: The process of importing CSV data into Google Sheets and manipulating it to find specific information (like domains containing the word 'sheet') is showcased. This highlights the versatility of Google Sheets in handling and analyzing data.

Idea Generation and Business Opportunities in Google Sheets: The speaker, Andrew Kamphey, provides several examples of how to generate business ideas using Google Sheets. He suggests various niches like WordPress-related spreadsheets, balance sheets for accountants, and even educational tools like math workbooks, demonstrating the wide range of potential applications for Google Sheets in various domains.

Figure out the framework to consistently come up with spreadsheet-able ideas and make them super easy to execute from your laptop.

I'm breaking down the landing page of titlecraft master nonfiction book titles. It's by two people I know on Twitter, and they send this to me and it's free, it's zero dollars

Get the spreadsheet for free: https://kampheyapproved.gumroad.com/l/100ways100subs/sellingspreadsheets
Watch how to make a Bookmarklet video: https://bettersheets.co/tutorials/let-s-make-a-bookmarklet

In my video, I talk about how common problems are and how Google Sheets can help solve many of them in business. I discuss the different ways Google Sheets can be used, from simple to complex tasks, and plan to share five specific ways to use it effectively in future videos for better planning, tracking, and managing tasks.

Create dark mode with Conditional Formatting.

Create rounded pill form fields in Google Sheets.
Using Canva and a bit of a transparent PNG hack, you can make these very easily too!

also make sure to check out Coupon Code Maker a software product I sell that generates thousands of coupon codes in a click.

Recently updated dashboard makes it really cool! 

How to turn a spreadsheet in your Google Drive into a sellable product. Step-by-step, I will show you exactly how I do it. If you're selling a sheet you use, then you must do this!

Create a short function that runs every time a spreadsheet file is open. Redirects the user to the START tab. You can use this to direct anyone opening your file to a specific tab you want them to start on.

Turn Google Sheets into Revenue Streams with a simple sales page. Tell the story your users want to buy into.

Pricing is an art. Learn to balance affordability with profitability, understand market expectations, and apply different pricing models to maximize revenue.

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.

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

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

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)

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.

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.

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

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.

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.