Note: Logger class does not work in an event handler.
I used the GUI Builder to create the simple interface:
Just make sure you set the parameter to be passed in the event handler. See the following stackoverflow item for more detail:
Like magic you have a web application. To see it in action go to the following public URL:
And you can see the spreadsheet that is modified by this script at the following public URL:
For some fun, open the app in one tab and open the spreadsheet in a separate window. You can modify the value in the application tab and watch the cells change in the spreadsheet. This is a view-only spreadsheet, but it is being modified by the web application.
Next up is writing a script to pull info from Google Analytics since I need to do some combining of statistics from there regularly for work.