Geek Answers Handbook

Google Apps script publishing add-on for internal use

Is it possible to publish an add-in without Google’s approval if it will be used only for my internal use?

If not, is it possible to make some of the Google Apps Script projects global. So I won’t need to copy the same code / functionality to other spreadsheets or documents in order to reuse my custom macros.

+13
google-apps-script google-apps-script-addon
source share
3 answers

You can publish the add-in so that it is limited to the domain / G Suite account that contains the Apps script file.

https://developers.google.com/apps-script/add-ons/publish

If the addendum is not published publicly, it does not go through the approval process.

Add-ins must be published to the G Suite Marketplace, which means that you need to create a “standard” Google Cloud Project, link it to your Apps Script project, and then enable the G Suite Marketplace SDK and configure the settings in the G. Suite Marketplace SDK.

To access the Google Cloud Platform Toolbar, use the URL

https://console.cloud.google.com/home/dashboard

  • From IAM and Admin, go to Resource Management
  • If you do not have an organization name, then create an organization
  • Create a new GCP project
  • Get GCP Project Number
  • Put the GCP project number in the application script project
  • Go to the API and Services toolbar.
  • Make sure the project you want to use is listed in the drop-down list.
  • Click Enable APIs and Services
  • Search for G Suite Marketplace
  • Enable G Suite Marketplace SDK
  • Set up the G Suite Marketplace SDK

It is also possible to make the application script project file available to other application script projects in the form of a “library”. The library can be made available for other application script projects by specifying the "project key" of the original application script (library).

Anyone who wants to use the source script file for Apps as a library needs a project key. To find the project key, in the code editor select "File" - "Project Properties" and find "Project Key (Deprecated)"

To add the application script file as a library, select "Resources" - "Libraries" in the code editor. You do not need to do anything to create a library. Each Apps Script project is available as a library. All you have to do is share the project key.

You can add the Add-in menu item to a spreadsheet or Google document without publishing the add-in, and this Add-in menu item will run any code that is in this document , just like an add-in. But you will need to edit the document of each user for whom you want to deploy the code, and manually add the code to your document.

If the Apps Script file is not published as an add-in, then it makes no sense to create an add-on menu, since you can create your own menu.

+12
source share

Select Publish> Expand As Spreadsheets in the Script Editor and create a new item in the Chrome Web Store. This item will be associated with your CWS developer account, and you can publish the item as 'private' or as a draft available for testers so that only people in your domain can access it.

+1
source share

The response received is out of date. You can publish the add-on using the G Suite Marketplace SDK, which has its own "Integrate with Google" button on the configuration tab for local integration. See https://developers.google.com/gsuite/marketplace/sdk .

Google's help on this is pretty decent at https://developers.google.com/gsuite/add-ons/how-tos/publishing-editor-addons .

0
source share

More articles:


All Articles