How to Create a Google Sheets Add-on

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

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

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
Explore from concept to marketplace how to create a Google Sheets add-on, including what an add-on does, building the app, Google Cloud project, OAuth scopes, and launching on Product Hunt.
What is an add on? and what problems can it solve?7:17
Discover how Google Sheets add-ons extend spreadsheet functionality with extensions like sheet styles, tiny sheets, and button styles, enabling integrations, custom functions, and streamlined dashboards.

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
Create a CPM custom function in Google Sheets using Apps Script, defining inputs cost and views, computing cost per mille, testing, and preparing for autocomplete in subsequent videos.
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
Configure an install trigger (on install) in Google Apps Script to move users from not installed to installed, ensure on open runs, and add the add-on to the add-on menu.
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
Connect your app script to a Google Cloud Platform project by selecting or creating a GCP project, copying the project number, and configuring the OAuth consent screen.
OAuth Consent Screen2:25
Configure the OAuth consent screen for your Google Sheets add-on, selecting external or internal access, and provide the app name, contact email, logo, and website.
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.

Introduction3:02
Learn how to make your Google Sheets add-on findable by crafting branding assets—logo, banner, and website—using Canva and card templates.
Add-on Logo Design2:07
Add-on Banner Design2:25
Design a clean add-on banner in Canva using a 220 pixels wide by 140 pixels high dimension, with minimal text and a standout logo, then export as PNG.
Add-on Screenshots5:47
Add-on Web Site11:25
Learn to build a dedicated add-on website using a reusable template, customize text, images, pricing, and links, and configure DNS and publishing settings for a Google Sheets add-on.

Introduction4:07
Learn how to publish a Google Sheets add-on by completing the OAuth consent approval and the marketplace listing, while testing the website and recording a client ID.
Check Add On Works and Record Client ID Video4:30
Check that the Google Sheets add-on works, then record a short video showing the client ID on the consent screen and in the console, and reauthorize if needed.
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
Learn how to navigate the OAuth approval process for a google sheets add-on, including reviewing scopes, handling verification timelines, and preparing for marketplace listing.
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
Learn to complete the marketplace store listing for a Google Sheets add-on by configuring language, writing concise descriptions, choosing pricing, uploading icons and banners, and adding screenshots and policy links.
Submit Store Listing for Approval9:26
Submit your google sheets add-on store listing for approval after completing the OAuth consent screen, deploying a new version, and updating the script version, then wait for review.
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: