I am adding a script to a Google Sheet to allow me to make multiple selection from a drop-down list. I got the code from Github. It is saying "an Apps Script from this document needs your permission to run" and then it asks me to sign in to my google account and then gives me a "Google hasn't verified this app" warning. What can I do?

CodePudding user response：

The script most likely uses an onEdit(e) simple trigger. Do not run the code in the script editor. It runs automatically when you hand edit the spreadsheet.

CodePudding user response：

That is a part of the authorization process which you need to accept to continue. Once accepted your script runs. As said by @doubleunary you will need to put the script inside onEdit(e) trigger so that your function runs when you select any 'second' or later input from the dropdown.