Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Publish new version of Google Sheets Add-on

Tags:

I have published a Google Sheets Add-on for internal use. It works. But I can't seem to publish a new version. I'm following this:

https://developers.google.com/gsuite/add-ons/how-tos/manage-addons

Given Google's announcement that they're retiring Chrome Store listings post Jan 28, I've been focusing on deploying to G Suite Marketplace. The steps I've taken are:

  • Update apps script
  • Create new version (File > Manage Versions ... > Save new version)
  • Edit G Suite Marketplace listing to use new version (per step 4 under "Update your editor add-on" in above page)

No amount of waiting or refreshing seems to cause the latest deployed code to be visible when I invoke the Add-on in a sample Sheets document.

like image 659
Paul B Avatar asked Jan 24 '19 22:01

Paul B


People also ask

How do you update Google add-ons?

Start Google Chrome. on the browser toolbar. Select More Tools -> Extensions. From there, you should see the “Update” button pop right up.

How do I create a Google spreadsheet addon?

Creating a new Google Spreadsheet Script option from the Tools menu. This will open a new window in your browser which contains the Google Script Editor. Click on Spreadsheet in the Create script for list. This will create a new script for you with onOpen and readRows functions already inserted in the script editor.


1 Answers

In your Google Cloud Platform project, go to the Configuration panel of the G Suite Marketplace SDK. Scroll down until you find "Editor Add-on extensions". You should see two text inputs – one with your Apps Script ID, and another below it, which is the version of your script used for the deployment.

enter image description here

like image 115
Tim Hanlon Avatar answered Nov 14 '22 21:11

Tim Hanlon