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..
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema