Essential Attributes and Supported Table for Google Sheets
Essential Attributes and Supported Table for Google Sheets
In this article, we will look at the essential attributes and tables supported by the Google Sheets connector.
Find the links to other articles related to Google Sheets below:
Essential Attributes
| Features | Details |
| Release Status | In-dev |
| Workbook Selection | Yes |
| Table Selection | Yes |
| Column Selection | Yes |
| Edit Integration | Yes |
| Replication Type Selection | Yes |
| Authentication Parameters | Google docs Id and password |
| Replication Type | Full Load Replication |
| Replication Key | Datetime |
| Suggested Replication Frequency | 24hr |
Tables
Each selected sheet of the selected workbook will form a table in a warehouse with '_' as its name to differentiate.
Fields
Column header names with non-empty values will form column names in a warehouse, in other cases generic header (A..D..AB..) will act as column name.
The datatype for every column is STRING.