Importing lists not able to update contacts without email

Smart CRM & Sales Hub Tips, Tricks & Best Practices
1

Hello,

I’m importing lists that do not have email or phone numbers on them. Without either of the two, the existing contacts are not being updated and rather a new contact is created.

My focus is more on the address as these are real estate leads.

Is there a way that I can bypass this?

2

Hi @Bdubs,

If you want to update contacts during an import and don’t have an email address, you would have to work with the record ID: Deduplicate records in HubSpot

Without either, HubSpot cannot update existing records and will create new records.

The record ID is generated for each record when it’s created and it’s included automatically when you export your records. In other words, if you want to update your imported records, you would have to export your existing records first, then use VLOOKUP or INDEXMATCH or another method to map the correct record ID to each row in your import file. (ChatGPT can help you with the exact Google Sheets or ChatGPT formula.)

During the import process, you can then map this record ID and HubSpot will update records in their place.

karstenkoehler_0-1711428405694.png
karstenkoehler_0-1711428405694.png641×390 53.1 KB

Best regards

3

Hi Karsten,

Thank you for your response!

Would this mean that any time I want to upload a new list that I need to first export all of my contacts, use VLOOKUP or INDEXMATCH then import them back in Hubspot?

Best,