Eliminate the "Google hasn’t verified this app" warning for App Scripts authorization

Google Workspace Developers Q&A
1

When I create a new google sheet programmatically and then I share that sheet with a customer, when they open it up they need to click on my custom menu item, which prompts them with this message:

“Authorization required
A script attached to this document needs your permission to run.”

And then when they attempt to authorize the script, they are presented with a warning page that says this:

“Google hasn’t verified this app
The app is requesting access to sensitive info in your Google Account. Until the developer (myemailaddress) verifies this app with Google, you shouldn’t use it.”

This makes my custom google sheet feature completely unusable for real world customers, I cannot have this warning message displayed to them when they go to authorize the script. Is there any possible way to eliminate this warning message?

2

Devin, if you need someone to validate your frustration, I have over 29 screenshots that gave ppl that were using my app script a heart attack thinking I was scamming them. I love GAS - I literally use GAS everyday (hope this made you laugh) but I hate seeing how conditioned I have gotten to go through those annoying steps of google hasnt verified app.

3

Thanks for your feedback. So I assume you were never able to find a solution to the issue? Were you able ever to get the warning screen to go away for users?

4

Unfortunetly I did not.
Sorry didn’t mean to give you hope.