we have a zap that takes a pushed message from Slack, strips out the URL using the Extract URL function in Zapier Formatter & puts the URL into a google spreadsheet. mostly this is working great.
however, for some of the Slack messages, it’s putting the URL twice, with a line between them, like this: https://www.google.com|https://www.google.com.
this is annoying, because then the spreadsheet user can’t click on the link & the heading scraper i have in my spreadsheet won’t work.
i can’t figure out how to fix it. any ideas?