FM
FlowMarket
General Automation Intermediate ⚡ 7 n8n Nodes

Standardize US phone numbers with multiple format options and va

Workflow Overview: This n8n workflow template takes a US phone number as input, validates it, and returns it in multiple standard formats, including handling...

🔌 Nodes & Integrations Used (1)

Execute Workflow Trigger

📖 Implementation & Setup Guide

Workflow Overview:

This n8n workflow template takes a US phone number as input, validates it, and returns it in multiple standard formats, including handling extensions. It's designed to streamline the process of standardizing phone number data within your automations.

How it Works:

**Input:** Accepts a phone number string as input. This number can be in various common formats (e.g., `(555) 123-4567`, `555.123.4567`, `+15551234567`, `5551234567x890`).

**Formatting Removal:** Strips all non-numeric characters to isolate the core number and any potential extension.

**Validation:**

  • **Country Code Check:** Verifies if the number starts with the US country code (`+1` or `1`) or assumes US if no country code is present and the length is correct.
  • **Length Check:** Ensures the main number component consists of exactly 10 digits after stripping formatting and the country code.

**Output Generation (if valid):** If the number passes validation, the workflow outputs the phone number in several standardized formats:

  • **Number Only:** 5551234567
  • **E.164 Standard:** +15551234567
  • **National Standard:** (555) 123-4567
  • **Full National Standard:** 1 (555) 123-4567
  • **International Standard:** 00-1-555-123-4567

**Extension Handling:** If an extension is detected in the input, it is separated and provided as:

  • **Extension (Number):** 890
  • **Extension (String):** "890"

**Use Cases:**

  • Cleaning and standardizing phone number data in CRM systems.
  • Formatting numbers before sending SMS messages via APIs.
  • Validating user input from forms.
  • Ensuring consistent phone number representation across different applications.

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Standardize_US_phone_numbers_with_multiple_format_options_and_va.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related General Automation Workflows

View All in General Automation →