topic Read data from Google Spreadsheet in Talend in Talend Studio

Read data from Google Spreadsheet in Talend

Anonymous — Wed, 01 Jun 2016 11:07:39 GMT

Hello Team,
I want to use Google Spreadsheet as a source in my Talend Job.
So, how to connect and read the data from Google Spreadsheet?
I found one custom component "tGSpreadsheetInput", I downloaded and tried to install it but it is not appearing under Pallete. Seems to be the compatibility issue, I am using 5.5 version.
If direct component is not available then, can we download the google spreadsheet in the form of excel and then I can use excel as source. Please tell me how to establish the connection to google drive and download the spreadsheet?

Re: Read data from Google Spreadsheet in Talend

Anonymous — Thu, 02 Jun 2016 03:39:49 GMT

Hi,
Could you please refer to a related forum: http://community.talend.com:80/t5/Design-and-Development/tGoogleDriveGet-can-t-download-Google-Spreadsheet/m-p/18097#M2043 to see if you can download a CSV of the google spreadsheet using tFileFetch?

Let us know if it is Ok with you.
Best regards
Sabrina

Re: Read data from Google Spreadsheet in Talend

Anonymous — Thu, 02 Jun 2016 20:49:20 GMT

So, is it not possible to directly connect to the Google Spreadsheet and use it as source to fetch the data in the job?

Re: Read data from Google Spreadsheet in Talend

Anonymous — Thu, 02 Jun 2016 21:04:02 GMT

Well it depends VinT. How is your Java? This can be done using the APIs provided by Google. You will just need to implement them yourself. Check out https://developers.google.com/sheets/