How to Create a Google Sheets Add-on

How to Create a Google Sheets Add-on, available at $49.99, has an average rating of 4.55, with 32 lectures, based on 27 reviews, and has 300 subscribers.

You will learn about 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 This course is ideal for individuals who are Startups looking to build add-ons or Sheets integrations for their users. Also a great way to build a MVP. or Agencies seeking to build an add-on as a lead magnet for clients. Customers can use your proprietary machinations without giving them Apps Script. or Businesses of all sizes who wish to extend Google Sheets functionality for themselves and others. or Educators and Teachers who wish there was one little thing in Sheets that does _____ (fill in the blank)! Build it yourself. It is particularly useful for Startups looking to build add-ons or Sheets integrations for their users. Also a great way to build a MVP. or Agencies seeking to build an add-on as a lead magnet for clients. Customers can use your proprietary machinations without giving them Apps Script. or Businesses of all sizes who wish to extend Google Sheets functionality for themselves and others. or Educators and Teachers who wish there was one little thing in Sheets that does _____ (fill in the blank)! Build it yourself.

Enroll now: How to Create a Google Sheets Add-on

Summary

Title: How to Create a Google Sheets Add-on

Price: $49.99

Average Rating: 4.55

Number of Lectures: 32

Number of Published Lectures: 32

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

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

Chapter 2: MAKE IT WORK

Lecture 1: Introduction

Lecture 2: Write Apps Script to Create a New Google Sheets Formula

Lecture 3: Add Autocomplete with Custom Function

Lecture 4: How to Name Your Add-on

Chapter 3: MAKE IT USABLE

Lecture 1: Introduction

Lecture 2: Add-on Menu onOpen

Lecture 3: OnInstall to onOpen

Lecture 4: Apps Script Manifest

Lecture 5: Connect to a Google Cloud Project

Lecture 6: OAuth Consent Screen

Lecture 7: OAuth Scopes

Chapter 4: MAKE IT DISCOVERABLE

Lecture 1: Introduction

Lecture 2: Add-on Logo Design

Lecture 3: Add-on Banner Design

Lecture 4: Add-on Screenshots

Lecture 5: Add-on Web Site

Chapter 5: MAKE IT MARKETPLACE-ABLE

Lecture 1: Introduction

Lecture 2: Check Add On Works and Record Client ID Video

Lecture 3: Create an Oauth Consent Screen YouTube Video

Lecture 4: Complete the OAuth Consent Screen Approval

Lecture 5: OAuth Verification Request Email Action Needed

Lecture 6: OAuth Approval Request Granted

Lecture 7: Marketplace SDK Install and App Configuration

Lecture 8: Marketplace Store Listing

Lecture 9: Submit Store Listing for Approval

Lecture 10: Rejection!

Lecture 11: Marketplace Approval

Lecture 12: Marketplace Opportunities

Lecture 13: Update Your Add-on

Chapter 6: Create an Internal Add-on

Lecture 1: How to Create an Internal Google Sheets Add-on

Instructors

Andrew Kamphey
Google Sheets Wizard

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 1 votes

4 stars: 11 votes

5 stars: 15 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!