How to format phone number in Make for WhatsApp API? (remove spaces, symbols, and add country code)

How To
, ,
1

Hi everyone! I’m a beginner on Make, and I’m building an automation scenario for a customer reactivation bot. The flow starts with a Google Form, which sends data to a Google Sheet. On Make, I use the Watch Rows module to fetch the data and then a Set Multiple Variables module to organize the values from the form.

Now I’m trying to format the phone number, because it comes in with spaces, parentheses, and hyphens (e.g.: (31) 97583-9662). I need to clean it and format it correctly for sending via WhatsApp API, like this: 5531975839662.

I tried using functions like replaceAll, replace, concat, but none of them seem to work in my current setup. I’ve seen tutorials using replaceAll, but from my testing, it looks like this function is no longer available in Make as of 2025.

How can I remove all the spaces, hyphens, parentheses and add the 55 prefix at the beginning of the number, using an expression that actually works on Make today?

Thanks a lot for your help!

2

Hey Joao,

you can either stack replace() functions for each different item you want removed or you can try the Parse a Phone Number module.