)
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 convert phone numbers to E.164 format because they lack the string manipulation capabilities needed to strip special characters, add country codes, and validate number length requirements. E.164 formatting needs precise character handling that exceeds workflow functions.
You’ll learn how to convert phone numbers to E.164 format using spreadsheet functions that ensure international calling compatibility and CRM integration requirements.
Convert to E.164 format with comprehensive capabilities using Coefficient
CoefficientHubSpotHubSpotprovides complete E.164 conversion by connectingphone number data to spreadsheets. Strip special characters, apply E.164 formatting rules, validate compliance, then export properly formatted numbers back to.
How to make it work
Step 1. Import HubSpot contact phone numbers in various formats.
Pull in contact data with phone numbers that need E.164 conversion. This includes numbers with parentheses, hyphens, spaces, and other formatting characters.
Step 2. Remove special characters with SUBSTITUTE functions.
Strip all formatting characters: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,”(“,””),”)”,””),”-“,””). Chain multiple SUBSTITUTE functions to remove parentheses, hyphens, and spaces from phone numbers.
Step 3. Apply E.164 formatting rules.
Add country codes and proper formatting: =IF(LEN(B2)=10,CONCATENATE(“+1″,B2),IF(LEFT(B2,1)=”1”,CONCATENATE(“+”,B2),B2)). This handles 10-digit US numbers and existing country codes correctly.
Step 4. Validate E.164 compliance and export.
Add length checks and country code verification to ensure proper E.164 format. Export compliant numbers back to HubSpot with automatic scheduling for new contacts.
Ensure international calling compatibility
Start convertingThis approach meets CRM integration requirements for E.164 format and provides bulk conversion of thousands of phone numbers simultaneously. You maintain data quality standards that HubSpot workflows can’t achieve independently.to E.164 format today.
