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)
📖 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:
- Click the Direct Download JSON button above to save
Standardize_US_phone_numbers_with_multiple_format_options_and_va.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related General Automation Workflows
View All in General Automation →Generate Application Copy
Production-ready n8n automation template for Generate Application Copy built by AhiXLight. Seamlessly connects Execute Workflow Trigger, OpenAI with 4 configured nodes.
2-way sync Google Contacts and Notion
Sync your Google Contacts with your Notion database. You can filter contacts by label or sync all contacts. All contact information is kept in sync between G...
2D Image to 3D Model Automation
Production-ready n8n automation template for 2D Image to 3D Model Automation built by AhiXLight. Seamlessly connects HTTP Request, Google Sheets, Google Drive with 17 configured nodes.
2 way sync assignments completion between Canvas LMS and Notion
Syncs assignments and completion states to and fro between Canvas LMS and a Notion database. Automatically triggers every 2 hours during the schoolday by def...