Creates and manages Source Objects that connect to Google Sheets.
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.
Spreadsheet ID. The value of the Spreadsheet ID comes from one segment of the Google sheet’s URL as shown in the example below.
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.
Change DataSource. Only shown when opened by Properties.
How to Add Google Sheet Connections
Select Add Source > MS SQL..
How to Maintain Google Sheet Connections
Select Properties > Google Sheets.
ETL+ for Google Sheets – a tutorial on extracting Google Sheets into a data warehouse.