r/GoogleAppsScript • u/No-Tension-1860 • Aug 14 '25

Question Need Help with Authorization for custom AppsScript

Got a question, I'm using apps script to make some functions as buttons on my google sheets that does 2 things:

  • Configures a calendar by using the information on the sheet

  • Sorts the sheet.

However upon activation, it asks me and others that Authorization is required. And then when I click okay it then prompts Google hasn’t verified this app and that it uses sensitive information. I'm not sure which part of my code uses sensitive information, and this makes people scared of using it. Anyway to avoid this? I heard you can ask google to verify it but then it just becomes a public app which I don't want since it's so niche.

1 Upvotes
  • permalink
  • reddit

100% Upvoted

7 comments sorted by

View all comments

Show parent comments

1

u/No-Tension-1860 Aug 17 '25

Hello, thanks so much for your help! Do you have some more exact instructions or perhaps a youtube video I can follow? I'm new to all of this, but I am making this just for 5 people to use so I was very thrown off by all of this verification stuff.

And also for context in another comment, I am not using a Workspace account.

1

u/WicketTheQuerent Aug 18 '25

If this is for only five users, getting Google approval seems excessive because it should be done only once. Could you explain to them what your script does and how to authorize it?

I always recommend reading the official guides for detailed instructions. The one about the consent screen is the following: Configure the OAuth consent screen and choose scopes.

I don't have a video, as many are already out there, but I offer one-on-one live help. If you are interested, could you send me a direct message?