To sync Google Sheets using Bracket, each sheet must have a primary field column that contains unique values. This can be as simple as an integer, or more complex like a UUIDV4.
How to set up your primary key
For one-way syncs that read from Google Sheets, the primary key for any populated rows must have a static unique value. This value must never be changed, or data duplication can occur.
For all other sync configurations, the primary key must sync with a field in the opposing data source that is itself unique.
|Configuration||Primary key requirements|
|One-way sync from G Sheets||Primary key must be a unique, unchanging value, and identified as the primary key during setup|
|All other configurations||Primary key must be in the Bracket field mapping, must sync with a field of unique values in the op posing data source, and must be identified as the primary key during setup|