TransWikia.com

Sharing a Google Sheet that has Script

Stack Overflow Asked by ALA Math on December 25, 2021

I am a teacher preparing for distance learning. Google Forms are awesome, but they have some limitations. I created an old school google form with google sheets to get around a few issues I was having. I used the script from this data entry form

It works great! …but I’m worried my students won’t use it since they will get a warning that says "This app isn’t verified." I know for a fact that my students will not click on the "advanced" button to authorize the app.

Is there a way around this?

One Answer

Answer:

This screen can't be removed without app verification.

More Information:

As per the unverified apps page:

An unverified app is an app or Apps Script that requests a sensitive or restricted OAuth scope, but hasn't gone through the Google verification process. Users of unverified apps or your test builds might get warnings based on the OAuth scopes you're using. This is to protect users and their data from deceptive apps.

It's designed this way to stop tricky people with tricky apps blindsiding people by getting them to approve sensitive scopes without too much thought.

Unless you want to verify your app, which will need to be done through the GCP console (instructions on verification can be seen here), your only way around this is to just tell your students to click on the "advanced" button to authorise the app.

Side note: Verification is not required for Apps Script projects whose owner and users belong to the same G Suite domain or customer.

Further Reading:

References:

Answered by I hope this is helpful to you on December 25, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP