0

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?

Authorization to enable the js script

Google Unverified Alert

Rubén
  • 34,714
  • 9
  • 70
  • 166
Lacrosse343
  • 491
  • 1
  • 3
  • 18

2 Answers2

2

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

Reference

Rubén
  • 34,714
  • 9
  • 70
  • 166
1

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

Martín
  • 7,849
  • 2
  • 3
  • 13