topic Re: Pull data from google sheet and load into postgres DB in Talend Studio

Pull data from google sheet and load into postgres DB

Anonymous — Sat, 16 Nov 2024 05:04:21 GMT

Currently, I want to pull data from google sheets, alter it with tMap and then load it into a postgres db. I am using tGoogleDriveConnection and then tGoogleDriveGet to retrieve the csv. However, I can't figure out how to use tMap because when the file is loaded, it doesn't have any column structure--it just says "content". Does anyone know how I may be able to load the data in correctly?

Re: Pull data from google sheet and load into postgres DB

Anonymous — Wed, 07 Aug 2019 04:14:12 GMT

Hi,

The tGoogleDriveGet component will only help you to get the file from Google Drive to your local machine at a directory of your choice.

Once the file is available in your local, you need to read it like any other file from local using file components. For example, if its a csv file, use a tFileInputDelimited to read the file present in the local folder. You need to provide necessary schema details in this File Input component.

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

Re: Pull data from google sheet and load into postgres DB

Anonymous — Wed, 07 Aug 2019 15:55:56 GMT

Hi Nikhil,

Thank you for your response! ~~I made a little progress with your tip; however, now I am getting an error on my tGoogleDriveGet that says "invalid escape sequence". Do you know what may be creating this error?~~

Fixed it!

Re: Pull data from google sheet and load into postgres DB

Anonymous — Wed, 07 Aug 2019 16:06:00 GMT

Cool!

Could you please mark the topic as resolved so that it will help other Talend community members?

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

Re: Pull data from google sheet and load into postgres DB

LP1645818833 — Fri, 04 Mar 2022 19:36:34 GMT

Hi @Richard Hall ,

Do we have any inbuilt tGoogleSheetInput connector in TOS -BD ? I want to read data from Google sheet and load it into DB. I can''t find any on TOS -BD v8.