Share a Google App Script to other users - permission requested & authorize script

BeNdErR picture BeNdErR · Jul 8, 2014 · Viewed 10.9k times · Source

I've created a spreadsheet with some GAS behind it that opens a form with some inputs, and now I need to deploy the webapp and share it to some other users. The problem is that when the other users try to open the spreadsheet (shared in Google Drive), they get this error message:

enter image description here

I've already tried to:

  1. Share the spreadsheet to the user/s (Adding the user/s email address with permission Can edit)
  2. Deploy the webapp settings with the following settings:

enter image description here

As you can see, the setting screen reports "You need to authorize the script before distributing the URL".

How can I authorize the script? I can't find a way to do that. Do you know if there's another way to share and let other users run the script?

Answer

waterscar picture waterscar · Mar 11, 2015

Since you selected to execute the app as you, you need to authorize this script first.

Just select method doGet and press run in the editor, you will get the chance to authorize.