How to Pass This Data

[saddiq]

How do i pass this webhook data to Google Sheets?

direct
m.facebook.com
l.facebook.com
lm.facebook.com
tiktok.com


I want all facebook url (m.facebook, l.facebook, lm.facebook) to turn into facebook.com only.
For direct and tiktok.com no rules. They will pass to google sheet as it is.

 

[Pabblymember11]

Hey @saddiq

Please check out the following screenshot for your concern where we have used the "Lookup table". Kindly try this at your end and let us know if that works for you.

 

[saddiq]

Hey @saddiq

Please check out the following screenshot for your concern where we have used the "Lookup table". Kindly try this at your end and let us know if that works for you.

View attachment 8402

Thank you. It works. Really appreaciate your help.