Skip to main content
Question

Trouble With Zapier and Facebook Leads - Formatter

  • January 6, 2022
  • 1 reply
  • 31 views

The Objective: Use Zapier to automate transferring leads from Facebook to my CRM (Ometria). The data that Zapier should be taking from the Facebook Ads forms is: Email, First Name, Last Name & Country Code.

 

The Issue: I need every lead  to have the Country Code field read GB. On the Facebook form, customers can enter anything they like, but it must read GB.

 

Attempted work around: I have used Formatter by Zapier and the Transform Replace function to look up whatever the customer has entered and replace it with GB. However, I am having to create an extra step for each entry the customer may enter: Great Britain, England, UK, United Kingdom etc. This is leading to more Tasks being performed each time a new lead is acquired and I’m concerned my tasks limit will soon be reached.

 

Is there anyway to have Zapier look up multiple different things within the same Task? Perhaps by separating strings of text with a comma?

 

Thanks

 

Paul.

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Forum|alt.badge.img+14

Hi @Paulo1988 

Try using a Formatter > Utilities > Lookup Table: https://zapier.com/help/create/format/create-lookup-tables-in-zaps

 

Is there anyway to have Zapier look up multiple different things within the same Task? Perhaps by separating strings of text with a comma?

You’d need to use a Code step to do this: https://zapier.com/apps/code/help