Validate & Enrich Phone Numbers in Google Sheets with RapidAPI

Description

📞 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