Setting up your Google Sheet
To sync Google Sheets using Bracket, there are three basic requirements:
- The field names must start at row 1. There can be no extra rows above the table.
- The field names must be unique across the table, even among fields that are not syncing.
- The sheet must have a primary key column that contains unique values.
Setting up your sync
On the “New Connection” page, click “Connect new spreadsheets”. Enable Bracket permissions on the Google oauth page.
Back on the Bracket web app, select the spreadsheet name and sheet title.
Enter the name of the Google Sheet primary key. This field will uniquely identify rows in your sheet, and the values in this field should not be changed over time.