How to Sync Salesforce Reference Fields with Hubspot

Connecting Salesforce reference fields properly with Hubspot is essential for keeping your CRM data aligned, searchable, and reportable across both systems. This guide walks you through how to mirror Salesforce lookup (reference) fields in Hubspot so your team can rely on accurate and consistent records.

Salesforce reference fields point to another object, such as a user, account, or contact. Because Hubspot does not have a native reference field type identical to Salesforce, the sync must be set up using compatible property types and configuration.

Understanding Salesforce Reference Fields and Hubspot

Before configuring any sync, you should understand what a reference field is in Salesforce and how Hubspot can store that data. A reference field in Salesforce is a lookup relationship that stores an ID pointing to another record. Examples include:

• Owner or user lookups
• Account lookups on opportunities
• Parent account relationships
• Contact lookups on custom objects

Hubspot does not store those IDs as relational links in the same way. Instead, it relies on text, dropdown, or other simple property types. To reflect the value of a Salesforce reference field in Hubspot, you must:

• Identify which field value should display (for example, the related record name or ID).
• Create an appropriate custom property in Hubspot.
• Map the Salesforce field to your new Hubspot property.

Planning Your Hubspot Salesforce Reference Sync

Careful planning ensures a smooth sync between Salesforce and Hubspot. Start with the following questions:

• Which Salesforce object contains the reference field you want to sync?
• What is the target object in Hubspot (contacts, companies, deals, or custom object)?
• Do you need the reference ID or a readable name value in Hubspot?
• Will users search, filter, or report on this property inside Hubspot?

Your answers determine what type of Hubspot property you should create and whether you need Salesforce formula fields or workflows to transform the data before sending it.

Step 1: Audit the Salesforce Reference Field for Hubspot Sync

Start in Salesforce and gather the technical details you will need to configure the sync with Hubspot:

1. Open Salesforce Setup and navigate to the object that contains the reference field.

2. Locate the reference field in the object fields list.

3. Note the field label, API name, and the object it references.

4. Check if the field is required, unique, or contains special validation rules.

Determine whether you want to send the raw ID or a user-friendly label into Hubspot. Often, teams prefer readable names such as the related account name, user full name, or related contact name.

Step 2: Prepare the Source Value in Salesforce for Hubspot

Because Hubspot cannot store dynamic relational references, you may need to transform the reference field in Salesforce before syncing.

Common approaches include:

• Formula fields: Create a formula field that outputs the related record name, email, or another attribute. For example, a formula that pulls Owner.Name or Account.Name.
• Text fields with workflows: Use Salesforce automation (Workflow Rules, Process Builder, or Flow) to copy the value from the related record into a standard text field.
• Read-only display fields: If the data is only used for display or reporting, use a read-only formula field, which is usually easiest to maintain.

Once the Salesforce field holds the exact text you want to show in Hubspot, you are ready to map it.

Step 3: Create a Matching Property in Hubspot

Next, set up a corresponding property in Hubspot so that the platform can store your reference data.

1. In your Hubspot account, navigate to Settings > Properties.

2. Select the object that should receive the Salesforce data (for example, Contacts, Companies, Deals, or a custom object).

3. Click Create property and configure it with:

   • Label: A clear name that indicates it represents a Salesforce reference (for example, “Salesforce Owner Name”).
   • Internal name: This will be generated automatically, but confirm it is easy to recognize.
   • Field type: Usually a single-line text field works best for synced Salesforce reference values.

4. Save the property so it becomes available for Salesforce field mappings.

Creating a well-labeled Hubspot property helps users understand that the value is sourced from Salesforce and may be read-only.

Step 4: Configure the Hubspot Salesforce Field Mapping

Once the property exists in Hubspot, connect it with the Salesforce field using the integration settings.

1. In Hubspot, open Settings > Integrations > Connected Apps and select Salesforce.

2. Navigate to the Field mappings tab.

3. Click Add new field mapping.

4. Choose the Salesforce object and the prepared field (formula or text) that represents the reference value.

5. Select the matching Hubspot property you created.

6. Set the sync direction, usually Salesforce to Hubspot only for reference-based data.

7. Save the mapping.

For detailed visual steps and the latest interface screenshots, you can refer to the official Salesforce integration documentation at Hubspot Salesforce reference field sync guide.

Step 5: Test and Validate Your Hubspot Sync

After saving the mapping, test how the reference data flows from Salesforce to Hubspot.

1. Identify one or more Salesforce records that contain a value in the reference field.

2. Force a sync, or wait for the next scheduled integration cycle.

3. Open the corresponding record in Hubspot and confirm that the property displays the expected text.

4. Update the reference field in Salesforce (for example, change the related account or owner) and verify the value updates correctly in Hubspot after the next sync.

If the value is blank or incorrect, re-check:

• The formula or workflow in Salesforce.
• The property type in Hubspot.
• The field mapping direction and object selection.

Best Practices for Managing Reference Data in Hubspot

To keep your integration scalable, follow these best practices when working with Salesforce reference fields and Hubspot properties:

• Limit the number of synced reference fields: Only sync what your users actually need in Hubspot.
• Use consistent naming: Include “Salesforce” or the related object in the Hubspot property label so users know the origin.
• Control edit access: Since the value is driven by Salesforce, consider restricting edits in Hubspot to avoid confusion.
• Document your mappings: Maintain internal documentation that lists each Salesforce reference field and its corresponding Hubspot property.

For complex implementations or multi-object architectures, you may want specialized CRM consulting. Resources like Consultevo can help design scalable integration strategies for Salesforce and Hubspot.

Troubleshooting Common Hubspot Reference Sync Issues

Hubspot Property Not Updating

If the Hubspot property is not updating, check the following:

• Does the Salesforce record meet all integration filters or criteria?
• Is the field mapping active and pointing to the correct objects?
• Is there a recent sync error logged in the Hubspot Salesforce integration settings?

Incorrect or Partial Values in Hubspot

When values look wrong in Hubspot, the issue often originates in Salesforce:

• Verify the formula or workflow that populates the source field.
• Confirm that the field is visible to the Salesforce integration user profile.
• Check if the field type matches the Hubspot property (for example, text to text).

Handling Multiple Related Records in Hubspot

Salesforce reference fields can sometimes point to multiple records through junction objects or custom relationships. Hubspot can only store simple values, so you may need:

• A formula that concatenates related names into a single text field.
• A custom integration or middleware to format the data before it reaches Hubspot.

Maintaining Long-Term Data Quality Between Salesforce and Hubspot

Once your reference fields are syncing reliably, regularly review how teams are using the data in Hubspot. Consider:

• Adding filters and saved views that surface the synced reference values.
• Using the property in Hubspot reporting where appropriate.
• Retiring unused mappings to keep your integration clean and efficient.

By planning the data model, preparing Salesforce fields, creating precise Hubspot properties, and rigorously testing, you can sync Salesforce reference fields in a way that is robust, understandable, and easy for your users to adopt.

Need Help With Hubspot?

If you want expert help building, automating, or scaling your Hubspot , work with ConsultEvo, a team who has a decade of Hubspot experience.

Scale Hubspot

“`