I made a Google spreadsheet that uses some JavaScript in Apps Script to process the data into a flat format. I want to allow my partner and her coworkers to make their own copies of the spreadsheet to manage their classrooms. It helps them to save time and calculate grades.

How do I share this with them when these warnings pop up when they try to enable and run the JavaScript? Would I need to be verified in order to share this sheet or should I tell the coworkers to click "allow" despite the warning?

CodePudding user response：

It's not possible to completely remove the authorization prompt but you could make it appear only one time for each user by publishing your script as an Editor add-on.

1. Create a Google Cloud standard project (GCSP) and add the OAuth consent screen.
2. Link the GCSP to the Google Apps Script project.
3. Deploy the script as an Editor Add-on.
4. On the GCSP add the Google Workspace Marketplace SDK, configure it and publish to the Google Workspace Marketplace.

Related

• Deploy and use Google Sheets add-on with Google Apps Script
• Is it possible to publish an Add-on for internal use without approval process?
• Publish an add-on privately

Reference

• Authorization for Google Services
• OAuth Client Verification
• Publish an add-on

CodePudding user response：

It's just a routine security procedure. If they trust you, then there's no issue in them accepting it, it's just a warning if you don't know the coder