Skip to main content
Skip table of contents

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

  1. Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.

  2. Select Add Source > MS SQL..

How to Maintain Google Sheet Connections

  1. Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.

  2. Select a Google Sheets based Source Object on the Source Objects panel.

  3. Select Properties > Google Sheets.

Related Pages

v2023.07 ✅

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.