TRY ME!

631Google 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!

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.

If you want to automate your spreadsheets more, take the course: Spreadsheet Automation 101.

Intermediate

▶

IMPORTRANGE()

▶

How to Make Better Lead Magnets

Learn how to make better lead magnets from Google Sheet checklists. Great for marketers and solo operators trying to get more leads, more customers, more clients.

Beginner

IF() HYPERLINK()

▶

Self Destructing Google Sheet

Create a sheet that can trash itself. It can delete itself instantly or on a timer. Maybe in 24 hours or a month.

Intermediate

▶

I Built a SEO Meta Description Writer

Unlock the Secrets of SEO Meta Descriptions! Learn how to craft compelling meta descriptions using AI and Google Sheets. Boost your website's visibility and engage your audience. Dive into the world of effective SEO writing now!

Advanced

IF() ISBLANK() IMPORTXML() INDEX() REGEXMATCH() +1 more

▶

200 REGEXMATCH Examples in Google Sheets

Uncover the Magic of Regex Match! 🎩✨ Explore 200+ Examples at BetterSheets.co. Validate emails, detect hashtags, format data & more! Dive into the world of Regular Expressions. Start Your Regex Journey Now!

Use REGEXMATCHER to generate any REGEXTMATCH formula you want.

Conditional Formatting Data validation Advanced

REGEXMATCH() REGEXEXTRACT() IF()

▶

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER! Imagine having the ability to effortlessly validate text patterns, ensuring the integrity of your data. Whether you're searching for specific mentions, cleaning up unwanted content, or filtering out irrelevant information, our REGEXMATCHER is your go-to solution.

Error-Free Data:

Experience precise data validation ensuring your information is accurate and error-free.

Effortless Pattern Recognition:

Easily identify and eliminate unwanted data patterns, guaranteeing a clean and organized dataset.

Tailored Data Classification:

Classify your data based on specific patterns, streamlining your workflow and increasing efficiency.

Advanced

REGEXMATCH() IF()

▶

YouTube Thumbnail A/B Test Results

Find out the results of YouTube Thumbnail A/B Tests with this YouTube Thumbnail Image hack we can do in Google Sheets.

Intermediate

IF() ISBLANK() IMAGE() CONCATENATE() SPLIT() +1 more

▶

Currency Exchange Tricks In Google Sheets

Little tricks to make Currency Exchange in Google Sheets better for you, and easier to read for others. Great for beginners, as well as Advanced Users.

Advanced Beginner Intermediate

GOOGLEFINANCE()

▶

Create Your Own API by Deploying a Web App

See how you can create your own API using Google Sheets' Web App feature. Deploy a web app and write doGet() to enable others to use an API you create yourself.

Advanced

IMAGE()

▶

Export Your Google Sheets to PDF with a URL

I want to show you a fantastic new tool that I created called bettersheets.co/pdf.

It allows you to easily generate a URL to download your Google Sheet as a PDF.

I'll walk you through the process step by step, showing you all the options you can choose from, such as portrait or landscape orientation, grid lines, sheet size, and more.

It's super convenient and completely free for everyone. So, let's dive in and explore this awesome tool together!

▶

How to Set Up OnlySheets with Zapier

I will guide you through the process of setting up Only Sheets with Zapier.

First, we will make a copy of OnlySheets in your Google Drive and set up the necessary access levels.

Then, we will configure the trigger and action in Zapier, ensuring that we capture the customer's email. Finally, we will deploy a web app and obtain the URL to complete the setup.

Watch the original how to set up OnlySheets video before this one: https://bettersheets.co/tutorials/announcing-onlysheets-2-0

Intermediate

▶

Set up Stripe with Only Sheets

I will guide you through the process of setting up Stripe with Only Sheets. I will show you how to make a copy of Only Sheets in your Google Drive, configure the necessary settings in Stripe, and deploy a web app.

Additionally, I will explain how to create a payment link in Stripe and set up webhooks.

Finally, I will demonstrate how to revoke access to the sheet and answer any questions you may have. Please make sure to follow along and take notes as needed.

Watch the 1st set up video: https://bettersheets.co/tutorials/announcing-onlysheets-2-0

Intermediate

▶

Set Up OnlySheets with Gumroad

I'll guide you through the process of setting up Only Sheets with Gumroad.

If you're new to Only Sheets, make sure to watch the "How to Set Up Only Sheets" video first.

In this video, I'll cover why you should use Only Sheets, how to integrate payments with Gumroad, and the step-by-step setup process.
I'll also provide important tips and instructions along the way.

By the end of this video, you'll have a clear understanding of how to set up Only Sheets with Gumroad and start accepting payments seamlessly.