Is there any way to set logic that automatically changes a given lead’s country name to a value before passing it through to CRM:
| Country | Value |
| Afghanistan | AFG |
| Albania | ALB |
| Algeria | DZA |
| Andorra | AND |
Page 1 / 1
Hi
There are a few ways you could tackle this, but in the end what you’re looking for is a lookup table.
You can use the Lookup Table in our Formatter app, but if you’re looking to re-use this across Zaps then I’d suggest something like Google Sheets, Excel, or Airtable. You could also check out our very own Zapier Tables (currently in beta).
The concept will be the same regardless of which option you choose. Make a table much like what you showed in the screenshot, add a step to your Zap that searches the table (make sure that what your trigger provides matches what’s in your table) then in your CRM step you map the result from your search :)
This example should give you a good idea of what I’m suggesting:
The example given is about country codes too :)
Hi
Resources about Lookup Tables:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.