Sharing a Google Sheet with a script

[Karl Wurster]

Hello all,

I have a Google Sheet that is shared with three other users. I wrote several scripts which create a toolbar with buttons to allow easy use of the sheet and the automated creation of new Google Docs based on information in the sheet. I would like others to be able to use the toolbar, but when others try they get an error message, saying "Exception: No item with the given ID could be found. Possibly because you have not edited this item or you do not have permission to access it."

I asked another user (with editing rights) to try running the script manually (entered script editor --> selected function --> pressed run), but he got the same error. 

Does anyone have any advice on how I can solve this problem and allow the three other users to run the scripts?

Thanks for the help!

Karl

[Kim Nilsson]

You need to make sure all users have access to all referenced resources in the script, or have the script run as you, since you obviously have access to them.

Or, re-write the script so it doesn't use resources those other people don't have access to.

If people create a copy of your entire Sheet, then (I'm fairly sure) it can't run as you, as you are no longer part of the new Sheet. Then the script must absolutely  refer to resources that other user has access to.

[Arnie Michael Arazo]

Thanks for the answer, Kim. I did have the same problem with Karl. Now it's resolved thru your answer. thanks to you!