Skip to main content

Brief - We have a form in a landing page with field for

Email and Phone number.

When user submit form, data get entered in Google Sheet via Zapier.

Problem - User are entering text or sometimes 9 digit number in phone field.

Preferred Solution - We want phone number validation step in Zapier to get valid number numbers in Google Sheet.

Hi @aJAX 

Welcome to the Community! Thanks for your interest in Zapier.

You can add a Formatter by Zapier action step. The event is Numbers and in the transform field, select Format Phone Number.

Here are helpful articles in regards to the Formatter step:

 

Hopefully this helps!