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 and column in Google Sheets for syncing

Avoid making any changes to the first row during the initial sync, as this will cause sync issues.

• Rows

  • By default, Whalesync freezes the first row to preserve these fields.

  • After the initial sync, you're free to reorder rows or columns—just keep the first row unchanged.

• Columns

  • A hidden "Whalesync ID" column is automatically created in column A to track records. Whalesync adds this column to every tab within a sheet, even if it's not mapped in Whalesync. If syncing to an existing sheet with formulas, you may need to update your formulas to account for this.

  • Avoid editing the "Whalesync ID" column to prevent sync errors.

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 Columns

Foreign Keys in Google Sheets

Foreign Keys in Whalesync allow you to create relationships between tables in your synced Google Sheets. Here’s a quick guide on how to set them up and use them effectively 👇

Foreign Keys in Google Sheets

Video Guide