Google Spreadsheets to Database

In this ETL example we will create a Data Interface to extract Benefits data from a Google Spreadsheet and load it into a Database. Refer to the attached data integration video on the steps involved in setting up a data interface between a source and target application.

The JDBC URL in the DB Info activity to configure the Google Spreadsheet connection uses the following format:

jdbc:googlesheets:user=myuseraccount;password=mypassword;Spreadsheet=SpreadsheetName


The GoogleSpreadsheet Driver is already bundled with the product. Select this driver from the Database Driver drop-down list as shown in the video

Have more questions? Submit a request

0 Comments

Article is closed for comments.