Question

Trouble With Zapier and Facebook Leads - Formatter

  • 6 January 2022
  • 1 reply
  • 28 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.


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

Userlevel 7
Badge +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