OAuth Review team can't see my Add on

16 views
Skip to first unread message

Ravi Vyas

unread,
Aug 17, 2020, 10:43:00 AM8/17/20
to Google Apps Script Community
Hi All, 

Recently I had applied for OAuth verification, and for the same, I had to share my project with their testers (ignore the security aspects of it for now) as my app is unpublished.

Even after installing it on their end (not sure how they do it), my add-on did not show up for them. 

My best , rather only guess is I was using createMenu instead of createAddonMenu which caused the issues. 

Any insights on what the problem could be?

Also I am not sure how the rest of you got it tested, there is another thread which mentions publish the add-on first and then apply for OAuth verification, but in my case my add-on was rejected as OAuth was not verified. 

Alan Wells

unread,
Aug 17, 2020, 11:10:43 AM8/17/20
to Google Apps Script Community
I would think that requesting OAuth verification for the Apps Script project before publishing a new add-on,
would be the way to go.
I haven't successfully published a new add-on listing recently, so I'm not sure if things have changed.
They should have seen the custom menu even if they didn't see an add-on menu.
If they didn't see a custom menu, then probably what is happening, is that there is a fatal error when your code is parsed by JavaScript, even before anything runs.  So, you can get a JavaScript error before any code even runs.
So, what happens is, that your code to build the menu never runs because there's an error before it can even run.
That can happen during the process when your code is being evaluated by JavaScript.
That's the "classic" issue for a menu not appearing for an add-on.
Now the question is, why did the error happen?
It could be an issue with a global variable.
Or the order of your files.
Are you using V8?  See your manifest appsscript.json file.

Andrew Apell

unread,
Aug 17, 2020, 11:21:46 AM8/17/20
to Google Apps Script Community
Those guys can be a bit robotic with their responses sometimes. I remember having a similar issue and kept asking for clarification but they just kept sending the SAME email as a reply!
Try using "createAddonMenu"  instead and see if it works for you.

Ravi Vyas

unread,
Aug 17, 2020, 11:36:57 AM8/17/20
to Google Apps Script Community
Not using V8, it has issues with JDBC. 

So, it runs fine for me, and another acount I have the project shared with, when I "test as Add-on" on a sheet. But since this is a Standalone project, there is no way to persist the add-on in the menu. I am thinking of actually giving them instructions to run the "test as Add-on" process. 

If there was a JS error, would the executions screen capture the error? 

Ravi Vyas

unread,
Aug 17, 2020, 11:37:18 AM8/17/20
to Google Apps Script Community

Yup, that is what I have done, and am keeping my fringers crossed.

Alan Wells

unread,
Aug 17, 2020, 11:47:36 AM8/17/20
to Google Apps Script Community
Even before V8 there were problems with add-on menus not being created.
For years people have had issues with the code running for them,
and then when someone else runs it, it doesn't work.
But, I'm not sure it that's your problem.
In any case, I'm interested in any information that you find.
You should have error handling in your code that is logged to Stackdriver.
console.log()
Look at your executions
for any failures.
Reply all
Reply to author
Forward
0 new messages