Did you know you can code Google Workspace? Add functionality to Google Docs, Sheets, Slides, Forms, etc. Check out the 2 dozen+ plugins Google developer expert Alice Keeler has published in the Google Marketplace. If you'd like to learn how to add your complementary idea to the marketplace, join Alice Keeler for her upcoming workshop:
Get your complementary published workshop: $1000
Workshop on learning to code using ChatGPT: $499
How to publish your Google Workspace add-on
There are many steps to go from idea to published plugin. Here's how to publish your Google Workspace add-on:
- Have a functional plugin for Google Docs/Sheets/Slides/Forms/etc…
Note: This is coded with Google Apps Script and JavaScript. - Test the plugin via the script editor.
- Create a logo for the plugin.
- Have a website with a page dedicated to clearly describing the plugin's usage and scope.
- Create a Google Cloud Project (GCP).
- Submit for oAuth within the GCP project.
- Links the GCP project to the Apps Script project editor.
- Create a video demonstrating the use of scopes for the plugin and upload it to YouTube.
- Submit it for oAuth approval through the GCP project. Include the required scopes, YouTube video link, logo graphic, and website link.
- Wait for approval from Google. Make the requested updates to your application.
- Deploy a version of your plugin through the Apps Script project editor.
- Install the Google Workspace Marketplace SDK for your GCP project.
- Configure the app in the Google Workspace Marketplace SDK.
- Develop your Play Store listing, including screenshots and YouTube videos.
- Submit for approval.
- Wait for approval. Make the requested updates to your application.
- Share your approved Google Workspace add-on with others.
Workshop outline
Please note that the goal of this workshop is to guide you through the steps to get your add-on approved by Google Workspace Marketplace. Your plugin is NOT guaranteed to be approved. In this workshop you will learn a series of steps, along with tips and advice, on how to get your plugin approved.
Week 1: Planning Your Plugin
Use ChatGPT to create a basic plugin. Your project should not be complex. The purpose of this workshop is to help you learn how to publish your plugin. The focus is No on how to develop or create a plugin.
If you like First, learn more about coding with Google Apps Script. (ChatGPT compatible) please record for that workshop instead.
During this week, schedule a one-on-one session with Alice Keeler to discuss your project ideas and develop a manageable idea for your first published plugin.
Live Session: Demonstrates creating a basic add-on for Google Workspace. Discussion of limiting scopes.
Week 2: Developing your website and logo
You will need a website that follows the specific requirements of the Google Workspace Marketplace. Additionally, your website will need a terms of service page and a privacy policy page. This will focus on helping you choose your website and domain name URL.
Live Session: Website Review, Terms of Service Examples, and Privacy Policy Examples. Discussion of requirements.
Week 3: oAuth submission
You will need to create a Google Cloud GCP project for your plugin. Set up your project and oAuth.
oAuth is the pop-up screen you see when installing a plugin and lets you know what permissions the app is requesting. This week the discussion will continue about scopes and how to limit them to increase the likelihood that Google will accept your first application. You will submit your project for oAuth approval.
Live session: oAuth frustrations and how to manage them.
Note: Your oAuth plugin is unlikely to be approved within a week. Personally, we approve it in a day and sometimes it takes me months to approve the plugin. Please have reasonable expectations that this is a process that could take some time.
Week 4: Modifying your shipment
Please allow time for Google to approve your submission. Review possible updates that will be made when your submission is rejected.
Live session: modifying your oAuth submission.
Week 5: Installing the Google Workspace Marketplace SDK
In your Google Cloud Project (GCP), install Google Workspace Marketplace. Complete the required items to submit your add-on to Google Workspace. Creating screenshots, graphics and YouTube videos. You will submit your plugin to the market.
Live Session: Creating your submission to Google Workspace Marketplace.
Week 6: Share your submission
Once your Marketplace plugin is approved, you'll need to let people know it's live. What to do after your add-on is approved.
Note: Your plugin may not be approved yet. The review process can take many weeks. This workshop is 6 weeks long to give you time to hopefully complete the entire process.
Live Session: Manage support for your plugin