Need to download a Gsheet in csv format

Highlighted
Six Stars

Need to download a Gsheet in csv format

Hello,
I need your help on this.

I have several GSheet document on my google drive folder and I need to download this file into csv and then bring the data inside an oracle database in specific tables.

How can i proceed with this? I have already analyzed some links inside the forum but I have noticed that is a difficult topic.

Do I have to transform the document in a csv document, or can I connect and write on the db directly?

Thank you for your help.

Employee

Re: Need to download a Gsheet in csv format

Hi,

 

   Could you please try to use the APIs which Google is providing to fetch the data? Once the data is fetched to local using the API, you can use the filedelimited component to read and Oracle components to write the data.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch