Using AI in Zapier to format phone number

Posted by: Felipe Fuertes Date Posted: March 21, 2025
Back to Case Studies

Issue

Joober allows free text to be added to phone numbers, so the client adds extensions and notes to the phones. We were getting validation errors when trying to create the contact in RCFX. I tried using a RegEx, but it was still missing some cases.

Solution

Use an AI step in Zapier to extract the phone number in a standard format.

TIP: Add some static text to the prompt field so you don’t get an “Empty prompt” error if no data is available.

Achievement

Fix RCFX phone validation issues by getting the phone number in the correct format using a simple AI prompt.

Snippet/Screenshot/Link