This collection of files serves as a simple static demonstration of how to post to a google spreadsheet from an external html <form> following the example by Martin Hawksey
You should be able to just open form.html in your browser and test locally.
However if there are some permissions errors you can make a quick html server with python. Open terminal and cd to the directory where the gist files are located and enter python -m SimpleHTTPServer. By default this creates a local server at localhost:8000
If you're using python 3 the command differs slightly.
The spreadsheet is located here
- [1] open your google spreadsheet doc
- [2] then select the Script Editor and copy google_script to script editor
- [3] select File > Manage versions
- [4] you need the authentication scope changes and to approve additional services. The easiest way to trigger this in this example is in the Script Editor Run > setup.
- [5] then going into Publish > Deploy as web app and updating Project Version