Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Not able to download a Google Drive sheet into Talend

Hi,
I'm currently having issues downloading a GoogleDrive sheet into talend.
I'm using the following steps in Talend: tGoogleDriveConnection-->tGoogleDriveGet-->tLogRow
Talend is connecting well with Google drive, however, it fails once it reaches to the tGoogleDriveGet step. See error message in the screenshot attached.
Please Advise.
0683p000009MAmo.png 0683p000009MB20.png 0683p000009MB25.png
Labels (2)
7 Replies
Anonymous
Not applicable
Author

Hi,
There is a excel file in the root directory of Google Drive? Could you please give us more information about your Google Drive?

Did you follow up the scenario "Obtaining an access token for Google Drive" in component reference: TalendHelpCenter:tGoogleDriveConnection?

Best regards
Sabrina
Anonymous
Not applicable
Author

Hi,
Name of File: 'GoogleSheetsTest' is the name of an excel file in my google drive which I wish to download to Talend. Am I supposed to put something different here?
Also,
I did follow all the instructions on TalendHelpCenter:tGoogleDriveConnection.
My connection to google drive is successful. I have been able to successfully list my google drive files in talend by using the steps tGoogleDriveConnecion-->tGoogleDriveList-->tIterateToFlow-->tLogRow. 
Now where I'm having issues with is to actually download these files from google drive to Talend.
Please Advise.
Anonymous
Not applicable
Author

Sabrina,
Here is the link to my google drive document: 
https://docs.google.com/spreadsheets/d/1ehVbgPl1wS6-YdsiF1pKnc6mCweSnmuPkPVAmGStEnk/edit?usp=sharing
root directory: My Drive
Anonymous
Not applicable
Author

Hi,
Did you solved your problem ? I've got the same issue ! I can successfully connected to the drive (tcreate and tlist works) but can't manage to use tget...
Anonymous
Not applicable
Author

FYI , I've created a Jira issue ticket
https://jira.talendforge.org/browse/TBD-2858
Anonymous
Not applicable
Author

Hello, is there any update on this issue?

 

Anonymous
Not applicable
Author

Hello, 

I'm trying to create a pipeline to extract data into MySQL from a Google Sheet. I came across this component "tGoogleSheet" in Talend Exchange. 

That may help..