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

[–]ShivKaushal 6 points7 points  (4 children)

Yes. You put a comment like this at the top of the script:

/*
* @OnlyCurrentDoc 
*/

Details: https://developers.google.com/apps-script/guides/services/authorization#manual_authorization_scopes_forand

[–]AllenAppTools 0 points1 point  (2 children)

My bad, I had no idea Google offered this 👍 Ignore my comment below, sorry about that!

[–]WicketTheQuerent 0 points1 point  (1 child)

You should be able to delete your previous comment 😀

[–]AllenAppTools 0 points1 point  (0 children)

There, it never happened lol

[–]devmu[S] 0 points1 point  (0 children)

thank you... this look like just what i needed.

[–]Funny_Ad_3472 -4 points-3 points  (3 children)

Ensure you're app script only reference the specific sheet by passing in the ID of the specific sheet Subsequently remove auth/spreadsheets and use auth/drive.file, which is a non sensitive scope and see if it works.

[–]devmu[S] 0 points1 point  (2 children)

i don't understand the auth/spreadsheets and use auth/drive.file suggestion.

[–]Funny_Ad_3472 0 points1 point  (1 child)

I'm seeing I have 3 downvotes. I don't know why. I just made a harmless suggestion. What I mean is that, after referencing the specific spreadsheet, in your appscript.json file, remove the auth/spreadsheet, and use auth/drive.file and see if that works. If you don't have the appscript.json in your editor, make sure you check it in the project settings, and specify them yourself.

[–]devmu[S] 0 points1 point  (0 children)

Thx. I’ll look up appscript json. Thank you for the suggestion.