Normalize Phone Number

How to find this variable?

The phone number can be sourced from business cards, company websites, customer databases, or contact forms. The country information is usually provided alongside the phone number in databases or user profiles.

How to use it?

Using the E.164 formatted phone number ensures compatibility with telecommunication systems and software that require international dialing standards, such as VoIP services, SMS gateways, and mobile communication apps.

Use cases

CRM Systems: Store and manage contact information in E.164 format to facilitate automated dialing and messaging directly from the system.

Marketing Campaigns: Use standardized phone numbers for SMS marketing to ensure messages are delivered without issues related to international formatting errors.

Data Integration: Simplify data integration processes between different systems (like customer service tools and marketing platforms) by using a uniform phone number format.

The prompt

Normalize the phone number specified in the input with a E.164 format.

If the input is empty, output 'N/A'
Remove all quotes from the Output

Input:
phone number: "{{phone 2}}"
country: [NAME OF THE COUNTRY]

Output:

copy prompt

Your input

Phone number: ‘415-555-2671’

Country: ‘USA’

Your output

+14155552671

How to implement

1
Step 1: Open your “Lead list” in your lemlist campaign.
2
Step 2: Create a new column and select “Create AI column”. Enter the name of your AI variable and click “Save”.
3
Step 3: Paste the prompt and click “Generate”!
Use this prompt in lemlist
Copy this prompt to the clipboard
Why this prompt?
Format and normalize phone numbers to e164, international, and national formats

Related Prompts

Behavior Signals

Perplexity - What is the most recent feature added

What is the most recent feature added by a company
sales
Sales teams
Behavior Signals

Perplexity - which VCs backed a company

Find which VCs have backed a company
founders
Founders & CEOs
Behavior Signals

Recent market reports published

Create catchy messages using new market report insights.
investment
Finance & Investment (VCs, wealth management)

How to leverage the full power of prompts with lemlist AI variables

1

Generate an AI variable from leads

Top 1% sales reps use this AI-powered workflow to automate outreach and book meetings effortlessly.
2

Analyze & sort with AI

Add your prompt or choose the best-performing ones from the library, without leaving the lemlist app.
3

Get clean & segmented info

Segment leads for ultra-targeted approach, craft personalized icebreakers, and clean messy copies.

“Emails generated are short and respect copywriting standards. The AI did some research to add relevant content to the messaging!”

Philippe Araba
Business Developer @Shortways

“The process was very simple, and I like the scripts proposed!”

Lucia Lehmann
Sales Manager @Inside Sales

“Amazing! Especially for a dinosaur in tech like me, it’s magical! Got a full personalized sequence only after 3 minutes!“

Nadja El Fertasi
Consultancy @Thrive with EQ

"Huge time saver - it saves us between 5 and 8 minutes to create personalization per each lead."

Ali Rahmani
Co-Founder @Tango Prospection

"I find the results quite impressive. I only spend a little bit of time to tweak the final copy."

Arnaud Renoux
Founder @The Scalelab