Export Salesforce Contacts to HubSpot

Why Teams Make This Switch and What to Expect

Switching from Salesforce to HubSpot can be a strategic move for many businesses, especially those looking for a more integrated customer relationship management (CRM) and marketing automation solution. Salesforce is renowned for its robust CRM capabilities but can be complex and costly for small to mid-sized businesses. HubSpot, on the other hand, offers a more streamlined, user-friendly interface with comprehensive CRM, marketing, and sales tools, often at a lower cost. However, migrating data, specifically contacts, from Salesforce to HubSpot requires careful planning and execution to ensure data integrity and minimize downtime.

When making this switch, teams should expect to invest time in data preparation, export, and import processes. Additionally, rebuilding workflows and customizations in HubSpot may require some reconfiguration. This guide will walk you through the entire process, from exporting data from Salesforce to importing it into HubSpot, ensuring a smooth transition.

Getting Your Data Out of Salesforce

Before exporting contacts from Salesforce, ensure that all necessary fields and data are up-to-date and consistent. Salesforce allows exporting data via the user interface or through the API. We’ll cover both methods.

Exporting Contacts via Salesforce UI

To export contacts via the Salesforce UI, follow these steps:

1. Log in to your Salesforce account.
2. Navigate to Setup by clicking the gear icon in the upper right corner.
3. In the Quick Find box, type Contacts and select it from the results.
4. Click the Contacts tab.
5. Click the Export button in the top right corner.
6. Select the fields you want to export. It’s important to choose all relevant fields, including custom fields and any fields that will be used for segmentation in HubSpot.
7. Click Export to download the file. This will be a CSV file containing your contact data.

Exporting Contacts via Salesforce API

For larger datasets or more complex exports, using the Salesforce API can be more efficient. You can use the Mass API to export large volumes of data. Here’s a basic example using the SOQL Query to export contact data:

SELECT Id, FirstName, LastName, Email, Phone, MailingStreet, MailingCity, MailingState, MailingPostalCode, MailingCountry FROM Contact

This query can be executed via the Salesforce REST API or SOAP API, depending on your preference and setup. The API limits for Salesforce are 50 requests per second and 15,000 API calls per user per 24-hour rolling window. Be mindful of these limits, especially during bulk data operations. For instance, if you are exporting a large number of contacts, you may need to break the export into smaller batches to avoid hitting the API limits.

Importing and Reconfiguring in HubSpot

Once you have your data exported from Salesforce, you can import it into HubSpot. HubSpot supports importing contacts via the user interface or using the API. We’ll cover both methods here.

Importing Contacts via HubSpot UI

To import contacts via the HubSpot UI, follow these steps:

1. Log in to your HubSpot account.
2. Navigate to Contacts under the Contacts menu.
3. Click the Import button in the top right corner.
4. Choose the Contacts option.
5. Click Select File and upload the CSV file you exported from Salesforce.
6. Map the fields in your CSV to the corresponding fields in HubSpot. This is crucial for ensuring that the data is correctly aligned and can be used effectively in HubSpot. For example, map the Salesforce "Email" field to the HubSpot "Email" property and the Salesforce "Phone" field to the HubSpot "Phone" property.
7. Click Next and then Import to start the import process.

During the import process, HubSpot will validate the CSV file and notify you of any issues, such as missing required fields or incorrect data formats. Address these issues before proceeding with the import to ensure a smooth transition.

Importing Contacts via HubSpot API

If you are dealing with a large volume of contacts, using the HubSpot API for importing can be more efficient. The Contacts API allows you to batch import contacts. Below is a basic example of how to use the API to import a contact:

POST /crm/v3/objects/contacts
{
  "properties": {
    "firstname": "John",
    "lastname": "Doe",
    "email": "[email protected]",
    "phone": "123-456-7890"
  }
}

To handle bulk imports, you can use the Imports API, which allows you to upload large datasets in batches. Remember to handle rate limits, which are 10,000 requests per hour per API key. For example, if you are importing 10,000 contacts, you may need to break the import into multiple batches over several hours to avoid hitting the API limits.

What Commonly Breaks and Exact Fixes

During the migration process, several issues can arise, primarily related to data mismatches, custom fields, and workflows. Here are some common issues and their fixes:

Data Mismatch

Issue: Fields in Salesforce may not directly map to fields in HubSpot.

Fix: Review the field mappings during the import process in HubSpot. You can map Salesforce custom fields to HubSpot custom properties by creating equivalent fields in HubSpot before importing. For example, if you have a custom field in Salesforce called "Industry," you can create a custom property in HubSpot with the same name and map it during the import process.

Custom Fields

Issue: Custom fields in Salesforce may not have direct equivalents in HubSpot.

Fix: Create custom properties in HubSpot that match the custom fields in Salesforce. Ensure that the data types are compatible (e.g., text fields in Salesforce should map to text properties in HubSpot). For instance, if you have a custom field in Salesforce called "Company_Size," you can create a custom property in HubSpot with the same name and ensure it is of the text data type.

Workflows and Automation

Issue: Complex workflows and automations in Salesforce may not translate directly to HubSpot.

Fix: Rebuild workflows in HubSpot using the Workflows feature. HubSpot offers a robust workflow builder that can handle most automation tasks. Review each workflow in Salesforce, and recreate them in HubSpot, taking advantage of HubSpot’s more user-friendly interface. For example, if you have a workflow in Salesforce that sends an email when a contact is created, you can create a similar workflow in HubSpot using the "Contact Created" trigger and the "Send Email" action.

Realistic Timeline with Milestones

Migrating contacts from Salesforce to HubSpot is a process that requires careful planning and execution. Below is a realistic timeline with key milestones:

Preparation (1-2 Weeks)

• Identify all necessary data and fields to be migrated.
• Ensure all data in Salesforce is up-to-date and consistent.
• Prepare custom fields and properties in HubSpot.

Data Export (1 Week)

• Export contacts from Salesforce using the UI or API.
• Verify the exported data for completeness and accuracy. Use data validation tools to ensure that the exported data is consistent and free of errors.

Data Import (1-2 Weeks)

• Import contacts into HubSpot using the UI or API.
• Map fields correctly to ensure data integrity. Use the HubSpot import wizard to map fields and verify that all required fields are populated.

Validation and Testing (1-2 Weeks)

• Verify that all contacts have been imported correctly. Use HubSpot’s search and filter features to ensure that all contacts are present and that data is mapped correctly.
• Test workflows and automations in HubSpot. Use HubSpot’s workflow builder to recreate workflows and test them in a sandbox environment before going live.
• Ensure that all data is accessible and usable in HubSpot. Verify that all custom fields and properties are functioning as expected and that data is being used in campaigns and reports.

Go-Live and Monitoring (1 Week)

• Switch to using HubSpot for all CRM operations. Ensure that all team members are trained on the new system and that they are comfortable using HubSpot.
• Monitor for any issues or discrepancies. Use HubSpot’s reporting and analytics features to track data usage and identify any issues that arise.
• Continue to refine workflows and automations as needed. Based on user feedback and usage data, make adjustments to workflows and automations to improve efficiency and effectiveness.

Overall, the entire migration process can take between 4-6 weeks, depending on the complexity of your data and workflows. By following this guide, you can ensure a smooth transition from Salesforce to HubSpot, taking full advantage of HubSpot’s integrated CRM and marketing automation capabilities.

For more detailed information on migrating to HubSpot, consider exploring HubSpot's official documentation and support resources. Additionally, tools like Salesforce Data Loader and Zapier Integration can provide further assistance in managing your data migration process. HubSpot also offers a range of training and support options, including webinars, tutorials, and one-on-one support, to help you navigate the migration process and get the most out of your new CRM solution.