Validate & Enrich Phone Numbers in Google Sheets with RapidAPI

Created by

Sk developer

Last update

Last update 23 days ago

📞 Phone Number Validator with Google Sheets

Validate and enrich phone numbers from Google Sheets using the phone number validator API.

📌 Use Case: Contact Validation & Enrichment

Automatically check if phone numbers are valid and enrich them with metadata (country, location, timezone). Ideal for CRMs, lead management, and contact cleanup workflows.

🗂️ Google Sheets Columns

Column Name	Description
`phone`	The original phone number to validate (input column).
`is_valid`	Result from API indicating if the phone number is valid (`true` / `false`).
`country`	Country where the phone number is registered (e.g. "US").
`location`	More specific location info, such as city or region.
`timezone`	The primary timezone associated with the phone number.

🎯 Benefits

✅ Accurate Contact Data – Identify invalid or fake phone numbers automatically.
🌐 Geolocation Enrichment – Add country, location, and timezone for better segmentation.
🔁 Full Automation – No manual lookups or copying data between tools.
📊 Live Google Sheets Sync – Enriched data is updated directly into your spreadsheet.

🧠 Workflow Nodes Explained

Node	Purpose
🟢 Manual Trigger	Starts the workflow manually from n8n.
📄 Google Sheets (Read)	Fetches phone numbers from your spreadsheet using a Service Account.
🔁 Split In Batches	Loops over each row one at a time to handle individual API requests.
🌐 HTTP Request	Sends phone number to `phone number validator` via RapidAPI and receives validation + metadata.
📥 Google Sheets (Update)	Writes the response back into the matching row using the `phone` field.

🛰️ API Used: `phone number validator`

We use the phone number validator API from RapidAPI to:

Validate phone numbers (real or fake?)
Identify the country, location, and timezone

It’s fast, reliable, and great for cleaning large datasets or qualifying leads before outreach.

🧰 Prerequisites

📄 A Google Sheet with a column named phone
🔐 RapidAPI key with access to phone number validator
🔧 Google Service Account credentials set up in n8n

🚀 How to Use

🔗 Link your Google Sheet and configure authentication
🔑 Add your RapidAPI key in the HTTP node headers
▶️ Click "Execute Workflow"
🧠 Each phone number is validated and enriched
📊 Results are written back to your Google Sheet

📎 Tags

phone validation, rapidapi, google sheets, data enrichment, phone number validator, crm automation, lead cleaning, timezone lookup