Expand Salesforce Integration to include Nonprofit Success Pack multiple email matching
The native HubSpot-Salesforce integration is not built to support integration with the Nonprofit Success Pack. Specifically, there are three additional email fields available in NPSP (personal email, work email, alternate email) to support the fact that donors use multiple emails, there's no way we can expect them to only use one. There are two issues here:
1. The native HubSpot-Salesforce integration only supports matching against the primary email field, so if a donor submits a HubSpot form on a new browser using an alternate email that exists in Salesforce already but not in HubSpot, it will create a new contact on both sides. For large nonprofits this creates a large deduplication burden in both systems.
2. Nonprofits need to be able to store multiple emails in both systems, but the way they do it is different. If Contact A submits a form using Email B, switching Email B to primary, it will overwrite the Email field in Salesforce and Email A will be lost on the Salesforce side, even though HubSpot is technically holding both email addresses.
This is a major data loss issue for nonprofits leveraging both systems!
I can support it through our HexaSync Integration Platform because you can change the primary key set for mapping HubSpot & SalesForce contacts (so we do not have to use email for primary key mapping). Please check some of our HubSpot Integration Demonstration to understand more about the way it works: