How do I update a Google Sheets Add-On

Question

I have made changes to my (already published) Google Sheets Add-On (in the Script Editor). I have created a new version and pressed "Publish > Deploy as Add-On" which says

You must configure the G Suite Marketplace SDK to publish an add-on.

When I click on the link G Suite Marketplace opens (and I see the currently published products catalog entry) but no way of specifying a new version. . When I click OK nothing happens.

Answer 1

The entire Google Sheets add-on deployment workflow is one hot mess. Do not use Publish -> Deploy as Sheets add-on... to update an already-deployed AppScript. It does not work.

Instead, first create a version of the script File -> Manage version. Then go to the G Suite Marketplace SDK page in the Google Cloud Platform console (console.cloud.google.com). Under the Configuration tab, scroll down to find Editor Add-on extensions where Sheets add-on extension should already be checked (if you followed the publication directions earlier and have already successfully published the add-on).

There you will see a field for the script version number. Increment it to the latest version, and Save changes. As far as I can tell this takes effect immediately.