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

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.

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()

Uncheck Every Checkbox in Google Sheets

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

Intermediate

Curate Google Sheets Easily - Automatic Bookmarklet Maker

Curated sites, articles, and more web resources super easily into a Google Sheet. Create a bookmarklet automatically with this apps script tool.

Beginner

Use Random Quote API in Google Sheets

Learn how to add random movie quotes and famous quotes to a Google Sheet. We'll use RapidAPI to get the code and just have a little bit of editing to the code to be able to use it in Google Sheets.

Intermediate

Convert Google Sheets into a REST API

How to use Google Sheets as a database by turning it into a REST API with Google Apps Script. This makes Google Sheets a powerful tool for managing data online, allowing for easy data entry and retrieval without manual sharing or updating.

This allows you to add and get data from the sheet over the internet without sharing the sheet. It shows how to:

Write code in Google Sheets that listens for web requests.
Use doGet and doPost functions to handle these requests.
Insert data into the sheet and fetch a summary of this data through the web.
Deploy the script as a web app to get a URL for accessing the API.
Test the API with tools like Postman or embed it in a web form.

Advanced

Build a Book Recommender with AI in Google Sheets

Create an Email form that sends a few books to AI and gets back a book recommendation. Build the backend in Google Sheets Apps Script while using Carrd to easily make an online form.

Advanced

Activate A Certain Sheet When Opening a Spreadsheet

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.

Intermediate

SECTION 4 - Spreadsheet Sales Mastery

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

Intermediate

The Strangest Secret to Selling a Spreadsheet

Don’t sell a spreadsheet. Feature the problem and solution, not the sheet itself. It just so happens to be a spreadsheet.

Displaying items 181-200 of 324 in total

TAGS

FORMULAS

TOPICS

324 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

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

Problems Everywhere, and the Spreadsheets that Solve Them

What is this Ampersand Doing in Google Sheets?

Uncheck Every Checkbox in Google Sheets

Curate Google Sheets Easily - Automatic Bookmarklet Maker

Use Random Quote API in Google Sheets

Convert Google Sheets into a REST API

Build a Book Recommender with AI in Google Sheets

Activate A Certain Sheet When Opening a Spreadsheet

SECTION 4 - Spreadsheet Sales Mastery

The Strangest Secret to Selling a Spreadsheet