I am looking into implementing Hoosh's Excel webhook into our Marketo instance, and I wanted to see if anyone had any information on whether we are able to use VLOOKUP or any other formula to cross-reference a specific field.
What I want to do is the following:
- Pull out the email domain from the {{lead.Email Address}} record [I can do this part]
- After doing that, I want to cross-reference that email domain with a master list to match it up with our Account Manager's email address (this is essentially the VLOOKUP style function that I am looking for)
The reason that we would need to do this is because we have an API from our corporate site where only the lead data gets input into our Marketo instance. The Account Manager email address is not something that automatically populates when someone is created in Marketo.
.png)