Is there any way to have an end-user application that doesn't require a oauth certificate the way you created? I'm attempting to write some software now that would benefit from allowing people to keep data in Google Spreadsheets.
If you're going to be accessing user data, you need to be using oath authorisation. There are other ways to handle it but after a lot of research and trial and error, in the end this was the best way I found.