How To Create a Google Sheets™ Add-on

About this course
We'll go step-by-step taking an apps script bound to a your spreadsheet and turn it into a published Google Sheets add-on. We'll go all way from sheet to published. Your add-on, by the end of the course will be available to the public on the Google Workspace Marketplace.

You See Everything

In this course I've recorded the entire process of publishing my 6th Google Sheets Add-on.

We walk through the exact steps to go from a blank sheet, with no script all the way to an approved, published Add-on that's now available in the Google Workspace Marketplace. The add-on is available to 2 billion Google Sheets users.

Super Helpful

This process is usually a P-I-T-A but I've developed templates and a streamlined method to get you through what could take weeks in less than day. You won't worry so much.

I've gone through this now 6 times. 

Released 5 Add-ons:
  1. Sheet Styles: Color Your Sheets Nicely
  2. Tiny Sheets: Delete Unnecessary Cells
  3. Button Styles:  Make cool buttons
  4. Spintax: Spin Syntax Parser
  5. Asa: AI Assistant in Sheets
  6. and the 6th add-on I've published is featured in this course.

Get Started

If you're not a Better Sheets member, you can get this course at: Udemy.com/course/how-to-create-a-google-sheets-add-on/

Watch the 1st video free here: BetterSheets.co/tutorials/introduction-to-google-sheets-add-on-course

Hall of Fame

These Google Add-ons were created by students of this Add-on Course


Tutorials

Introduction to Google Sheets™ Add-on Course

Introduction to Google Sheets™ Add-on Course

In this course we'll go step by excruciating step how to take a simple a...
What is an add on? What problems can it solve?

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 p...
MAKE Your Google Sheets Add-on WORK

MAKE Your Google Sheets Add-on WORK

In this section of the Add-on course we'll be making the apps script wor...
Write Apps Script to Create a New Google Sheets Formula

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 Autocomplete with Custom Function

Add Autocomplete with Custom Function

We'll make sure our additional custom formula acts like a native formula...
How to Name Your Add-on

How to Name Your Add-on

The most important part of the whole add-on creating process is naming i...
MAKE Your Google Sheets Add-on USABLE

MAKE Your Google Sheets Add-on USABLE

In this section we're going to turn our apps script into an add-on. comp...
Add-on menu on open

Add-on menu on open

Instead of just adding a custom menu to a sheet, we're going to turn thi...
OnInstall to onOpen

OnInstall to onOpen

We need to bridge the gap between an add-on not being installed to actua...
Apps Script Manifest

Apps Script Manifest

We need to fill out our Apps Script manifest. In this video I show you h...
Connect to a Google Cloud Project

Connect to a Google Cloud Project

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

OAuth Consent Screen

Configure the OAuth consent screen with information about your application.
OAuth Scopes

OAuth Scopes

A little bit about how to write scopes and where to write them. For your...
MAKE Your Google Sheets Add-on DISCOVERABLE

MAKE Your Google Sheets Add-on DISCOVERABLE

In this section of our Add-on course we'll get out of sheets for a bit a...
Add-on Logo Design

Add-on Logo Design

Using Canva, we'll make a quick logo. A very quick logo for our Google S...
Add-on Banner Design

Add-on Banner Design

Create a banner. This is the thumbnail image that will appear in the Goo...
Add-on Screenshots

Add-on Screenshots

We need to take screenshots of the add-on in action. These will be avail...
Add-on Web Site

Add-on Web Site

Create a Carrd website for our Add-on. In this video I show you the exac...
MAKE Your Google Sheets Add-on MARKETABLE

MAKE Your Google Sheets Add-on MARKETABLE

In this section we'll put our marketing materials to the test. We'll go ...
Check Your Google Sheets Add On Works

Check Your Google Sheets Add On Works

In this lesson we'll check if the add-on actually works and record a cli...
OAuth Consent Screen Video

OAuth Consent Screen Video

Here's the exact OAuth Consent Screen YouTube Video I made. I took this ...
Complete the OAuth Consent Screen

Complete the OAuth Consent Screen

We'll finish up the OAuth consent screen form in this video.
OAuth - Action Needed

OAuth - Action Needed

We got a reply from our OAuth submission. It says "Action Needed" In thi...
OAuth Approval Request Granted

OAuth Approval Request Granted

YES!  This is what the request granted email looks like!  Phase 1 of 2 d...
Marketplace SDK Install and App Configuration

Marketplace SDK Install and App Configuration

Yet another confusing step in this whole process. In our cloud project w...
Marketplace Store Listing

Marketplace Store Listing

We will write our Store listing in this video.
Submit Store Listing for Approval

Submit Store Listing for Approval

After you get OAuth consent screen approval you can go ahead and submit ...
Rejection!

Rejection!

We get our Add-on rejected. Oh no! But wait, stay calm. We'll read the e...
Marketplace Approval

Marketplace Approval

We did it! The Add-on is approved. You can now go find the Add-on in the...
Marketplace Opportunities

Marketplace Opportunities

Wanted to share with you some opportunities where you can optimize your ...
Create an Internal Google Sheets Add-on

Create an Internal Google Sheets Add-on

The entire process to create and publish a Google Sheets Add-on internal...
How To Update Your Add-on

How To Update Your Add-on

How to update your add-on when you update your code for fixes or add fun...
Upgrade Your Add-on to V8 Runtime Explained

Upgrade Your Add-on to V8 Runtime Explained

How to and why to upgrade from V5 Rhino to V8 Runtime in Add-ons