Google Sheets
Supported Fields
Field | Status |
---|---|
π Text | β
Supported |
π’ Number | β
Supported |
π Date | β
Supported |
#οΈβ£Percentage | β
Supported |
π° Currency | β
Supported |
π§ Email | β
Supported |
π Drop-Down | β
Supported |
π³οΈ Checkbox | β‘οΈ Supported (1-Way) |
Things to Keep in Mind
Whalesync uses the first row in Google Sheets to map fields
Avoid changing the first row of Google Sheets, as this will cause sync issues.
Since the first row contains column headers in Google Sheets, changes to it may cause sync issues. To prevent this, freeze the first row by clicking View β Freeze β 1 row.
A βWhalesync IDβ column is automatically created to track each record
You can sort rows, and the Whalesync ID will follow. Avoid deleting or editing the Whalesync ID column unless removing a row.
Formatting in Google Sheets
For Whalesync to allow a 2-way sync, both fields must have matching data types. Read below for how to format Sheets columns π
Formatting Google Sheets ColumnsVideo Guide
Last updated