4 ms·
Fun idea. I learned recently that Sheets also works as a JSON service to post and get data if you have a static site and don't want to stand up a DB server.
by georgeoliver 9y ago
Fun idea. I learned recently that Sheets also works as a JSON service to post and get data if you have a static site and don't want to stand up a DB server.
- hckern3ws 9y agoAny resource for this you can point me to?
- andreyazimov 9y agoI used this https://googlesheetjson.herokuapp.com https://googlesheetjson.herokuapp.com
- georgeoliver 9y agoThere's a bunch on the web actually. The gist is that you create a Google App Script linked to your Sheet and deploy it publicly, which can receive GET and POST requests and respond as you like. See: http://chriszarate.github.io/sheetrock/ http://douglasduhaime.com/posts/crud-operations-on-static-file-sites.html https://github.com/liddiard/google-sheet-s3 https://www.johnastewart.org/coding/twine-game-data-to-google-sheets-via-javascript/ https://medium.com/@dmccoy/how-to-submit-an-html-form-to-google-sheets-without-google-forms-b833952cc175