Need to extract second phone number from email

Question

I need to extra the 2nd phone number from gmail leads that come in daily.

As you can see from the pic, this automated lead always includes the lead companies 800 number before the actual lead phone number lower in the email body.

I’m extracting the lead phone numbers then sending them to an automated text sequence

Is there a way to filter out zapier from extracting the 800 email (it comes through as the same number in every email).

Or is there a way to extract multiple numbers as separate outputs to choose from?

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Troy Tessalone · Accepted Answer

Hi @bdtcryptoTry these Zap steps...Action: Formatter > Text > Split (Split “Phone:” and keep the last segment)Action: Formatter > Text > Extract Phone Number

bdtcrypto · Answer

yep that was it! thank you, this video tutorial also helped explain it very well:https://www.youtube.com/watch?v=NWx_YBugE9U

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded