Verify or update phone country code for WhatsApp.
Status: Closed · Asked by Gil on · 0 views
Our lead capture form collects country and WhatsApp number onto Google sheets but some people forget to put the country code as part of the WhatsApp number entered. Has anyone created a workflow to lookup the country code and verify that it is correct or add the missing country code before being sent to WhatsApp?
Hey @Gil
If your audience is from the same country then you can use the following spreadsheet formula.
Kindly try this on your end and let us know how it works for you.
CONCATENATE('+91',(right('2. Result : +37067400200',10)))
