Hi
I was searching the page and forum for this as I expected it already to exist: is it possible to use the Google Docs APIs to make a Google Spreadsheets input and output connector?
This would be a great thing to deal with as data in Google Spreadsheets can be easily accessed by non experienced users with different rights, visualized and even used in widgets that can be added to the users iGoogle page.
The connectors should support authentication. (can be done by post request to:
https://www.google.com/accounts/ClientLogin)
Input connector should be able to read from a spreadsheet by defining which spreadsheet and which cells to read. It would be nice if the connector would display the list of available spreadsheets for a configured account (GET
http://spreadsheets.google.com/feeds/spreadsheets/private/full including the auth token). As well the support for structured queries would not be necessary in a first version but nice to have.
Output connector should use the same parameters and allow to replace, update, remove and append data.
Documentation can be found here:
http://code.google.com/apis/spreadsheets/docs/2.0/developers_guide_protocol.html
Would be nice to see something like this for Talend.
Thanks
Regards
Ernst
