How To Create A Google Sheets Add-On

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

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

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 looking to make 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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What is an add on? and what problems can it solve?

Section 2: MAKE IT WORK

Lecture 3 Introduction

Lecture 4 Write Apps Script to Create a New Google Sheets Formula

Lecture 5 Add Autocomplete with Custom Function

Lecture 6 How to Name Your Add-on

Section 3: MAKE IT USABLE

Lecture 7 Introduction

Lecture 8 Add-on Menu onOpen

Lecture 9 OnInstall to onOpen

Lecture 10 Apps Script Manifest

Lecture 11 Connect to a Google Cloud Project

Lecture 12 OAuth Consent Screen

Lecture 13 OAuth Scopes

Section 4: MAKE IT DISCOVERABLE

Lecture 14 Introduction

Lecture 15 Add-on Logo Design

Lecture 16 Add-on Banner Design

Lecture 17 Add-on Screenshots

Lecture 18 Add-on Web Site

Section 5: MAKE IT MARKETPLACE-ABLE

Lecture 19 Introduction

Lecture 20 Check Add On Works and Record Client ID Video

Lecture 21 Create an Oauth Consent Screen YouTube Video

Lecture 22 Complete the OAuth Consent Screen Approval

Lecture 23 OAuth Verification Request Email Action Needed

Lecture 24 OAuth Approval Request Granted

Lecture 25 Marketplace SDK Install and App Configuration

Lecture 26 Marketplace Store Listing

Lecture 27 Submit Store Listing for Approval

Lecture 28 Rejection!

Lecture 29 Marketplace Approval

Lecture 30 Marketplace Opportunities

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.