Post to google spreadsheet from html form
February 20, 2020 ยท View on GitHub
Overview
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
Depreciation Warning: This code is not maintained, and should be seen as reference implementation only. If you're looking to add features or update, fork the code and update as needed.
Run example
You should be able to just open index.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.
Google Spreadsheet
The spreadsheet is located here
TODO
- Resolve 405 Error on Safari
- Workaround for 405 error with Safari browser check
- Add user feedback while ajax is submitting the request
- Validation using Bootstrap Validator