Format phone numbers to E.164 and validate addresses in a HubSpot workflow
A three-minute guide for HubSpot admins and RevOps. It covers HubSpot's native action first, then TidyAddress for HubSpot. No sign-in needed.
On this page
- The problem
- The native option, and when it is enough
- Install TidyAddress and accept the data notice
- Add the workflow actions
- Fix the records you already have
- What TidyAddress does not do
- The result
The problem
Phone numbers arrive in HubSpot the way people type them: 089 99998 198, 020 7946 0142 or 0044 20 7946 0419. Without a country code, WhatsApp, SMS and dialer actions cannot use them reliably. Postal addresses have the same problem: a city in lowercase, a missing postal code, a street with a typing error.
The native option, and when it is enough
HubSpot has its own workflow action for phone numbers. In the workflow editor, click the plus, search the actions for "format" and choose Validate and format phone number in the CRM section. HubSpot's knowledge base lists it for Professional and Enterprise subscriptions, and the action converts valid numbers to the E.164 format.
- The action does not save the result by itself. Add an Edit record action after it and choose the action's output as the value.
- Choose a default country, or let the action read each record's country, for numbers without a country code.
- Format data in the Data ops section is a different action. It needs Data Hub Professional or Enterprise and changes text (case, trimming, replacing characters). It cannot tell whether an address exists.
If formatting phone numbers in workflows is all you need, the native action is enough. You need something else to check postal addresses, to fix the records you already have in one run, or on Free and Starter, where there are no workflows.
Install TidyAddress and accept the data notice
- On the TidyAddress page, click Install TidyAddress and choose your HubSpot account.
- Review the permissions and click Connect app.
- While TidyAddress is not yet listed in the HubSpot Marketplace, HubSpot asks you to type "I accept the risk" to continue. The privacy policy and the data processing agreement say what the app reads and stores.
- The app home shows Before TidyAddress starts: what is read, the service providers and how long data is kept. Addresses go to Google's Address Validation service; phone numbers are checked on our server. Tick the box and click Agree and continue. TidyAddress reads nothing before this.
TidyAddress is free during the beta, with 750 address checks a month and phone checks without a monthly limit.
Add the workflow actions
The workflow actions need a HubSpot subscription that includes workflows (Professional or Enterprise).
- In a contact or company workflow, click the plus, open TidyAddress under Integrated apps and pick Check and fix phone number.
- Choose the phone property, the property to write and the Write mode Fill blanks and fix formats, then click Save.
- Add Check and fix address the same way and map street address, city, state or region, postal code and country. Choose a Write mode.
- Phone format: the action returns the number in E.164 (for example +498999998198) as an output for later steps. What it writes to the record follows Phone number format in the app's settings: international with spaces (+49 89 99998198, the default) or E.164 without spaces (+498999998198). HubSpot displays both the same way, with spaces; the stored value is what exports, integrations and the API receive.
- Address writes: the address action writes only when an admin has turned on Write confident corrections from workflow actions in TidyAddress settings. Until then it reports the result and changes nothing.
- Branching: both actions return a status your workflow can branch on.
Fix the records you already have
- Open the TidyAddress app home and click Scan records and preview fixes. The scan is free and counts the addresses and phone numbers that can be fixed.
- Continue through the preview to Fix records, tick the confirmation and click Start backfill.
- Check history shows the result of each run, with an Undo for 30 days. Undo puts back the values that run changed and leaves alone anything someone edited since.
What TidyAddress does not do
- It does not guess. When a postal code is impossible, or Google is not confident about an address, the record is left alone and counted as left for review.
- It does not replace your wording of a street when Google only abbreviates it, so "Bahnhofplatz" never becomes "Bahnhofpl.". It does take Google's capital letters and puts the house number where the country expects it, so "15 bahnhofplatz" in Zürich becomes "Bahnhofplatz 15".
- It stores no map coordinates and does not check whether a phone line is active.
The result
In the video, the contact Hannah Kästner starts with phone 089 99998 198, city "münchen" and no postal code. After the backfill the record shows +49 89 99998198, München and postal code 80331.
Every step, including the record card, settings and disconnect, is in the setup guide.
Support
Write to [email protected] in English. We answer within 2 business days, and within 24 hours for critical issues.
TidyAddress is independent of HubSpot, Inc., and is not authorized by, endorsed by, sponsored by, affiliated with, or otherwise approved by HubSpot, Inc. HubSpot is a registered trademark of HubSpot, Inc.