LogoLogo
WelcomeGet Started
  • What is Whalesync?
  • Start Here
    • Quick start
    • Video tutorials
  • Popular Syncs
    • Webflow + Airtable
    • HubSpot + Notion
    • Supabase + Airtable
    • Notion + Google Sheets
  • Connectors
    • Affinity
      • Authorize Affinity
      • Full records vs. shallow records
      • List-specific fields
      • Notes in Affinity
    • Airtable
      • Airtable view sync
      • Airtable API quota
    • Attio
    • Google Sheets
      • Formatting columns
      • Foreign keys
      • Multi-select fields
      • Avoid sort range
      • Whalesync ID column
    • HubSpot
      • Associations
      • Webhooks
      • Merging records
    • Memberstack
      • Authorize Memberstack
      • Memberstack custom fields
    • Notion
      • Notion page sync
    • Postgres
      • Authorize Postgres
        • AWS (RDS)
        • Basedash
        • DigitalOcean
        • Heroku
        • Neon
        • Render
        • Supabase
      • SQL scripts
      • Primary key snippets
      • Foreign key snippets
      • Terminology
      • Multiple foreign keys in a single field
      • How to sync Postgres views
    • Salesforce
    • Stripe
      • Authorize Stripe
    • Supabase
      • Adding default values to primary keys
      • How to sync Airtable linked records with Supabase foreign keys
      • Why does Whalesync create a database user?
      • Why do I need an ID column?
      • SQL scripts
      • Primary key snippets
      • Foreign key snippets
      • Terminology
      • Multiple foreign keys in a single field
      • How to sync Postgres views
    • Webflow
      • Supported fields - (AT x WF)
      • Webflow Memberships sync
      • Webflow status field
  • Previous connectors
    • Bubble
      • Authorize Bubble
    • Close
    • Copper
    • MS Dynamics CRM
    • Outreach
    • Pipedrive
      • Pipelines
    • Shopify
      • Authorize Shopify
      • Syncing images
      • Syncing variants
      • Tutorial videos
      • Theme Template field
    • WordPress.com
    • WordPress.org
      • Quick Start Guide: WordPress.org
      • Authorize WordPress.org
      • Advanced Custom Fields (ACF)
      • How to sync images
      • Supporting tables
      • Tutorial
      • WordPress status field
    • Zoho CRM
  • Features
    • Two-way sync
    • Issues
    • Operations
    • Record matching
    • Filters
    • Auto-create tables
    • Additional features
      • Automapping
      • Creating users via Whalesync
      • Delete protection
      • File hosting
      • HTML and Markdown field extensions
      • Relation fields
      • Sync preview
  • Resources
    • Support
      • Sync behavior questions
      • Common errors - Airtable
      • Common errors - Notion
      • Common errors - Postgres
      • Common errors - Webflow
      • FAQ
      • Field compatibility
      • How to get record IDs
      • How to change your sign-in
      • How to change your email
      • How to add additional email addresses
      • How to update your tax ID number
      • How to create a slug field in Airtable
      • Known issues
      • Multi-select to multi-reference
      • Transfer Webflow site to another account
      • Troubleshooting attachment fields
      • Webflow deprecating v1 APIs
    • Template Packs
  • YouTube
  • Security
  • Changelog
Powered by GitBook
On this page
  • Supported Fields
  • Before syncing Google Sheets
  • Video Guide

Was this helpful?

  1. Connectors

Google Sheets

PreviousAttioNextFormatting columns

Last updated 1 month ago

Was this helpful?

Supported Fields

Field
Status

πŸ“ Text

βœ… Supported
βœ… Supported

πŸ“… Date

βœ… Supported

#️⃣Percentage

βœ… Supported
βœ… Supported
βœ… Supported
βœ… Supported
➑️ 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.


Video Guide

Number

Currency

Email

Drop-Down

Checkbox

How to format field types

How to add foreign key fields

⚠️
πŸ‘‡
πŸ‘‡
Formatting columns
Foreign keys
πŸ”’
πŸ’°
πŸ“§
πŸ“œ
πŸ—³οΈ
A quick video demo for how to sync Google Sheets and Airtable
Page cover image