automaticaly read a google sheet everyday

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch