Google Appscript makes the impossible happen in your spreadsheet through coding. Before you can run a custom script, you need to authorize access. The first time an individual uses a script (usually in the form of a custom button or custom menu) it will ask for authorization. You should only have to do this once unless you log in from a new account, lose or regain access to the file or if the script gets edited. Follow these steps to authorize it:
- You will get a pop-up that says “Authorization Required” Click Continue
- Select the account you are using to access the document
- You’ll get a warning message that says “Google hasn’t verified this app” Click Advanced
- It says continue only if you trust the developer. Select “Go To [name of code file] – unsafe”
- From there it will tell you what allowing this app will do. Click Allow (you may have to scroll down to find the button)
- Now try the button or menu item again. This time it should run smoothly.
Alisa Ediger 