Hello, I am building a workflow to send custom post-purchase care emails to customers via Gmail after they buy specific premium gear from our site.
I want the email to dynamically include the exact care instructions link based on what they bought. For example, if they purchase a technical item like this forclaz jackets, they need a specific care guide link injected into the body text.
Right now, I have a Lookup Table step in Zapier to match the product name to the URL, but the Zap keeps failing at the Gmail step, saying the mapped output field is empty. It seems like the lookup isn't matching the exact text string properly.
Has anyone faced this issue with Lookup Tables? Is it better to use a Webhook or Python code block instead to parse the product name? Thank you!
This post has been edited by a moderator to remove a link to self-promotional link as per our Community Code of Conduct.

