I've designed a Google Gadget based around using the Google Documents List API, the Google Spreadsheets API and the Google Visualization API. The gadget is designed for let users sign into their Google Account, using OAuth, list their spreadsheets in a certain folder, and then create visualizations based on the data within the first sheet of the selected spreadsheet (using a Google Visualization Query).
I want to use OAuth as I envisage the gadget being mostly used on iGoogle (and indeed multiple copies of the gadget on a page to enable visualization comparisons) so I don't want to have the user selecting/ typing in the cells to be used in the visualization from a spreadsheet like how common spreadsheet based visualization gadgets are shown. Some users though will prefer to keep their visualizations within their spreadsheets for quick access, rather than send them to iGoogle, since they will have many hundreds of spreadsheets. However, since the OAuth Proxy requires an OpenSocial container (iGoogle is one, Google Docs is not), my gadget does not work in Google Spreadsheets. What are my options? For the gadget to work on both iGoogle and Google Docs (Spreadsheets), do I have to roll my own OAuth solution without using the Proxy (examples would be great)? Or should I dispense with OAuth completely? If so, could I use AuthSub (which I believe gadgets may have issues with)? Or perhaps is there a way of programmatically identifying whether the gadget is within an OpenSocial container or not (iGoogle vs Spreadsheets) and then adjust my code to present different ways of selecting the data depending on the answer (using Documents List vs manually selecting cell range). I would really like for one gadget to work across iGoogle and Google Spreadsheets. All advice is appreciated.
-- You received this message because you are subscribed to the Google Groups "OAuth" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/oauth?hl=en.
