Google Sheets Tutorials · Better Sheets

Update to Coupon Code Maker
Available for free for lifetime members. Buy via Gumroad if you're not yet a member.
Watch the video because there are discount codes I show you in the video to get Coupon Code Maker for less than $30.
Yes I use Coupon Code Maker myself. It's how I put products from Gumroad onto AppSumo Marketplace.

Intermediate

▶

IF() ISBLANK() ROUND()

▶

How to Turn Background Color to Text

This tutorial showcases a practical solution to convert visual cues into actionable data in Google Sheets. It's a step-by-step guide on using Google Apps Script to automate the process of reading background colors and converting them into text. The focus is on simplifying data processing tasks and enhancing the utility of spreadsheets for data analysis.

Intermediate

▶

Celebrate Your Completed Checklists

Learn how to use apps script to add emoji animations when you complete a checklist in Google Sheets.

Advanced Intermediate

RAND() INDEX() IF() COUNTIF() IFNA() +3 more

▶

Brighten Up Your Checklist Automatically

Create a cool function that brightens your sheet background from white to some specific color a little bit each time you check off a to-do item.

Intermediate

▶

Laziest Checklist Ever

Get your spreadsheet to check off your checklist for you.

Dive into spreadsheet automation with this easy to follow script, or copy the sheet and use the script as you wish.

Intermediate

▶

A Few New Spreadsheet Business Ideas

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.

Intermediate

FILTER() ARRAYFORMULA() LOWER() IF() IFERROR() +1 more

▶

Generate Coupon Codes from a Google Sheet - Announcing Coupon Code Maker

You can now generate 100% off unique 1 time use Gumroad Coupon codes from a Google Sheet.
It's $30, available now.
Lifetime members get it for free
https://bettersheets.co/tools/coupon-code-maker

What does Coupon Code Maker do?
Coupon Code Maker is designed for generating coupon codes, particularly useful for sellers on Gumroad. The tool, simplifies the process of creating large quantities of unique, single-use coupon codes.

The tool leverages Google Apps Script for its functionality, indicating a strong reliance on automation and API interactions. It's particularly noted for its ability to generate a high volume of codes quickly and efficiently, which can be exported as CSV files for use on platforms like AppSumo and others. This is important for marketing and selling products effectively on various online marketplaces.

There will be continuous updates to Coupon Code Maker. Get it now for a 1-time payment and you'll get all future upgrades for free.

If you're wondering how to build something like this check out Spreadsheet Automation 101 and Supercharge Your Sheets, two courses available for monthly members and lifetime members alike.

Intermediate

▶

Maximize Spreadsheet Sales to Startups

A Review of Gary's AARRR Tracker and Landing Page Strategies that you can employ if you're selling templates, spreadsheets, and google sheets to Startups.

Explore how to enhance a spreadsheet landing page's appeal and effectiveness. Discover innovative strategies for crafting compelling landing pages, learn the art of selling solutions (not just spreadsheets), and get tips on leveraging Google Sheets to create digital products that truly resonate with your audience.

Whether you're a seasoned spreadsheet seller or just starting out, this video is packed with actionable advice to elevate your sales game. Tune in and transform your spreadsheet into a sellable sensation.

3 Key Takeaways

Market spreadsheets as problem-solving solutions, not just as templates or tools.
Design landing pages that tell a compelling story and focus on the benefits and solutions offered by the spreadsheet.
Utilize Google Sheets' advanced features and automations to enhance functionality and add value to your spreadsheet product.