Tools, Templates, & Tutorials

132Google Sheet Tutorials

Discover the Power of Productivity

An Exclusive Library of Google Sheet Tutorials!

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

Learn the best Google Sheets formulas and spreadsheet automation techniques to supercharge your workflow. Discover how to automate repetitive tasks effortlessly, saving you valuable time and effort.

🎯 Precise:

Master Google Sheets formulas to ensure your data is always accurate and up-to-date.

🔧 Automate Your Sheets

Delve into the world of Google Apps Script. Automate reporting. Automate your data. Automate your business

Upselling and Cross-Selling Techniques

Know what to add, what to take away, and ultimately how to create a spreadsheet anyone can buy at any price. For example you can create a free template, add in custom formulas and automations into a Pro version.
You can also create an ideal version first at a higher price and release simpler versions for a lower price later.

Pricing Strategies for Spreadsheets

Pricing is an art. Learn to balance affordability with profitability, understand market expectations, and apply different pricing models to maximize revenue.

Reciprocity Rules

But in some instances you will need to make a Free version for people to see, smell, tire-kick. Give’em a little taste. It summons the influential power of “Reciprocity”.

Why “Free” sucks and how to make something people will buy. Sure I’m going to make a whole other course about freebies and lead magnets but for us, right now, right here, free sucks.

Write The Sales Page

How to write a great sales page, that solves problems, and happens to mention it’s a Google Sheet.

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.

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.

SECTION 3 - How to Make a Spreadsheet

Crafting High-Demand Sheets from Scratch. Turn templates into tools to make sellable spreadsheets.

Every Possible Permutation - Solved with Spintax

Someone asked about how to find all the permutations of text and I thought it was a perfect example to show you how to use Spintax add-on. Free for everyone.

→ Get Spintax

Turn Headlines up to 11! - Update to Spintax Tool

Updated the Spintax tool to allow you to generate Spintax. Instead of having to come up with it all yourself, you can let AI generate the Spintax for you. Create variations on headlines, or phrases, or emails.

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.

Create a Branded Lead Magnet from Qualitative Data

Find out how to turn some data you can copy/paste from the web into a branded lead magnet for yourself.

Check out Josh's Tweet about the sheet.
and check out his Podia.

The video shows the importance of adding personal touches to a Google Sheet to connect better with users. It explains how to analyze the sheet's data to find trends and best practices for website content. Lastly, it discusses ways to share the sheet widely while still giving credit to its creator.

Duplicate Everything For Each Unique Value

Great use of SPINTAX. Get the Google Sheet Add-on; SPINTAX for free.

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.

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

Uncheck Every Checkbox in Google Sheets

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

Create Your Own NIGHT Mode (like PRIDE)

Create easter eggs in your sheets.

Conditional Formatting Intermediate

How to make a Pill Form Field in Google Sheets

Create rounded pill form fields in Google Sheets.
Using Canva and a bit of a transparent PNG hack, you can make these very easily too!

also make sure to check out Coupon Code Maker a software product I sell that generates thousands of coupon codes in a click.

Recently updated dashboard makes it really cool!

Coupon Code Maker Updates February 2024 - New Dashboard

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.

Idea Graveyard - Create a Decaying Checklist

Build a simple function that deletes undone items in our checklist.

Displaying items 21-40 of 132 in total

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons