Breadcrumbs

ETL+ Source Driver for Google Sheets

Creates and manages Source Objects that connect to Google Sheets.

v2026.01

image-20250129-005737.png
Source Objects panel toolbar

Add Source: New Google Sheets connection.

Properties: Maintain Google Sheets connection.

Refresh: Update Google Sheet metadata.

Google Sheets Page

  • image-20260218-052235.png

    Alias will be automatically populated, but you can customize it.

  • Schema: Check this box if you want all target tables from this source to be assigned into a SQL schema named <Schema Name>.

  • Spreadsheet ID: Insert a link to a Google Spreadsheet.

    • The value of the Spreadsheet ID comes from one segment of the Google sheet’s URL as shown in the example below.

      image-20250906-220928.png
      The segment in yellow of URL should be copied into Spreadsheet ID.

  • Target (optional): Enter the name of a single Google sheet, also known as a worksheet or tab.

    • To connect to all Google spreadsheet tabs, leave Target (optional) empty.

    • To connect to a single spreadsheet tab, enter the sheet name in Target (optional).

    • Specifying a single Target may resolve connection problems.

  • Device: By default, leave it as Master Device.

  • Save: You can save the configuration without attempting to connect it.

  • Click Connect.

image-20230813-001241.png

Help
image-20230813-001426.png

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 image-20250128-231532.png > Google Sheets

  3. See the documentation above for the Google Sheets page.

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.

NOTES

Google Speadsheets, Sheets and Worksheets.

Google Sheets is the Cloud application for creating spreadsheets

A Google Spreadsheet is an entire file.

Each Sheet in a Google spreadsheet is a tab. There can be one (minimum) of more Sheets in a spreadsheet.
– https://support.google.com/docs/thread/40407678/what-is-the-google-sheets-name-for-what-excel-calls-a-workbook?hl=en

  • Sheet, Worksheet and Tab may be used interchangably in documentation.

  • Documentation often doesn’t explicitly explain the terms.