tGoogleSheet – Talend Custom Components

• Source code
• Documentation

• tGoogleSheet version 1.0 – Direct download
• tGoogleSheet version 2.1 – Direct download
• tGoogleSheet version 3.0 – Direct download
• tGoogleSheet version 4.0 – Direct download
• tGoogleSheet version 4.1 – Direct download

* Service account or Application-Client-ID usable as authentication method
* Configure columns by the header row
* Tolerant Date parser used
* Create or use existing documents

* supports service accounts as well as application-client-ID as authentication method (2-factor)

tGoogleSheetInput
* has capabilities to configure the correct column position by the header line
* can parse dates tolerant

tGoogleSheetOutput
* Can create Google Sheet documents
* Can create sheets
* write into sheets

To read or write into existing documents these components expects the File-ID. To get this use tGoogleDrive (from Talend Exchange) or the build-in tGoogleDriveList (with less funtionality).

Release version: 2.1 – 2017-06-03 10:08:27
* Guave lib updated to prevent incompatibility with Google AdWords component
Release version: 3.0 – 2018-01-01 00:11:11
* tGoogleSheetOutput can write header row
Release version: 4.0 – 2020-11-10 18:51:49
* tGoogleSheetOutput improved: option added to take the input values just like the user would enter them in Google Sheets directly
* Dependency to log4j v1 replaced by using sl4j framework
* Updated Google APIs
Release version: 4.1 – 2021-01-28 10:23:27
* Improved check of type of authentication credentials
* Updated Google Sheet API

• 6.5 (retired)
• 7.0 (retired)
• 7.1 (retired)
• 7.2
• 7.3