Google Sheets ETL Source

Google Spreadsheet data source allows you to read data from worksheets of the desired spreadsheets.

Schema Type

See the topic Provide Schema for ETL Source → to know how schema details can be provided for data sources.

After providing schema type details, the next step is to configure the data source.


Data Source Configuration

Configure the data source parameters that are explained below.

Connection Name

Connections are the service identifiers. A connection name can be selected from the list if you have created and saved connection details for Google Spreadsheet earlier. Or create one as explained in the topic - Google Sheets Connection →


Spreadsheet Location

Option to browse and select a spreadsheet or a directory containing spreadsheet(s).


Select Worksheets

Preferred worksheets should be selected out of the listed ones from which the data will be read.


Header Included

Option to specify if any of the worksheets in the spreadsheet selected above contain first row as a header. Unchecked by default.


Select Worksheet

The preferred worksheet should be selected from which the schema will get inferred.

If “Any” is selected, then the worksheet with maximum columns will be chosen to infer schema. For all the other worksheets their first row will be considered as header.


Ignore Header

Option to consider scanning the first row as header for all the worksheets except the one selected to infer schema. Scan as data by default.


Infer Data Types

Option to infer data types from all worksheets and list them in the schema mapping. Unchecked by default.


Detect Schema

Check the populated schema details. For more details, see Schema Preview →


Pre Action

To understand how to provide SQL queries or Stored Procedures that will be executed during pipeline run, see Pre-Actions →).


Notes

Optionally, enter notes in the Notes → tab and save the configuration.


Google Sheets Usage Limits

To understand the usage limits that apply to Google Sheets, please refer to the link below:

Google Sheets Usage Limits.

Top