CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetspermissions
Ujwaldeep Singh
Ujwaldeep Singh

Reputation: 61

"Something went wrong" while running the App Script from Google sheets

I have a google sheet and created an app script by clicking on the extensions -> "Apps Script". I imported the App Script in the Google sheets using Macro -> "Import Macro" and thus triggered it with the click of a button.

Everything works ok but when I share this sheet with editor access to a Microsoft account, the Microsoft account indeed can edit the content of the sheet but is not able to run the app script by clicking on the button.

First of all, sheet requests the permission to run the app script].

After clicking "Continue" it results in the error "Something went wrong".

enter image description here

Does Google not allow the running of scripts by a non-Google account user? Is there any way to allow non-Google / workspace users to run the script?

Upvotes: 0

Views: 1389

Answers (1)

Rafa Guillermo
Rafa Guillermo

Reputation: 15375

Does Google not allow the running of scripts by a non-Google account user? Is there any way to allow non-Google / workspace users to run the script?

Short answer is no.

Longer answer is that in order to run a script the script needs to be authorised to run as somebody. If the person doesn't have a Google account then there is no account to authorise the script and so it can't be run.

Upvotes: 1

Related Questions