Find Contacts with Multiple Email Addresses

[whartwell]

As Hubspot allows multiple email addresses to be stored on a single contact, we need a way to locate all contacts with more than one email address. Though Hubspot may allow multiple email addresses on a contact, our integrated systems (Salesforce, for one) do not, and we have no direct visibility into secondary email addresses created through form submissions without such a feature. Please help!

Thanks,

Wesley

[kaburke]

Hi @PBaskakov !  If you are using a HubSpot form, there is the option to use the option 'Always create contact for new email address: select this option to create a new contact record for every submission with a unique email address. If the email address submitted matches an existing contact record in your database, the details on the existing record will be updated.' see details here.

I have also outlined an automated process that will trigger a notification when an email changes you can set up this process.  In previous comments on this thread there have been different suggestions on ways you can clean up your data.  I hope this helps while our Product team work on a long term solution

[PBaskakov]

Thank you for this response. Hopefully this solves our problem!

[EDR]

Important idea!

[Melly2022]

We have this same issue - @kaburke  I don't think the above suggestion is what they are hoping for - I think what they would like is the ability to be able to sync the other email addresses to a field in salesforce so they can see multiple email address options from the salesforce record. 

Example Contact is self-employed consultant but ALSO works for a company he could have 2 emails to reach him at. This is a big thing in our industry. We manage but it's far from ideal and we certainly don't want to 2 records for 1 person to support this in salesforce (sync issues). Right now we have 2 custom properties in Salesforce but it's a manual thing where we have to add that extra email in. 

ALSO I suspect they are looking for a way to run a report to find contacts that have more than one email in Hubspot 
"we need a way to locate all contacts with more than one email address. "  I have an idea form submission for this exact request as well 🙂

[MReynoldsKane]

I agree this is an ongoing challenge - we have multiple contacts email addresses stuck under one contact and we can't identify the scope of the problem- it could be 30 or 30000 contacts. We can't use progressive profiling because we have to create new contacts BUT I can't even fix the ones which are broken so we are personalizing to contacts who are not the right person. We can't even use "Dear first name" with any confidence. Please at least help me create a list if I have to fix this manually. 

[squigglebit]

Bumping this as can't believe it's not fixed. 

We need visibility on contacts with more than one email.

[IsaKcc]

Plus 1 from my end; we have noticed double-opt-in conflicts with contacts that have multiple entries in the "E-Mail" property, which makes this a legally relevant issue related to GDPR topics.

[JBocalbos9]

Hopefully a fix comes along soon...

[karenkaz]

It has been four years since this request was first posted and there's still no way to pull a simple report or list of all records with multiple email addresses? PLEASE, HubSpot, we've adjusted our form cookie settings but still need to find the records that got messed up before we changed the settings so we can fix them. Our customers are accusing us of a data breach because a colleague's account information was included in their email footer after they both completed a form on the same device. We need to be able to find and fix other instances of this happening.  

[kdiogenes]

I'm still confirming if this works as expected, but from my checking so far it looks like it does:

curl -X POST \
'https://api.hubapi.com/crm/v3/objects/contacts/search' \
-H 'Authorization: Bearer your-token' \
-H 'Content-Type: application/json' \
-d '{
  "filterGroups": [
    {
      "filters": [
        {
          "propertyName": "hs_additional_emails",
          "operator": "HAS_PROPERTY"
        }
      ]
    }
  ]
}'

 Sharing to catch any issues soon.

[JAParkinson]

I am having the same issue! I have been working through our contacts removing people that have bounced. The trouble is, the mian email may have bounced but it doesn't mean the secodnary has which makes removing contacts in bulk difficult. 

I need to be able to view all email addresses the the account so I can ensure I am only removing contacts that have actually bounced. 

[nelmsbrad]

This is sort of in line with what I'm currently struggling with - I'm trying to create a list that identifies contacts in our database that can be deleted because they've Hard Bounced.  However, I'm trying to be careful not to delete relevant contacts, so I have added filters to the list such as no phone numbers on record, etc.  One of the things that I've discovered is that we have contacts that match all of the filters but are still relevant contacts with good info.  The reason for this - They have an alternate email on file that has bounced, but their primary or secondary email(s) are still valid.

I need a filter to allow me to identify and remove contacts from my list that have more than one email associated with their record.  Without this, I have to manually go through and verify over 4k contacts that are being deleted to save time and weed out useless data...

Please make this a thing!  If you can add multiple email addresses to a record, you should be able to use those as data points for various tasks.

[CBN]

You can do that easily through the API @nelmsbrad 

Here's the C# code for that. However, I may warn you that HubSpot has a good surprise waiting for you 😈😈😈😈

THE NOTORIOUS 4 SEARCH REQUEST PER SECOND RATE LIMIT!!!!!!

public long ContactExists(string email)
{
    if (!email.IsValidEmail())
    {
        throw new ArgumentException($"Email must be valid, {email}");
    }

    var client = new RestClient("https://api.hubapi.com/crm/v3/objects/contacts/search");

    var request = CreateRestRequest();
    request.AddParameter("application/json", "{\"filterGroups\":[{\"filters\":[{\"value\":\"" + email + "\",\"propertyName\":\"email\",\"operator\":\"EQ\"}]}]}",
        ParameterType.RequestBody);

    var response = client.Execute<HubSpotSearchResult>(request);

    if (response.Data.Total == 1)
    {
        return response.Data.Results[0].Id.ToLong();
    }

    WaitToPreventSearchRequestLimit();

    var contactByEmail = new RestClient($"https://api.hubapi.com/crm/v3/objects/contacts/{email}/?idProperty=email");

    var contactRequest = CreateRestRequest(Method.GET);

    var contactResponse = contactByEmail.Execute(contactRequest);

    if (contactResponse.StatusCode == HttpStatusCode.NotFound)
    {
        return 0;
    }

    var options = new JsonSerializerOptions
    {
        PropertyNameCaseInsensitive = true
    };
    var contact = JsonSerializer.Deserialize<HubSpotContact>(contactResponse.Content, options);

    return contact == null ? 0 : contact.Id.ToLong();
}

[esteeratliff]

This would be super helpful for me. Our struggle is the same as OP, my integration with NetSuite only syncs over the main email adress from HubSpot.

HUGEST help would be if HubSpot just made the other email address fields "reportable" or able to be seen by integrations. That would fix everything for me.

2nd best would be able the ability to dynamically report on those contacts that do have more than one email. I could then just focus on getting those people exported & manually import the additonal email adresses into NetSuite.

The 3rd, and current workaround, is exporting out all contacts w/ the all email adresses option checkmark. Then I filter on the "all email addresses" excel column for anything not blank. I then create a spreadsheet that can get the aggregated into additional email adresses columns that can get imported into NetSuite into alternative email address fields. 

[RNicotup]

@kaburke  any update on this? It would be hugely helpful to be able to pull a list/report of contacts that have multiple email addresses. 

[EHarp]

Hi all! Credit to @kaburke for sharing the link (here's the solved article), but you can now somewhat easily export a list of all contacts with additional emails through a workaround. If you go to contacts> filter your view as needed> export> customize, there's a checkbox that allows you to "Include all email addresses." When pulling up the export as a sheet, it'll create a column titled "Additional email addresses." I deleted all the contacts with blanks in this column so I'm left with only the contacts that have additional email address listed. This might not solve a lot of the specific issues, and it's far from automated, but if you're trying to find a quick solve to identify these contacts, this seems to work so far! Might just need to be a recurring/regular process for hygeine upkeep, as we're having the duplicate issues many others on this thread are having. Hope this helps someone!