unable to fetch data using tGoogleSheetInput

[psujini]

Hi Team,

I would like to read the google sheet Using Talend Open Studio DI 7.1

I have downloaded the tGoogleSheetInput from Exchange and using it to read google sheet 

but it is throwing the following Exception.

Exception in component tGSpreadsheetInput_1 (GoogleSpreadSheet)
com.google.gdata.util.AuthenticationException: Error authenticating (check service name)
at com.google.gdata.client.GoogleAuthTokenFactory.getAuthException(GoogleAuthTokenFactory.java:553)
at com.google.gdata.client.GoogleAuthTokenFactory.getAuthToken(GoogleAuthTokenFactory.java:430)
at com.google.gdata.client.GoogleAuthTokenFactory.setUserCredentials(GoogleAuthTokenFactory.java:301)
at com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:324)
at com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:301)
at dpix.googlespreadsheet_0_1.GoogleSpreadSheet.tGSpreadsheetInput_1Process(GoogleSpreadSheet.java:658)
at dpix.googlespreadsheet_0_1.GoogleSpreadSheet.runJobInTOS(GoogleSpreadSheet.java:1118)
at dpix.googlespreadsheet_0_1.GoogleSpreadSheet.main(GoogleSpreadSheet.java:967)

I have been to many links for the solution.But i have no clue.

Please let me know any approach to read the google sheet data. attached the screen shots of the configuration i followed.

[Anonymous]

Hi
It is a custom component shared by community user on Talend Exchange, can you share the link of component which you have downloaded?

Regards
Shong

[psujini]

Hi,

Please find the below link that i have downlaoded from the link

https://exchange.talend.com/#marketplacesearch:gallery=marketplace%252F1&ob=releaseDate&o=0&c=20&d=t...

Please do the needful

Thanks.