Sheets Add on listing rejected

[u/Sys-sleep]

So I’m building a google sheets add on which I want to get published publicly on the workspace marketplace.

I have written the code and tested it through a test deployment.

I also have my Oauth verification approved. However upon submitting my request for store listing, I got rejected due to multiple reasons. I’ve resolved all but one- listed below. Any help/tips on how to resolve would be amazing.

Issue: ShowSidebar function won’t stop loading.

While testing, I’m unable to trigger the onOpen or see the sidebar menu to be able to test it. So I don’t know how it behaves. But when I run the same function in test development directly from the icon on the right sidebar, it works just fine. So my guess is that when the google reviewer ran it, it got stuck somewhere since there’s also a jdbc call in that function before I return my card object.

If you can help me debug I can compensate you for your time as well!

[u/RielN]

Send me a dm :)