I have my emails connected to Zapier so that when I get an email it creates a pipedrive contact. How can I easily add their phone number to the contact? Currently I am searching the email for a number and using that as the phone number. It has been successful until someone has numbers in their email address (such as firstname.lastname@example.org).
Note: The emails are from a website contact form so there are only limited fields that pull through. So the number is always after the word ‘Phone’.
Best answer by robschmidt
Assuming you have already tried “Phone Number Extract” formatter. There is another formatter you can use to extract phone number out of an email.
The formatter is located here: Formatter > Text > Extract pattern, then use this
This will extract US phone number, you can check out more codes here: https://regexlib.com/Search.aspx?k=phone&AspxAutoDetectCookieSupport=1
Alternatively you can use Zapier mail parser to get phone number.