Four Stars

automaticaly read a google sheet everyday

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

  • Dataprep
2 REPLIES
Moderator

Re: automaticaly read a google sheet everyday

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

Four Stars

Re: automaticaly read a google sheet everyday

 

Hi,

 

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

Read.png

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

Auto-refresh Token.PNG

 

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.