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)

⚠️ Before syncing Google Sheets

Some things to note before turning on syncing.

Sheets (tabs)

Whalesync uses the name of a sheet (i.e. tab in a workbook) for syncing.

Avoid changing the name of a sheet after setting up your sync. This will break the sync configuration.

Rows

Whalesync uses the first row to enable syncing with Google Sheets. By default, Whalesync freezes the first row to preserve these fields.

Avoid making changes to the first row during the initial sync.

This will cause sync problems as Whalesync uses that row to sync your data.

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

Columns

Whalesync uses the first column, normally hidden, as a "Whalesync ID" to enable syncing with Google Sheets. This column is automatically created in column A to track records.

You are free to rename columns after setting up a sync.

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

Other things to note

Do not use "Sort range" on sheets that are syncing! This will cause sync problems as it changes the row IDs.

---

How to format field types👇

Formatting columns

How to add foreign key fields 👇

Foreign keys

Video Guide

A quick video demo for how to sync Google Sheets and Airtable