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:
If you have any feedback on Gathr documentation, please email us!