internal add-ons and permissions

[Edward Wu]

I'm trying to figure out how to fix permissions with an internal add-on.

I'll try to keep this short, but it sure seems complicated to me.

We have 3 Google Sheet forms/templates (e.g. absence request form), and they each have an attached script file used for routing/archiving.

Let's say the name of one of the script projects is "Route and archive Absence form" and the name of the function is routeAndArchive.

The idea is that employees make a *copy* of the Google Sheet, fill it out, and share it with their manager.

Their manager fills out an approval section, then selects the routing/archiving script from the Extensions > Route and archive Absence form > routeAndArchive menu, which sends out an email and makes a copy of the Google Sheet into an archive Google Drive folder.

This was published as an internal add-on for our managers some time ago and has been working great.

The main reason/purpose of doing it as an add-on was so that the managers don't need to go through the whole "give the script permissions to do stuff" routine every single time, since each *copy* of the Google Sheet needed fresh permissions.

Recently, I had to make some changes to the scripts.

I re-deployed the scripts under "Manage Deployments" (so I was careful *not* to create a *new* Deployment).

And then I went into the Cloud Project console and updated the Marketplace SDK with the new version # and published it.

But now the function is gone from the menu.

If anyone (manager or not) goes into the Extensions menu, they see the Route and archive Absence form sub-menu, but under *that*, there's only "Help". The routeAndArchive sub-sub-menu is gone.

As the organization admin, I tried to log in to Google Admin and went to Apps > Admin install Google Workspace Marketplace apps > Route and archive Absence form and uninstalled then reinstalled it for an OU that contains the managers, but that didn't help.

I'm not sure what else I need to do to fix this and restore the functionality. Can someone help point me in the right direction?