The desired workflow is attached as an image.
We are using JotForm and Zendesk Sell (CRM)
Zapier is checking ZDSell to see if the email address supplied in the form submission matches at the COMPANY, PERSON, or LEAD level. It must check in that order.
If it finds the email at any of those levels, I'd use a Filter to determine the state and then create a ZDSell Task (which is an "event") and assign it to the designated rep for that state.
If it does not find the email in any of those levels, it finally creates a new ZDSell Lead (which is a event)
My thought was to have 3 separate zaps for each of the lookups (yellow boxes) and upon failure it would look at the next zap in line. It doesn't look like I can do that.
Any help to get my Zaps to trigger in that order?
Best answer by steph.n
Jamie had recommended checking out the Lookup Table and a Formatter to help simplify that setup.
For example, you could use a Lookup Table for all the green and blue sections. You can have a separate row for each of those possible states (A,B,C,X,Y,Z) and then add a fallback value for Manager. You could then use the output of that Lookup Table as the assignee ID.
You can read more on using an setting up Lookup Tables here:
Please let us know if you have any further questions!