ETL+ Source Driver for Google Sheets
Creates and manages Source Objects that connect to Google Sheets.
Source Objects panel toolbar
Add Source: New Google Sheets connection.
Properties: Maintain Google Sheets connection.
Refresh: Update Google Sheet metadata.
Google Sheets Page
Alias name. The name for the source object shown on the Source Objects panel.
A source object name will be automatically populated. Customize as desired.Schema.
Spreadsheet ID. The value of the Spreadsheet ID comes from one segment of the Google sheet’s URL as shown in the example below.
Segment of URL to copy to Spreadsheet ID.
Target (optional). Name of Google spreadsheet.
To connect to all Google spreadsheet tabs leave Target (optional) empty.
To connect to a single spreadsheet tabs enter the sheet name in Target (optional). ,
Back. Leave the page without saving or attempting to connection.
Connect. Connect to the source database.
Save. Save the configuration without attempting to connect.
 | Help |
 | Change DataSource. Only shown when opened by Properties. |
How to Add Google Sheet Connections
Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.
Select Add Source > MS SQL..
How to Maintain Google Sheet Connections
Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.
Select a Google Sheets based Source Object on the Source Objects panel.
Select Properties > Google Sheets.
Related Pages
ETL+ for Google Sheets – a tutorial on extracting Google Sheets into a data warehouse.
v2023.07 ✅