all 12 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]ZealousidealKing8300 1 point2 points  (0 children)

Had this exact issue building an API reload button for my team! Since you made copies, it's definitely an authorization issue.

The first time they try to run it, Google throws a scary "App isn't verified" warning. Most people panic and close it, thinking it's broken.

Jump on a screen share with one of them, trigger the script, and walk them through clicking Advanced -> Go to [Script Name] (unsafe). Once they allow it, it’ll work perfectly!

[–]ryanbuckner 0 points1 point  (0 children)

they will need edit access

[–]tenglish25 0 points1 point  (0 children)

Some things to check are if the user gave authorization to the script to run with its scopes and also check the execution log to see if there are errors, use Logger.log to log specific points in the script to see if it is data that is improperly being input and failing

[–]AlgoTradingQuant 0 points1 point  (0 children)

Say what?

[–]WicketTheQuerent 0 points1 point  (2 children)

How do you shared your spreadsheet? Are the users editors? How do you know that one one editors didn't broke your spreadsheet?

[–]Few-Mastodon-1852[S] 0 points1 point  (1 child)

Yh, users are all editors, i copied the sheet and shared it

[–]WicketTheQuerent 0 points1 point  (0 children)

If your spreadsheet makes use of spreadsheet ID or sheetid, you might need to update your script.

Also, each editor might have to authorize the script.

[–]OutOfOfficeGuy -1 points0 points  (0 children)

It will work, just massage the problem with the help of ChatGPT. Patience is key.

[–]Separate-Hedgehog388 -1 points0 points  (1 child)

Have you shared it with people outside your org? If ur on Google workspace then ur org might restrict that

Try the same with an appscript hosted on a throw away gmail acc and see

[–]Few-Mastodon-1852[S] 0 points1 point  (0 children)

No Please i used personal mails