...
Google offers a general purpose , RESTful , web API for accessing Google sheets. We've tried using it and found it disarmingly complex. Recently we discovered a different approach. Google will host any number of custom web APIs. They provide a toolkit which enables the owner of a sheet to specify a custom web API for that sheet. The owner programs the API using the Google scripting language.
...