Google Sheets
Follow our setup guide to connect Google Sheet to QUANTI:
Last updated
Was this helpful?
Follow our setup guide to connect Google Sheet to QUANTI:
Last updated
Was this helpful?
To connect a Google Sheet to Quanti:, you need to access a Google Drive account and have edit access to the Google Sheet you want to use.
Open your Google Sheet and select the range that you want added to your destination. You can change your selected range later if needed.
To select a range, you can do either of the following:
manually select the range as shown below, or
select just the columns (for example, Sheet1!A:D). If you select just the columns, Fivetran only creates rows for up to the final row that has values in your sheet (for example, Sheet1!A1:D6).
You can have as many named ranges as you would like in a single Google Sheet workbook. The first row of the named range will become the column headers in the destination table in your destination.
In your Google Sheet, go to Data > Named ranges.
In the Named ranges menu, enter a name for your new range and click Done.
Connect your Google account to permit Quanti: to access to your data
Connector information
Connector Name : Name your connector. It must be unique.
Dataset ID : Define the ID of the dataset. It must not exist yet, as it will be created and data will be sent there.
Settings :
Copy and paste the sharing URL of the Google Sheet and click Test URL.
Select the named range you want to sync.
The insertion method used is DELETE+INSERT mode, meaning the entire content of the table is overwritten and replaced, whether or not the data has changed.
The schema is directly mapped from the named range in your Google Sheet. It is derived from the first row of the named range.
During each synchronization with Google Sheets, this first row is used as the reference. If new columns—previously absent from the schema—appear in the first row, the connector will update the destination table’s schema to include them.
Conversely, if columns that were part of the original schema are no longer present in the named range, they will remain in the destination table but be left empty.
We also apply light standardization to column names:
Spaces are replaced with underscores
Uppercase letters are converted to lowercase
In short, we convert all fields to camelCase to ensure consistent and compatible naming.
Field types are automatically inferred based on the values present in each column of the Google Sheet.
The supported types are:
Date: if the column contains only dates in the YYYY/MM/DD format
Float: if the column contains only numeric values (integers or decimals)
String: for all other types of values
For compatibility purposes, all numeric fields are automatically converted to FLOAT.
