Why does Airtable fail to update existing contacts in HubSpot?

Develop, Build & Integrate HubSpot-built Apps
1

image
image1578×317 37.3 KB

Issue: Existing HubSpot Contacts Are Not Being Updated Through Airtable Sync

We are currently facing an issue with the Airtable–HubSpot contact sync.

The expected behavior is that when a contact already exists in HubSpot and the same contact is subsequently added to Airtable, the sync should identify the existing HubSpot contact and update its mapped properties/fields rather than attempting to create a new contact.

However, the current behavior is that when the Airtable record is synced, HubSpot identifies that the contact already exists and returns an “Contact already exists in HubSpot” error. As a result, the Airtable record is not being properly synced with the existing HubSpot contact, and the updated field values are not reflected in HubSpot.

Expected Behavior

If a contact exists in both systems, the sync should:

  1. Identify the matching contact using the configured unique identifier (e.g., email).

  2. Match the Airtable record with the existing HubSpot contact.

  3. Update the relevant mapped HubSpot properties with the values from Airtable.

  4. Avoid creating a duplicate contact.

  5. Continue to maintain two-way synchronization for future updates made in either system.

Current Behavior

  • Contact is created in HubSpot.

  • The same contact is then added to Airtable.

  • During synchronization, the system detects that the contact already exists in HubSpot.

  • Instead of matching and updating the existing record, the sync fails with a “Contact already exists in HubSpot” error.

  • The Airtable data is therefore not being properly synchronized/updated in the existing HubSpot contact.

Required Action

Please investigate the record-matching and sync configuration between Airtable and HubSpot and ensure that existing contacts are correctly matched and updated rather than being treated as new records.

The sync should support updating existing HubSpot contacts when a corresponding Airtable record is created or updated, while preventing duplicate contact creation.

3

Hi @Eishah and welcome, it’s a pleasure to have you on the HubSpot Community!

Thanks for bringing this to our attention and for sharing the screenshot!

With the native Airtable integration, contacts should be matched by email. If a matching HubSpot contact already exists, it should be updated rather than created again.

As a first step, can you please go to “Settings → Integrations → Connected Apps → Airtable → CRM syncs → Contacts → Configure”. From there, confirm that “Record matching” is set to “Email/default matching”.

It’s also helpful to check that the email address in Airtable exactly matches the HubSpot contact’s primary or additional email address, and that there aren’t any genuine duplicate contacts in HubSpot.

If only one HubSpot contact exists and the issue continues, there may be a stale sync pairing or a matching-index issue. In that case, please try resetting the record mapping. If that doesn’t resolve it, our Support team will be happy to investigate further. Be sure to include the Airtable record ID, HubSpot contact ID, email address, and relevant sync details, as well as this topic on the Community.

If you do find two duplicate contacts in HubSpot, you can merge them and keep the contact that is currently syncing.

Hi @HubDoPete, @TomM2 and @elizheleva do you have other suggestions or insights to share, please?

Thanks so much and have a wonderful day!
Bérangère