Google Sheets Ingestion Source

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

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 →

Use the Test Connection option to ensure that the connection with the Google Spreadsheet channel is established successfully.

A success message states that the connection is available. In case of any error in test connection, edit the connection to resolve the issue before proceeding further.


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

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.


Add Configuration: Additional properties can be added using this option as key-value pairs.


More Configurations

Infer Data Types

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


Schema

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


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