I often have to create small extensions for Google Workspace Apps ( Docs, Slides, Gmail etc) which I want to give some users access to. Sometimes only a selected number of users needs them, often only for a specific use case.
Those users are often not very technical experienced so I want to have a very simple setup process for them which does not include copying Appscript files from one place to another, or having a 10 step instruction.
The best solution I came up is to always create a Google Workspace Add-on (even when a simple editor script would also work) and share the AppScript Project with those user who want the Add-on. Then those users need to install it as a test deployment from the AppScript project.
This is not an ideal solution since I actually don't want to give those users access to the Appscript Project and source code.
Publishing the Add-on within the organisation would result in a better user experience since most users know how to install addons from the marketplace but since every Add-on would need a seperate gcp project this is way to much overhead for simple scripts.
Is there any better solution to this?