Slack - Create channel from google sheet

[Eliane_Ngami]

Hi,

Im trying to create multiple private channels in slack using goolge sheet added rows.
I keep getting the error : invalid_name_specials (200)
Can someone please help. Here is a screenshot of my scenario.
Thank you in advance.

[ManishMandot]

Hey @Eliane_Ngami
Welcome to the Make Community

May I know what is the data in first name ?
and Regex will not work here
You will have to replace space with - (dash)

Thanks

[samliew]

Welcome to the Make community!

Try your regex without the double quotes like this:

{{replace(lower(1.A); "/[^a-z]+/g"; emptystring)}}