Skip to main content

Hi, I am gathering instagram handle’s from a googlesheet.

Then using that handle to search in a trello board.

However some people put the @ sign before their IG handle… like @harriethrose instead of just harriethrose.

This causes issues in the zap finding the card in trello if the card doesn’t have an @ but the row in googlesheets does have an @.

Is there a way to modify the data on the spreadsheet row + column to remove an @ sign?

Thanks

Hiya @Harriet H Rose! Thanks for reaching out and welcome to the community!

I wonder if Formatter by Zapier may work for you here! You may be able to use a Text Formatter step to find the “@” symbol and delete in from that field.

Here’s a few other resources on Formatter in case it’s helpful.

Keep us in the loop! We’d love to know if this works for ya. 🤗