Hi to All, I want to use google SpreadSheet as a back end database for a simple registration form, at a simple web page for people joining an event.
My first attempt was to use Google Scripts and after bind it with a spreadsheet and publish it as a webapp with the doGet() add the data from the javascript request. The problem I faced with this approach is the CORS issue. Apparently google drive/docs, don’t permit CORS requests so I decided to go through the Google spreadSheet API. Now, the problem is that I got a bit confused with the spreedsheat API. So I have some questions: 1.) First is it possible to manage to send data to a spreadsheet from an external web using the API? 2.) Authenticating is obligatory? Cant I just publish the spreadheet and use the API to add data to the cells? 3.) If Authentication is obligatory, is it possible always to authenticate with the same user? so any time somebody sends the form, the authentication happens on the background so the user just need to push the "send" button? 4.)Finally I am not sure that, what i want is possible anyway. So please if someone has done it, please give me a short guide on how to do it. I can use Java, with Java Spreadsheet API (the back-end of the site is Java), or javascript (front -end). 5.) It will be grate if you can point me out an example or something similar that I can use as an idea. Thank you -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
