Hello,
Is there a way to view, create or export a list of contacts that have more than one email address assigned to them?
I’ve discovered that some of our contacts have more than one address associated to them, perhaps due to an improperly imported list or a problem with a form. For instance, if I view contact John Doe’s contact page, it shows him with emails john@gmail.com, john@hotmail.com and jane@yahoo.com.
However, when viewing a list of contacts, only the first email is being shown. I need to find out which contacts have more than one email assigned to them so that I can fix these erroneous entries. For instance, in the above example, jane@yahoo.com is supposed to be a separate person, and I’m not sure how they got merged. With a contact database of over 7,000 it would be very time-consuming to go through each contact separately.
Hi @BradDemers,
Thanks for reaching out.
Currently, this is not a functionality of the tool. If you would like to see this implemented in the future, I would recommend sharing this idea in our ideas forum.
Take care!
Jess
Appologize for not knowing if this functionality is tied to a specific HubSpot product or tier (don’t think it is) or remembering when it was released (very recently), but when exporting contacts from a VIEW you may now select “Export all emails for selected contacts” -- see images below.
Export all emails for selected contacts
Export all email addresses for selected contacts -- RESULTS
Enjoy!
This helped me find which contacts that had more than 2 emailadresses and caused our integration to fail. Thanks! Not a solution to the problem (Hubspot should allow to build list to check number of emails), but a good workaround.
Does anyone know if there is any update or new functionality to be able to make these lists? It would be much more useful than the export function.
Unfortunately this option is not available anymore
Instead of exporting all contacts to an excel file and searching that, there is a programmatic way to do it as well using the search API as documented at https://developers.hubspot.com/docs/api/crm/contacts.
In my opinion this is easier if there is a developer in the company who is able to do it.
Sample payload for the search API:
{
"limit": 100,
"after": 0,
"filterGroups": [
{
"filters": [
{
"propertyName": "hs_additional_emails",
"operator": "HAS_PROPERTY"
}
]
}
]
}
Using limit = 100 means we want to retrieve 100 at a time.
Using after = 0 means we want to start at page 1. If there are more than 100 records, change after to 100 for page 2, and so on and so forth.
The response will be something like this:
{
"total": 157,
"results": [
{
"id": "841701",
"properties": {
"createdate": "2021-09-16T04:56:34.119Z",
"email": "myemail@example.com",
"firstname": null,
"hs_object_id": "841701",
"lastmodifieddate": "2023-05-17T01:00:23.348Z",
"lastname": null
},
"createdAt": "2021-09-16T04:56:34.119Z",
"updatedAt": "2023-05-17T01:00:23.348Z",
"archived": false
},
....
],
"paging": {
"next": {
"after": "100"
}
}
}
The above shows that there is a total of 157 contacts with multiple emails. The “paging” part shows that this is the first page, and the second page is “after 100”.
Hope that helps.
Cheers,
Lawrence
