HubSpot Destination: Support Deals sync and HubSpot Record ID as upsert key

[lukewatters-airbyte]

Problem

Users running reverse ETL flows from their data warehouse to HubSpot can currently sync Companies and Contacts, but there is no support for syncing Deals. This is a significant gap for teams trying to automate product-led growth workflows — for example, mapping customer-initiated upsells or opportunities from product data into HubSpot, or populating custom HubSpot fields with computed values from warehouse data.

Additionally, there is no way to use the HubSpot Record ID as a mapping or upsert key, which limits flexibility when working with existing HubSpot records.

Proposed Solution

1. Add Deals as a supported sync target in the HubSpot destination, with a mapping screen consistent with the existing Companies and Contacts interfaces
2. Support HubSpot Record ID as an upsert key for Deals and ideally across all supported HubSpot objects

Who benefits

Teams using Airbyte for reverse ETL to HubSpot who want to automate product-led lifecycle management — particularly those syncing product usage, billing, or opportunity data from a data warehouse into HubSpot CRM. Users already running Companies and Contacts flows would benefit immediately.

Additional context

Current workarounds include no-code tools like n8n or custom hosted scripts, both of which introduce maintenance overhead outside of Airbyte. Native support would keep the full reverse ETL workflow within a single platform.