How To Create A Google Sheets Add-On

Free Download How To Create A Google Sheets Add-On
Published 6/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.06 GB | Duration: 2h 23m
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
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.

Homepage

www.udemy.com/course/how-to-create-a-google-sheets-add-on/