Any resource for this you can point me to?

There'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

I used this https://googlesheetjson.herokuapp.com

I wonder how long it will take before the tort lawyers can sniff this.