Sk developer This workflow corresponds to n8n.io template #6479 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "ae2548f3-672a-4fe2-9d1e-04c98bac8e26",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3ceca160-6e38-42db-8175-a64e5d56cdf4",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
220,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "url",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "31e4f63b-30a7-4bda-b08a-85306912ca34",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
560,
0
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "ff87e1b1-858b-4f99-89b2-9396a151626b",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
840,
20
],
"parameters": {
"url": "https://phone-number-validator11.p.rapidapi.com/phone.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "phone",
"value": "={{ $json.phone }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "phone-number-validator11.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"retryOnFail": false,
"typeVersion": 4.2
},
{
"id": "e61fda30-c825-4d14-aabf-04ce8bbbf3ca",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1200,
180
],
"parameters": {
"columns": {
"value": {
"phone": "={{ $('Google Sheets').item.json.phone }}",
"country": "={{ $json.country }}",
"is_valid": "={{ $json.is_valid }}",
"location": "={{ $json.location }}",
"timezone": "={{ $json.timezones[0] }}"
},
"schema": [
{
"id": "phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_valid",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_valid",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "timezone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "timezone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"phone"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "url",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "27898315-d755-48c7-8da0-a560ef937c89",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-840,
-180
],
"parameters": {
"width": 560,
"height": 700,
"content": "# \ud83d\udccb Phone Number Validation with Google Sheets \n\n## \ud83e\udde9 **Use Case**\nAutomatically validate phone numbers from a Google Sheet using RapidAPI and update the results back to the same sheet.\n\n## \u2705 **Benefits**\n- Automates phone validation \n- Enriches data with location, country, timezone \n- Reduces manual effort \n- Handles batch processing \n- Continues on errors \n\n---\n\n## \ud83e\uddf1 **Node-by-Node Explanation**\n\n- **\ud83d\udd18 When clicking \u2018Execute workflow\u2019** \u2013 Manually triggers the workflow. \n- **\ud83d\udcc4 Google Sheets** \u2013 Reads phone numbers from a Google Sheet. \n- **\ud83d\udd01 Loop Over Items** \u2013 Iterates over each row/phone number. \n- **\ud83c\udf10 HTTP Request** \u2013 Sends phone number to RapidAPI for validation. \n- **\ud83d\udce5 Google Sheets1** \u2013 Updates the sheet with validation results (is_valid, country, location, timezone). \n"
},
"typeVersion": 1
},
{
"id": "773175b3-9bf1-4843-81ea-f809c883f10e",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-180
],
"parameters": {
"height": 340,
"content": "### \ud83d\udd18 When clicking \u2018Execute workflow\u2019\nManually starts the workflow from the n8n editor. \nUsed during development or one-time execution."
},
"typeVersion": 1
},
{
"id": "00f5d71c-1a2e-4006-9111-46b6a863475b",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
-180
],
"parameters": {
"height": 340,
"content": "### \ud83d\udcc4 Google Sheets (Read)\nFetches phone numbers from a specified Google Sheet. \nUses a service account for authentication and reads all rows."
},
"typeVersion": 1
},
{
"id": "bac029d1-2ce5-4499-a1b9-9d9d2112f196",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-180
],
"parameters": {
"height": 340,
"content": "### \ud83d\udd01 Loop Over Items (Split In Batches)\nLoops through each phone number one at a time. \nEnsures individual API processing per phone number."
},
"typeVersion": 1
},
{
"id": "6fa7f8c8-7c17-4f83-a698-9ecc36201626",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
-180
],
"parameters": {
"height": 340,
"content": "### \ud83c\udf10 HTTP Request (RapidAPI)\nSends a POST request to the RapidAPI phone validation endpoint. \nReceives validation results like `is_valid`, `country`, `location`, and `timezone`."
},
"typeVersion": 1
},
{
"id": "32337c3b-6b95-46ac-b563-3ad05c55892c",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1140,
-40
],
"parameters": {
"height": 420,
"content": "\n### \ud83d\udce5 Google Sheets1 (Update)\nUpdates the original row in the Google Sheet with the API response. \nMatches based on the phone number and adds new data to columns."
},
"typeVersion": 1
}
],
"connections": {
"HTTP Request": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Validate and enrich phone numbers from Google Sheets using the [](https://rapidapi.com/skdeveloper/api/phone-number-validator11) API.
Source: https://n8n.io/workflows/6479/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This n8n workflow fetches URLs from an RSS feed, checks which URLs have a valid RSS feed and if true, fetches the latest articles from those URLs. It then stores the article details, including the art
RSS Feed Read, Stop And Error, Google Sheets +1
This workflow allows you to generate QR codes (Barcodes) in bulk from a Google Sheets file and store the generated QR images automatically in Google Drive. Each QR code contains a unique identifier (i
Google Drive, HTTP Request, Google Sheets
Automatically extracts all page URLs from website sitemaps, filters out unwanted sitemap links, and saves clean URLs to Google Sheets for SEO analysis and reporting.
Form Trigger, HTTP Request, Google Sheets
Workflow Description Automate your candidate interview pipeline with precision. This powerful integration pulls booking data from Cal.com, extracts interview details (name, email, date & time), and sy
HTTP Request, Google Sheets
I built this tool because we faced a real, recurring problem: managing hundreds of client projects in a weekly automated loop.
Stop And Error, Redis, Execute Workflow Trigger +2