Publishing Google Script Addon to G Suite Marketpl

问题:

I've got some Google Sheet script code that I'd like to extract into Google Sheet Addon to be published for just of our domain (not public web). Individuals on my team have been able to do this successfully in the past but after 1/25/2019 when Google removed Add-Ons from Google Chrome Store we've been having difficulties.

I am trying to follow: https://developers.google.com/gsuite/add-ons/how-tos/publish-addons#publishing_instructions

But get the following error when trying to configure the G Suite Marketplace API:

Project Key is not associated with current project or the script version doesn't exist.

I am pulling the project Key from File --> Project Properties:

Does anyone have any idea where I am going wrong or know of good tutorial of how to publish a private Google Sheet Add-on?

回答1:

I had the same problem but identified a solution as follows. In the Google Apps Script Editor, under Resources -> Cloud Platform Project, click the ProjectName - project-id-xxxxxxxxxxxxxxxxxxx link. Then when it opens your Cloud Platform Project, in the upper left corner, your project name will be listed with a dropdown. Click the dropdown and verify that this project-id-xxxxxxxxxxxxxxxxxxx matches the link you clicked. The two numbers did not in my case and I had to refresh my screen for the correct project-id to show up in the Cloud Platform Project screen.

回答2:

Don't know if this will help, but I was having the same error message and I just got it to work. I put in the value from File --> Project Properties: ->Project key (Deprecated) and still got the error. Then I changed the version to the number of my latest version and it worked.

回答3:

The Project key has been deprecated. Try using the Script Id instead.