One Star

Google Spreadsheets connector

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
13 REPLIES
One Star

Re: Google Spreadsheets connector

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
Employee

Re: Google Spreadsheets connector

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

Thx
Employee

Re: Google Spreadsheets connector

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.
One Star

Re: Google Spreadsheets connector

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.
Employee

Re: Google Spreadsheets connector

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
One Star

Re: Google Spreadsheets connector

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.
Employee

Re: Google Spreadsheets connector

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.
One Star

Re: Google Spreadsheets connector

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.
Employee

Re: Google Spreadsheets connector

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
One Star

Re: Google Spreadsheets connector

Hi Thomas,
thanks for that.
I am following that because you are doing perfect work for Talend.
As far as I know only Business Objects with their Labs is offering google spreadsheet connector.
This makes Talend very competitive product on the market.
Looking forward to more news from you soon.
Kind regards,
Marcin K.
One Star

Re: Google Spreadsheets connector

Hi Thomas,
I hope you are well.
Did you have a chance to make any progress?
Thanks,
Marcin K.
One Star

Re: Google Spreadsheets connector

The component seems fantastic but it doesn't work for me...
I put the login/password, the spreasheets key and the Sheet.
When launching, it stays in "Starting", and after 20 seconds, I've got a "AuthenticationException"... :-(
Any suggestion ?
Regards, Nekloth
One Star

Re: Google Spreadsheets connector

Hi,
I downloaded and tried to use this component in Talend version 4.2.2 (http://www.talendforge.org/exchange/tos/extension_view.php?eid=122&rid=149#rev149). But it does not show up in the category after restarting talend. I have copied all the relevant files at suggested location in the forum.
Is is compatible to this updated version ?. If not how can i make it compatible to this version.
Thanks
Vaibhav