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

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

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

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

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

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

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

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

Big Year - a Whole Year in One Google Sheets Tab

Get "Big Year" for free via Gumroad.

Get perspective on your 2024 plan with this full year calendar template in Google Sheets.

All-Year-in-One Overview

Imagine having the entire year's schedule on one single page. BIG YEAR offers a comprehensive 12-month display, providing an at-a-glance view of your whole year. This holistic perspective makes it easier to plan long-term projects, vacations, and personal milestones, ensuring you never miss out on life's big events.

More info on the Gumroad page

Automate Google Sheets With Zero Experience

By the end of this video you should be knowledgeable about how to automate spreadsheets. I'm assuming you have no knowledge of how to automate or how to code and so we're gonna start with a very blank page

Beginner

Access the Dictionary API to get Definitions for Words in Google Sheets

Advanced

Selling Spreadsheets Course Introduction

Let's go sell great spreadsheet products.

Explore Your Spreadsheet Selling Options

- Template
- Custom Formulas
- Custom Functions - Apps Script
- Google Sheet Add-ons

Surprising Things about Selling Spreadsheets

A few things that surprised me when I started selling sheets. From landing page copy that converts, to what people want to know after they buy.
- Adding videos to onboard helps immensely.
- Landing page copy should agitate, not solve everything.
- Sheets aren’t sold, they’re bought.
- Selling a great sheet is selling a great process.
- You can Launch, again and again… seemingly forever.

SECTION 2 - Your Spreadsheet Blueprint

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

The #1 Mistake Spreadsheet Sellers Make and how to Save People Time

Scope down from an existing problem to a sheet that still solves a juicy problem. If you can solve something in 10x less time, you win. Find out how lack of specificity is the #1 mistake. I’ll share with you a quick way to figure out if you’re really saving people time.

Problems Everywhere, and the Spreadsheets that Solve Them

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.

What is this Ampersand Doing in Google Sheets?

What is "&" doing in this formula? MONTH(A1&1)
Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.

CONCAT() DATE() MONTH() VALUE()

DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

Create dark mode with Conditional Formatting.

Conditional Formatting Beginner

Uncheck Every Checkbox in Google Sheets

Automatically uncheck a whole range of checkboxes. Or just do it yourself with the spacebar.

Intermediate

How to Make an AI Integrated Freebie Spreadsheet

Get the freebie here at @abloommedia on TikTok or on Abloommedia.com
Sorry no sheet available even for members. Get the AI code in the video mentioned: Upgrade AI to GPT 4

Intermediate

IF() ISBLANK()

How to Make Good Looking Spreadsheets

Create nice colorful sheets (contrasting colors) that look and feel like an extension of your site. Add some padding around text. Decrease text and make your sheets awesome.

Intermediate

Displaying items 161-180 of 306 in total

TAGS

FORMULAS

TOPICS

306 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Self Destructing Google Sheet

Can a Google Sheet have DRM?

Maximize Spreadsheet Sales to Startups

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

A Few New Spreadsheet Business Ideas

Whitening Google Sheet Prank

Big Year - a Whole Year in One Google Sheets Tab

Automate Google Sheets With Zero Experience

Access the Dictionary API to get Definitions for Words in Google Sheets

Selling Spreadsheets Course Introduction

Explore Your Spreadsheet Selling Options

Surprising Things about Selling Spreadsheets

SECTION 2 - Your Spreadsheet Blueprint

The #1 Mistake Spreadsheet Sellers Make and how to Save People Time

Problems Everywhere, and the Spreadsheets that Solve Them

What is this Ampersand Doing in Google Sheets?

DarkSide of Google Sheets - Creating Dark Mode and Making it Better!

Uncheck Every Checkbox in Google Sheets

How to Make an AI Integrated Freebie Spreadsheet

How to Make Good Looking Spreadsheets