Tools, Templates, & Tutorials

535Google Sheet Tutorials

Discover the Power of Productivity with Our Exclusive Library of Google Sheet Tutorials!

Unleash your full potential with our comprehensive Library of Google Sheet Tutorials. Dive into the world of seamless data management and analysis with our tutorials, your gateway to mastering the art of Google Sheets.

Why Choose Our Google Sheet Tutorials?

🚀 Maximize Your Efficiency:

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.

🎯 Precision at Your Fingertips:

Master Google Sheets Match and Indirect functions, ensuring your data is always accurate and up-to-date. Say goodbye to errors and hello to precise, reliable results every time.

💡 Expert Tips and Tricks:

Explore the best-kept secrets of Google Sheets, including adding emojis to your spreadsheets and creating powerful combinations. Impress your colleagues and clients with visually appealing and informative sheets.

🔧 Google Script Magic:

Delve into the world of Google Script and learn how to generate PDFs with just a click. Elevate your document game and streamline your reporting processes effortlessly.

OAuth Consent Screen Video

Here's the exact OAuth Consent Screen YouTube Video I made. I took this and uploaded it as an unlisted video.

Check Your Google Sheets Add On Works

In this lesson we'll check if the add-on actually works and record a client ID video. A weird little thing that I've now done a few times so can hopefully show you how to easily do it without getting frustrated.

MAKE Your Google Sheets Add-on MARKETABLE

In this section we'll put our marketing materials to the test. We'll go through the ENTIRE process of asking for approval, getting rejected, and overcoming rejection to ultimately publish our Google Sheets Add-on to the world!

Add-on Web Site

Create a Carrd website for our Add-on. In this video I show you the exact template I use to make this process smooth as butter.

Get yourself a Carrd membership and copy the template here: https://24ddb0a6ef0fc2ca.demo.carrd.co

The website needs to include:

Privacy Policy
Terms of Service
Support

Add-on Screenshots

We need to take screenshots of the add-on in action. These will be available for users to see how the ad-on works with in the Google Workspace Marketplace. We'll also use these same screenshots later on for launching and on our website.

Add-on Banner Design

Create a banner. This is the thumbnail image that will appear in the Google Workspace Marketplace

Add-on Logo Design

Using Canva, we'll make a quick logo. A very quick logo for our Google Sheets™ Add-on

MAKE Your Google Sheets Add-on DISCOVERABLE

In this section of our Add-on course we'll get out of sheets for a bit and create marketing materials. I'll show you the templates I use to make websites very quickly. hint: It's CARRD!
I'll also show you how quickly I make the banner and logo. You might be as quick if you have your own company logo or you already have something made.

OAuth Scopes

A little bit about how to write scopes and where to write them. For your own add-on these might change.

OAuth Consent Screen

Configure the OAuth consent screen with information about your application.

Connect to a Google Cloud Project

This part can be very confusing. So I show you step-by-step how to do it.

Apps Script Manifest

We need to fill out our Apps Script manifest. In this video I show you how to get that to show up in our Apps Script.

OnInstall to onOpen

We need to bridge the gap between an add-on not being installed to actually being installed. We add a simple apps script.

Add-on menu on open

Instead of just adding a custom menu to a sheet, we're going to turn this apps script into an add-on menu operable add-on.

MAKE Your Google Sheets Add-on USABLE

In this section we're going to turn our apps script into an add-on. complete with add-on menu. (Yes it's different than a custom menu, slightly).

The things I go over in this section took a lot of trial and error. The first time I created a Google Sheets Add-on I was flabbergasted that it just didn't work like a Google Sheets Add-on. Until I did all the things I go over in this section.

How to Name Your Add-on

The most important part of the whole add-on creating process is naming it correctly. Avoid any and all existing names, as well as avoid any names that might conflict with Google Sheets itself.

Add Autocomplete with Custom Function

We'll make sure our additional custom formula acts like a native formula with autocomplete in a cell.

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our Add-on we'll be publishing to the Google Workspace Marketplace.

MAKE Your Google Sheets Add-on WORK

In this section of the Add-on course we'll be making the apps script work as an Add-on.

What is an add on? What problems can it solve?

Discover what an Add-on is, what it could possibly do and what kind of problems an add-on can solve. There are much more in depth idea driven videos later in the course. For those who might want to know exactly what an add-on is, this video help you out!

Displaying items 161-180 of 535 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