CRM

SymbanServices
Participant

Contact import errors from Google

SOLVE

Hello everyone,

 

I have two contacts in my Google contact list which are erroring off during import, but the process doesn't give my any idea as to which contacts are failing, nor are they telling me why they failed.

 

I've checked for invalid characters in the name, company name, address, email addresses, and many other fields.

 

Any ideas? It's driving me nuts! LOL

 

Best,

John

0 Upvotes
1 Accepted solution
jennysowyrda
Solution
Community Manager
Community Manager

Contact import errors from Google

SOLVE

Hi @SymbanServices,

 

You can also try importing your google contacts through the Import2 integration

 

Thanks,

Jenny

View solution in original post

10 Replies 10
Mike_Eastwood
Key Advisor | Gold Partner
Key Advisor | Gold Partner

Contact import errors from Google

SOLVE

Hi John,

At the risk of making you nuts-er I would try exporting the contacts to a CSV FIle, then import them into HubSpot.

The reason I'm suggesting the extra step is the Error Handling - when importing from CSV - is excellent for forensics. You can then find the offending contacts and correct the issues and it's easier to correct the issues in a spreadsheet.

Here's how to Export from Gmail

  1. From your Gmail account, choose Gmail>Contacts.
  2. Select More >Export.
  3. Choose the contact group you want to export.
  4. Choose the exportformat CSV(for importing into HubSpot).
  5. Choose Export.
  6. When prompted, choose Save As, and browse to a location to save the file.

Have fun

Mike

p.s. the import will de-duplicate Contacts by Email Address and Companies by Domain Name so it's good to include them in your import whenever possible.

SymbanServices
Participant

Contact import errors from Google

SOLVE

Hi Mike,

 

Thanks for the suggestion, but I already did that and got no errors - I told you it was making me crazy! LOL

 

It seems a simple thing to show what the errors were... anyway, thanks for the suggestion.

 

Best,
John

0 Upvotes
Mike_Eastwood
Key Advisor | Gold Partner
Key Advisor | Gold Partner

Contact import errors from Google

SOLVE

Welcome to my world John, the craziness isn't required but it helps.

 

Happy to have a look at your file and see if I can see any issues.

 

We had some fun and games trying to import file recently(see here) because it was missing the quotes in fields that included commas - so it was messing up the import.

 

Cheers

Mike

0 Upvotes
SymbanServices
Participant

Contact import errors from Google

SOLVE

Hi Mike,

 

Thanks again for responding! The CSV file imports with no errors... it's the Google import that has two failures. I just can't figure it out and it really is getting on my nerves - LOL.

 

Any suggestions other than deleting one at a time and running the import until I find the offending contacts?

 

Thanks!

John

0 Upvotes
jennysowyrda
Solution
Community Manager
Community Manager

Contact import errors from Google

SOLVE

Hi @SymbanServices,

 

You can also try importing your google contacts through the Import2 integration

 

Thanks,

Jenny

SymbanServices
Participant

Contact import errors from Google

SOLVE

Hi Jenny,

 

Thanks for the suggestion - I was hoping that the included gmail integration would be sufficient...

 

in any case, I already have a Zapier account so I'll try that route first. 

 

All my best,

John

0 Upvotes
jennysowyrda
Community Manager
Community Manager

Contact import errors from Google

SOLVE

Hi @SymbanServices,

 

The gmail import feature is being migrated to being handled by import2. For more information, I wanted to share this thread.

 

Thank you,
Jenny

0 Upvotes
Mike_Eastwood
Key Advisor | Gold Partner
Key Advisor | Gold Partner

Contact import errors from Google

SOLVE

Sorry John, I got distracted by something shiny.

 

Did you manage to get the contacts to import?

 

Mike

0 Upvotes
SymbanServices
Participant

Contact import errors from Google

SOLVE

Hi Mike,

 

Something shiny... Hahaha! 

 

Anyway, I am able to import everything using a CSV exported from my Gmail account, but still get errors when trying to import directly from Gmail.  It's pretty crazy but I just don't have the time to continue trying to figure this out. It would have been nice to be able to do this in one step instead of two or three...

 

Thanks for your advice.

 

Best,
John

0 Upvotes
Mike_Eastwood
Key Advisor | Gold Partner
Key Advisor | Gold Partner

Contact import errors from Google

SOLVE

Hi John,

 

I'm glad you got the data in... Importing is *never* as simple as it seems.

 

With the Gmail plugin hooked up you shouldn't need to go there again.

 

Have fun

Mike

 

0 Upvotes