Skip to main content

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?

Hi @AI_hello 

Good question.

You can add a Formatter > Text > Split step and then keep the first segment.