I'm having terrific success reading the contents of a published spreadsheet via javascript (using the alt=json-in-script parameter, to get the data as json), and would like to learn how to create and update the contents of a spreadsheet via a similar mechanism. It doesn't look like the javascript client library is either up to date or supports the spreadsheet api protocol, so that seems like it is a no-go. I have spent a few hours googling my problem, but I haven't found a good starting point.
My end goal is to provide a javascript powered website that prompts the user for whatever authentication is necessary, and then performs spreadsheet creation and updating on behalf of the user based on the data in the site. I have seen there are Java/PHP/etc client libraries that can do this, but I'm not looking for a server-side solution- I want this to be entirely possible via client side code. What is the best place to start, here? Should I look further into the javascript client library, even if just for the authentication stuff? I have heard that there is the potential to create a google "Form" that I can create and call that offers integration into the spreadsheets API; is that possible to access entirely with client code? Is there something else I should look into? Any help is appreciated.
