automaticaly read a google sheet everyday

[Anonymous]

Hi, in the first place I would like to apologize if I don't post this topic at the right place.

I would like to read a google sheet everyday from my place "shared with me" (from my google account),

So my question is : how can I do that ?

I'm trying to use google API OAuth 2.0 Playground and the tGoogleSheet component but I've got the following failure : Error: redirect_uri_mismatch : The redirect URI in the request, http://localhost:63234/Callback, does not match the ones authorized for the OAuth client

and I don't know what i have to do..

I also have to use a previous Talend  version (6.3),  and I'm not sure that's the best way.

Do you have any idea ?

Regards

Hugo

[Anonymous]

Hi,

Could you please post your current job setting screenshots on forum which will be helpful for us to address your issue.

For your job requirement,  you can use a scheduler to read your google sheet everyday.

Best regards

Sabrina

[Anonymous]

Hi,

To read the content of the google sheet, I'm using this job.

And i'm trying to automatically  get the refresh token with the solution of this website :

https://www.rilhia.com/tutorials/using-oauth-20-talend-access-google-apis

But I have the error message "The connected components in a Job must not form a closed loop. Please check" and I don't know what i did different than his Job.