Google Spreadsheets connector

[_AnonymousUser]

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

[_AnonymousUser]

Maybe would be more straight forward to use the Java Client library:
http://code.google.com/apis/spreadsheets/code.html
For Perl there is no such thing as I understand

[Anonymous]

Hello,
You can report a feature request on our bugtracker.

Thx

[Anonymous]

Ah, I was not aware of this forum post. I just released a component on Talend Exchange which is exactly what you seem to look for. tGSpreadsheetInput: 122
An output-pendant is not finished due to either the lack of documentation or functionality of the gdata-API; I could not find how to create a spreadsheet from ground. I can only append rows to existing worksheets, which is not what I would want to do with such a component.

[Anonymous]

Thomas,
thanks a lot for your new component. You did excellent work and you show that Talend rocks and offers features not available in any other ETL software.
I would suggest to be able to put start and finish (optional) corners with data from google spreadsheet. This would allow people to read data from tables inside spreadsheets and not only raw data.
I am also looking for first release of output component, even if it doesn't create a new spreadsheets at the beginning then it will be huge step forward for many people who use Talend as Business Intelligence component and Office 2.0.
Once again, thanks a lot for your hard work!
Kind regards,
Marcin K.

[Anonymous]

Thanks,
I will improve the component, for sure. And I'll have a deeper look into the Output-thing. But it'll take I while.
Bye Thomas

[Anonymous]

Hi Thomas,
did you have a chance and spend some more time on google spreadsheets connectors?
do you need any help with it?
Kind regards,
Marcin K.

[Anonymous]

Hello Marci,
Sorry, but due to lack of time I did not even touch that component once.
I'm not quite sure, what your help could look like. If you could find a way, to create a sheet without having to upload row CSV-data that would be good. I haven't done so yet.

[Anonymous]

Thomas,
do you think it is possible for you to create an empty CSV file with headers only on the fly within Talend and upload it?
I found that this is the only was possible at the moment.
If not then maybe you can do without a creation of a new spreadsheet?
People could create them before, specify its name in component parameters and put data into it.
How about that?
Kind regards,
Marcin K.

[Anonymous]

Thomas,
do you think it is possible for you to create an empty CSV file with headers only on the fly within Talend and upload it?
I found that this is the only was possible at the moment.

I think this will be the way to go, in order to create new worksheets. Though, I'd prefered a more sophisticated solution.

If not then maybe you can do without a creation of a new spreadsheet?
People could create them before, specify its name in component parameters and put data into it.
How about that?
Kind regards,
Marcin K.

You are driving me towards doing it. 🙂 I won't resist much longer, but give me some more days.
Regards,
Thomas