Best answer

Need to extract second phone number from email

  • 8 January 2022
  • 2 replies
  • 159 views

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. 

icon

Best answer by Troy Tessalone 8 January 2022, 17:43

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @bdtcrypto 

Try these Zap steps...

Action: Formatter > Text > Split (Split “Phone:” and keep the last segment)

Action: Formatter > Text > Extract Phone Number

 

yep that was it! thank you, this video tutorial also helped explain it very well:

https://www.youtube.com/watch?v=NWx_YBugE9U