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