)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
HubSpot workflows can’t handle phone number formatting well because they lack the string manipulation functions you need. The native concatenate and substring functions hit complexity limits fast and often break when chaining multiple operations.
Here’s how to format phone numbers with hyphens using spreadsheets instead, then sync the results back to HubSpot automatically.
Format phone numbers in spreadsheets using Coefficient
CoefficientHubSpotHubSpotlets you pullcontact data into spreadsheets where advanced formulas work reliably. You can format thousands of phone numbers at once, then push the clean data back towithout hitting workflow limits.
How to make it work
Step 1. Import your HubSpot contacts with unformatted phone numbers.
Connect to HubSpot through Coefficient and pull in your contact data. Select the phone number field and any other contact properties you need for processing.
Step 2. Apply phone number formatting formulas.
Use spreadsheet formulas to add hyphens to 10-digit numbers: =CONCATENATE(MID(A2,1,3),”-“,MID(A2,4,3),”-“,MID(A2,7,4)). For numbers with varying lengths, wrap this in IF statements to handle different formats.
Step 3. Add validation for different phone number lengths.
Create conditional formatting using IF statements: =IF(LEN(A2)=10,CONCATENATE(MID(A2,1,3),”-“,MID(A2,4,3),”-“,MID(A2,7,4)),”Invalid Length”). This catches malformed numbers before they go back to HubSpot.
Step 4. Export formatted phone numbers back to HubSpot.
Set up a scheduled export to push the properly formatted phone numbers back to HubSpot contact properties. This runs automatically, so new contacts get formatted without manual work.
Skip the workflow complexity entirely
Start formattingThis approach handles bulk phone number formatting that would break HubSpot workflows. You get reliable formatting, better error handling, and automatic processing.your phone numbers today.
