Streamline Phone Number Verification With and Numverify

by | Jan 17, 2024

Businesses often integrate a phone validator into their workflow to ensure they have valid phone numbers of genuine customers. Phone number verification helps businesses prevent fraud and enhance security, customer experience, and operational efficiency. 

In this guide, we’ll show a step-by-step process of creating an automated, no-code workflow for phone number verification. We’ll use Google Forms, Google Sheets, and Numverify to automate our workflow. is a powerful automation platform that allows users to connect various apps and services to automate workflows and processes without the need for extensive programming knowledge. 

Numverify is a leading and widely trusted phone number verification and lookup API that supports over 232 countries. It supports both national and international numbering plans. In addition to verifying phone numbers, the phone validator tool also supports carrier and line-type detection. The API is known for its high accuracy, speed, scalability, and ease of use. 

Integrating Google Forms, Numverify API, and Google Sheets for Efficient Data Management

An illustrated hand interacts with a smartphone screen displaying a location pin icon, symbolizing geolocation services. In the background, a Google Sheets document with data points and charts connects to the phone, representing the integration of data management and mapping technology.

Accuracy in customer contact information is crucial for any business. With the advent of no-code platforms like, you can now automate the process of verifying phone numbers provided by customers through Google Forms, ensuring the data’s reliability without writing a single line of code. 

In this detailed how-to guide, we will show you how to: 

  • Setup a Google Form so that you can collect user phone numbers online into a Google Sheet
  • Set up a Numverify account and get a free Numverify API key.
  • We will show you how to link your Numverify API key to the platform to access the Numverify API and update the Google Sheet with data verifying your users’ phone numbers.

By the end of this tutorial, you will have a fully automated system in place. This system will not only capture user phone numbers through a Google Form but also verify their authenticity via Numverify and record the results in a Google Sheet. The entire process is streamlined and automated, offering you a hassle-free way to maintain the integrity of your customer contact data.

Automated Phone Number Verification Workflow: Step-by-Step Guide

Step 1: Capturing Data with Google Forms

Our process kicks off with a Google Form, a versatile tool that allows businesses to gather information directly from customers. Once a form is submitted, the data is automatically passed to a connected Google Sheet, ready to be processed.

You can easily set up a form that collects user information using Google Forms ( ) and parses the data collected from the form to a spreadsheet on Google Sheets.

Here’s how to do it:

Go to Google Forms and create a new form.

Screenshot of the Google Forms start page, ready to be used for Automated Phone Number Verification.

Now add the ‘Phone Number’ field in your form as a short answer to collect users’ phone numbers. You can also add other fields, depending on your requirements.

form to collect phone Numbers to validate them using a phone number validation tool

Navigate to the responses tab and click on ‘Link to Sheets’. This will allow the responses can be parsed to a Google Sheets spreadsheet.

Link to Sheets

Once you have chosen ‘Link to Sheets’, you will have various options. Choose the option that works for you. For this demonstration, we will select the option ‘Create a new spreadsheet’.

Creating a new spreadsheet to validate phone numbers

You can rename the Google Form or the Google Sheet at any stage, but they will still be connected to each other. On the Google Sheet created below, when a phone number is submitted on the Google form, the Phone Number will appear under column B.

Google sheet for automated phone verification workflow

If you are new to ‘Google Forms’ note that you can share the link to the form you have created by clicking on the ‘Send’ button in Google Forms.

Send’ button in Google Forms.

Select the link icon to get the link address, anyone who has access to this link address can fill out your form.

access to this link address

Preparing the Google Sheet

In our example for demonstrating the capabilities of the Numverify API, we shall rename the Google Sheet to ‘PhoneNumbers’ and expand the descriptions in the first row columns to include the following fields:

What is your phone number?
Local Format
International Format
Country Prefix
Country Code
Country Name
Line Type
Spreadsheet for automated phone verification workflow

Next, we need to sign up to It will help us create the following automated scenario:

  • Analyze phone numbers that have been parsed to the spreadsheet.
  • Perform phone number verification using the Numverify API.
  • Automatically populate the details in the adjacent columns in the spreadsheet.

Step 2: Monitoring New Entries with

Sign up for to create a scenario. You’ll find the  “Scenario icon” in the menu

Creating a new scenario in for automated phone verification workflow

Then click the ‘+ Create a new scenario’ button

 Creating a new scenario in for automated phone verification workflow

In the ‘Empty integration screen’, click the ‘+’ button.

Linking to Google Sheets

Search for ‘Google Sheets’

Linking to Google Sheets

Set the Google Sheet to ‘Watch New Rows’ of data. This acts as the initial trigger for our automated workflow.

Watch New Rows

Connect your Google Account by clicking ‘Add’ to add your Google connection.

Connecting to Google Account

At this point, you should be able to link into your spreadsheet and automatically indicate which sheet in the spreadsheet is collecting the phone responses, e.g. Sheet 1 (or the sheet name might be named after your Google form).

Select the options in the image below, e.g. Table contains headers, and indicate the columns that have named headers in ‘Row with headers’.

A limit of 1 is used for testing purposes, but if you want to bulk update your spreadsheet with multiple phone numbers to be verified, you can set the limit higher (note that this should also be within your Numverify API rate limit).

Connecting to Google Account

Step 3: Making the Numverify API Call

As we mentioned earlier, we’ll use the numverify API for phone number verification. To use numverify, you’ll need to sign up for a Numverify account at ​​ . Once you’ve successfully created your account, you’ll get your unique API key (available in your numverify dashboard).

This step is essential before you can add the HTTP module to

Numverify phone verification API dashboard

To test the Numverify API, paste this url into a new browser tab after adding your API key and a phone number

Testing Numverify phone verification tool in browser

You will need this URL and the output later.

You are now ready to add and use the ‘HTTP’ and JSON modules to

Adding HTTP module in

Click ‘+’ button and search for the HTTP module to add it to your scenario.

Adding HTTP module in

Next, select ‘Make a request’ (you’ll find this option under ACTIONS):

Making an HTTP request

When you open the HTTP module, in the URL section, paste this url into it (remember to add your own API key)

After ‘number=’, when you click on the white space, the spreadsheet fields will appear. Click on the field that represents the users’ phone number on the spreadsheet to add it to the URL tab.

Interface snapshot showing an HTTP GET request setup for automated phone number verification, linking a Numverify API call to a Google Sheets column for data validation.

In the Method section, select ‘GET’.

Upon detecting a new phone number entry,’s “HTTP” module steps in to perform a GET request to the Numverify API. This module sends the phone number for validation and waits for a response. This interaction is secured with your Numverify API key, which authenticates the request.

Step 4: Parsing and Analyzing the Data

The data returned from Numverify is in JSON format. It contains details about the phone number’s validity, its international format, country code, and more. 

Adding JSON module in

For the next step, you will need to the JSON module to your workflow. Find the “JSON” module in to be able to parse the information returned by numverify to other modules.

Click the  ‘+’ button and search for the JSON module to add it to your scenario.

Adding JSON module in

After selecting the JSON module, at the next screen choose Parse JSON.

Parsing JSON data

In the ‘Data structure section’, click the ‘Add’ button, this will open another window.

Parsing JSON data

In this window, click the ‘Generate’ button.

Parsing JSON data

Remember, in Step 3, we opened a new tab in our browser and pasted the following URL:

Check the results in the new browser tab now, as you will need to paste them into the next screen. If you didn’t create a new browser tab at Step 3 or it got closed, repeat Step 3 to generate API data results.

Paste the information returned in the browser to the Sample data section, and click ‘Generate’.

Adding sample JSON data

Next, you will need to update the JSON string section, referencing it to the ‘Data’ field from the HTTP module.

Parsing JSON data

Step 5: Updating the Google Sheet with Validation Results

The heart of our workflow is the Google Sheet module “Update a Row”. It automatically updates the Google Sheet with the phone number verification results from Numverify, appending information such as whether the number is valid, its standardized format, and country specifics.

You will need to add a new Google Sheets module. Then, select the action ‘Update a Row’.

 adding a new Google Sheets module

Populate the next form with the following options that reference the spreadsheet fields so that it links back to the Google sheet.

Populating Google forms

Populate the column sections of the form referencing it to the JSON module fields (these are the empty columns of the spreadsheet that you want to parse the JSON fields to). Skip columns such as A and B, which will have a time stamp and the phone number.

populating the form

Having successfully filled out the ‘Update a Row’ action form, which links back to the necessary spreadsheet and JSON fields, is now equipped to refresh the spreadsheet with the API results for each phone number whenever a scenario is executed.

Your final scenario screen will look like this:

Automated Phone number verification workflow

Click ‘Run once’ to run the scenario.

Automated Phone number verification workflow

The empty columns on your spreadsheet should update with the validation results

Automated Phone number verification workflow results

Step 6: Scheduling Regular Updates (Advanced)

For businesses that require regular data updates, offers scheduling options. By using a timer, you can set the workflow to run at regular intervals. This will ensure that even entries not immediately processed are verified in a timely manner.

Step 7: Bulk Update of Google Sheet

If your Google Sheet is receiving a high volume of phone numbers, you can opt for bulk phone number validation. To do so, consider increasing the ‘Limit’ size.

Cost Savings & Boosting CRM Efficiency with Numverify Phone Validation

Using a service like Numverify for phone number validation can lead to significant cost savings, particularly when managing customer data in a hosted CRM system. By ensuring that all phone numbers are valid, Numverify helps in reducing the presence of redundant or incorrect numbers. This not only streamlines the database but also avoids potential revenue loss associated with contacting invalid numbers. 

Effective validation reduces the time and resources spent on managing incorrect data, thus contributing to overall efficiency and cost-effectiveness in customer relationship management.

Having correct phone numbers can save costs in various ways, even if not using a paid-hosted CRM system:

1. Efficient Communication: Valid numbers ensure effective and timely communication with customers, reducing the time and resources spent on unsuccessful contact attempts.

2. Marketing Campaigns: Correct numbers improve the success rate of marketing campaigns, preventing wastage of resources on non-existent or incorrect contacts.

3. Customer Satisfaction: Accurate contact information leads to better customer service and satisfaction, enhancing the company’s reputation and potentially leading to more business.

4. Data Analysis: Reliable data contributes to more accurate analytics and business decisions.

5. Compliance and Legal Costs: Avoiding calls to numbers on Do Not Call lists or in regions with strict regulations helps prevent legal issues and potential fines.

In summary, validating phone numbers with a tool like Numverify can lead to operational efficiency, improved customer relationships, and avoidance of unnecessary legal and compliance costs.


Let’s take a moment to reflect on what we’ve accomplished together in this guide. Through using, numverify, Google Sheets, and Google Forms, we’ve created an automated, no-code workflow. This isn’t just about phone number verification; it’s about making your business processes more efficient and your data management more reliable.

By following the steps we’ve outlined, you’re well on your way to implementing a similar system in your own business. Imagine the time and resources you’ll save, not to mention the boost in confidence you’ll have in your customer data.

Now that you’ve got the hang of using the HTTP module on and integrating it with services like Numverify, why stop there? API Layer offers a wide range of APIs that you can explore and integrate into your workflows. Each API opens up a new possibility, a new solution to a problem you might not even know you had.


How can I verify a phone number?

You can use a reliable and accurate Phone Number Validation API like numverify to verify phone numbers.

How to check if a telephone number is genuine?

With numverify, you can validate and verify any phone number to confirm if it’s genuine and authentic.

How to check the phone number owner?

Some apps like TrueCaller let you check who owns a phone number.

How does phone number validation work?

Phone validation helps businesses identify genuine and active phone numbers. It involves:

  • Verifying the format of the number
  • Confirming if the number has the correct number of digits and the proper placement of the country code.