⚙ Operations Hub

JoeFromPinch
Participant

Format phone number to add country code

SOLVE

Is there a way to add a format workflow to automatically convert a phone number to add a country code? I use Hubspot to call a lot but our third party systems only collect the phone number without country code, which Hubspot requires to validate it and ring it.

1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Format phone number to add country code

SOLVE

Hi @JoeFromPinch,

 

Then it depends on how your phone numbers are formatted exactly. In Germany, for example, numbers without country code start with a 0. That 0 is removed when the country code is dialed.

 

E.g. 030 1234567 would turn into +49 30 1234567

 

I could achieve that with the workflow below:

 

karstenkoehler_0-1683873550856.png

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

7 Replies 7
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Format phone number to add country code

SOLVE

Hi @JoeFromPinch,

 

Which HubSpot subscription are you on? In Operations Hub Professional, you can use the Format data workflow action to change the formatting of your phone number and add a country code at the beginning.

 

Without Operations Hub Professional, you'd have to look into third-party tools such as Insycle. (If upgrading to Operations Hub Professional is an option, let me know and I can share more use cases that can be easily implemented in this hub and improve data quality.)

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
JoeFromPinch
Participant

Format phone number to add country code

SOLVE

I do have Ops Hub professional. I tried to use the Format data workflow but I couldn't figure out exactly what to do with it. 

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Format phone number to add country code

SOLVE

Hi @JoeFromPinch,

 

That depends on where the information about the country code lives. Do you have that in a separate property? What would determine which country code is added at the beginning of a phone number?

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
JoeFromPinch
Participant

Format phone number to add country code

SOLVE

All our numbers are in the same country. So I need to just insert the same number every time.

0 Upvotes
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Format phone number to add country code

SOLVE

Hi @JoeFromPinch,

 

Then it depends on how your phone numbers are formatted exactly. In Germany, for example, numbers without country code start with a 0. That 0 is removed when the country code is dialed.

 

E.g. 030 1234567 would turn into +49 30 1234567

 

I could achieve that with the workflow below:

 

karstenkoehler_0-1683873550856.png

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

JoeFromPinch
Participant

Format phone number to add country code

SOLVE

Super helpful! Thank you.

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Format phone number to add country code

SOLVE

Hi @JoeFromPinch,

 

Happy to help. Make sure to test this first by copying the formatted phone number into another custom property. Search and replace actions can be hard to clean up if you're doing something wrong (e.g. searching all space characters in a word document and replacing them with nothing).

 

When everything looks good in the test property, you can unleash your workflow on the actual thing.

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes