Home > Software design >  Is it possible to publish a private Apps Script add-on for Google Sheets that anyone with a link can
Is it possible to publish a private Apps Script add-on for Google Sheets that anyone with a link can

Time:05-31

I have been tasked with developing a Google Sheets add-on that local middle/high school teachers can use with their students. I have a working prototype, but currently we can only distribute it by having teachers copy the container Sheet to their drive, then having students copy it from their teachers. Obviously this is messy, so I've been looking into publishing the add-on.

Is there a way to easily share a privately published add-on without manually approving each user or adding all those users to a domain? I need to be able to maintain control over the script so that bug reports/feature requests can be addressed, and the script needs to be able to be executed by an arbitrary number of students at any given time.

CodePudding user response:

In order to publish an add-on you would need to create a GCP project to publish it.

When doing so, you have the option to make it private if you have a Google Workspace account as presented below:

enter image description here

As suggested by the steps provided over this enter image description here

  • Related