I have a newsletter tracking app that stores emails from various e-commerce brands.
Whenever we receive a new email, a webhook workflow is triggered, sending me the email subject, brand name, date, email body HTML, and other information through the webhook.
I have a drop-down field called promotion type in the email database which has basically options like (using option sets) % off, $ off, coupon, etc.
Now I want to check if the subject line contains the word % discount, then I want to map the promotion type as % off option, but if it contains coupon then I want to map it as coupon option, and so on.
make your option set display value the same as the values returned from the webhook…then when webhook value subject line is checked against the option set display values you can use the get option all values filtered this webhook subject line contains this options display value.
Can you please elaborate in a bit detail as I’m not able to figure out this?
make your option set display value the same as the values returned from the webhook
I can’t because Webhook is just giving me the subject line which is a text field.
Now I want to check if the subject line text contains the word x1, or x2, x3… then it should set the option set as x but if not then it should check for another list of words like y1, y2, y3,… and if they are present then it should set the option set as y and so on…
