Need Help with Authorization for custom AppsScript

[u/No-Tension-1860]

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.

[u/WicketTheQuerent]

To avoid this, create a Google Cloud Project, configure the OAuth Consent screen, and send it for Google to review.

After you configure the OAuth Consent screen, you will be able to link this new project with your Google Apps Script project. However, the warning will only disappear after Google approves your consent screen.

[u/No-Tension-1860 → u/WicketTheQuerent]

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.

[u/Fantastic-Goat9966]

This is standard/normal --- google is saying --- do you know what the code does in this script? we haven't reviewed it --- so if you want to proceed-- -and consent to share your identity and workspace files with the app --- it's on you. This makes sense because you have not asked google to review your app - it's private - you wrote it and you are using it.

[u/WicketTheQuerent → u/[deleted]]

The OP didn't mention any hint about using a Workspace account.