Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

My zapier function gets some data from a webhook , such as Client Name, Client phone, etc. and it also contains the URL.

then I cross reference the URL on a google sheet table to figure out where to send it to.

My issue is that the URL that comes in on the webhook is 1 or 2 formats

domain.com/page or domain.com/page/ (one has a trailing slash and the other dosent)

and when I cross reference, I dont want to have to split and duplicate function for a version with and without a trailing slash

 

so Im trying to do something like dynamic value] || dynamic value]/ as the lookup value for the excel column, but that dosent work. 

 

Ive tried making the website 100% send the data with a trailing slash but that is way to complicated. Ive tried htaccess and all this stuff, and it still isnt 100% consistent. any ideas?

@Dane M 

This looks to be a duplicate of your other topic:

 

Terms & Conditions