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

Whitening Google Sheet Prank

Drive your office crazy by setting a trigger to lighten the text and background of your sheet by 1 rgb point every time they edit, or based on every hour!

Learn how to create triggers in a fun way.

Advanced

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.

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

Intermediate

How to Redirect Domains to Google Sheets and Google Docs

Learn how to use URL forwarding to Redirect Domains to Google Sheets and Google Docs. Also included is a new feature I like to in Google which is Publish To the Web. In a previous video about this topic I might not have mentioned that.

Intermediate

Can a Google Sheet have DRM?

Are you wondering if you can sell a google sheet and only allow buyers to use the sheet, and not share it? I answer that sort of question, with more questions!

Advanced

I Created an Advent Calendar

Just in time for the holidays. Great for making promotion calendars to reveal promotions day to day.

Beginner

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.

Intermediate

Displaying items 201-220 of 635 in total