How to Create a Google Sheets Add-on

Name: How to Create a Google Sheets Add-on
Rating: 4.6 (51 reviews)

Add unique functionality to Google Sheets. Navigate the process from creation, through rejection, to ultimate approval

Highest Rated

Created byAndrew Kamphey

Last updated 3/2025

English

English [Auto],

What you'll learn

Create a publishable new feature of Google Sheets™
Extend Google Sheets™ functionality
Get free templates to build a site for your add-on and market your add-on
Overcome rejection when listing your add-on to the Workspace Marketplace

Course content

6 sections • 33 lectures • 2h 57m total length

Introduction3:26
What is an add on? and what problems can it solve?7:17

Introduction2:27
Build a simple Google Sheets add-on with Apps Script by creating a custom function that returns a calculated number, then deploy it and use a CPM function as a prototype.
Write Apps Script to Create a New Google Sheets Formula4:31
Add Autocomplete with Custom Function5:14
Learn to turn a custom function into a Google Sheets native formula using Apps Script, complete with autocomplete, descriptions, and parameter guidance for a user-friendly add-on.
How to Name Your Add-on8:43
Discover how to name your add-on or custom function without conflicting with existing Google Sheets names. Learn rules on underscores, determinism, return values, and avoiding duplicate functionalities.

Introduction2:17
Learn how to convert a finished custom function into a usable Google Sheets add-on by implementing app script features: on open, on install, alerts, and a sidebar.
Add-on Menu onOpen2:47
Learn how on open triggers load Google Apps Script, create an add-on menu in Google Sheets, rename a CPM custom function, and deploy via extensions with on install.
OnInstall to onOpen1:30
Apps Script Manifest2:05
Open project settings to reveal the Apps Script json manifest, check the manifest box, and access the json in the editor as you prepare the Google Cloud project.
Connect to a Google Cloud Project2:13
OAuth Consent Screen2:25
OAuth Scopes3:13
Learn how to manage OAuth scopes for a Google Sheets add-on, including spreadsheets and script container UI, updating the manifest, and navigating the consent screen.

Introduction4:07
Check Add On Works and Record Client ID Video4:30
Create an Oauth Consent Screen YouTube Video0:08
Complete the OAuth Consent Screen Approval4:20
OAuth Verification Request Email Action Needed9:11
Handle a Google Sheets add-on OAuth verification request by confirming production status in Google Cloud Console, replying to the verification email, and publishing from testing to production.
OAuth Approval Request Granted2:54
Marketplace SDK Install and App Configuration5:05
Enable the marketplace SDK in Google Cloud, configure the sheets add-on with app deployment, copy the script ID and version, set OAuth scopes, and complete developer details for public distribution.
Marketplace Store Listing6:29
Submit Store Listing for Approval9:26
Rejection!9:31
Navigate a marketplace rejection for a Google Sheets add-on, identify the single blocking issue in settings, update the listing details, resubmit, and respond to the reviewer to expedite approval.
Marketplace Approval4:00
Marketplace Opportunities10:01
Update Your Add-on6:47
How to update your add-on when you update your code for fixes or add functionality.
Upgrade Your Add-on to V8 Runtime Explained6:57
I discuss the necessary upgrade to the V8 Runtime for your Apps Script add-ons. I encountered an issue with sidebars not functioning properly, which I discovered can be resolved by testing in an incognito tab. I also walk you through the steps to update your project settings and deploy the new version.

Requirements

You do not need to be expert programmer, but should know basic programming concepts.
You'll need to have used Google Sheets.
You've already signed up for the Google Developers and have a Workspace Account.

Description

Creating and publishing a Google Sheets Add-on involves several steps, including coding, testing, packaging, and submitting the add-on for publication. In this walkthrough, I'll guide you through the entire process, including the challenges you might encounter and how to overcome them.

During the course of this video course I publish my 6th add-on. I share with you the problems, rejections, challenges, and how to overcome them all.

I share with you the website template I use for all my add-ons, and the exact theories I use now to publish on the Workspace Marketplace to be found.

This course is great for those who want to extend the functionality of Google Sheets, or those who want to integrate their own app into Sheets. Whether you want to make something for sheets users to find you, or you want to make a functioning app for your current customers in sheets. This course has something for you.

If you have an add-on in mind to make, let's walkthrough the entire process of creating, coding, and ultimately publishing a Google Sheets Add-on.

If you have not yet gotten an idea there's plenty in this course!

Whether you're making a free add-on, a paid add-on, or even an add-on just for your organization, this course will help you through the entire process.

Who this course is for:

Startups looking to build add-ons or Sheets integrations for their users. Also a great way to build a MVP.
Agencies seeking to build an add-on as a lead magnet for clients. Customers can use your proprietary machinations without giving them Apps Script.
Businesses of all sizes who wish to extend Google Sheets functionality for themselves and others.
Educators and Teachers who wish there was one little thing in Sheets that does _____ (fill in the blank)! Build it yourself.

How to Create a Google Sheets Add-on

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 11min

MAKE IT WORK4 lectures • 21min

MAKE IT USABLE7 lectures • 17min

MAKE IT DISCOVERABLE5 lectures • 25min

MAKE IT MARKETPLACE-ABLE14 lectures • 1hr 23min

Create an Internal Add-on1 lecture • 21min

Requirements

Description

Who this course is for: