使用RapidAPI验证和丰富Google表格中的电话号码
中级
这是一个Lead Generation领域的自动化工作流，包含 11 个节点。主要使用 HttpRequest, GoogleSheets, ManualTrigger, SplitInBatches 等节点。 使用RapidAPI验证和丰富Google表格中的电话号码
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "ae2548f3-672a-4fe2-9d1e-04c98bac8e26",
"name": "当点击\"执行工作流\"时",
"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": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "31e4f63b-30a7-4bda-b08a-85306912ca34",
"name": "循环处理项目",
"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": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "27898315-d755-48c7-8da0-a560ef937c89",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-840,
-180
],
"parameters": {
"width": 560,
"height": 700,
"content": "# 📋 使用Google Sheets进行电话号码验证"
},
"typeVersion": 1
},
{
"id": "773175b3-9bf1-4843-81ea-f809c883f10e",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-180
],
"parameters": {
"height": 340,
"content": "### 🔘 当点击\"执行工作流\""
},
"typeVersion": 1
},
{
"id": "00f5d71c-1a2e-4006-9111-46b6a863475b",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
-180
],
"parameters": {
"height": 340,
"content": "### 📄 Google Sheets（读取）"
},
"typeVersion": 1
},
{
"id": "bac029d1-2ce5-4499-a1b9-9d9d2112f196",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-180
],
"parameters": {
"height": 340,
"content": "### 🔁 循环处理项目（分批拆分）"
},
"typeVersion": 1
},
{
"id": "6fa7f8c8-7c17-4f83-a698-9ecc36201626",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
-180
],
"parameters": {
"height": 340,
"content": "### 🌐 HTTP Request（RapidAPI）"
},
"typeVersion": 1
},
{
"id": "32337c3b-6b95-46ac-b563-3ad05c55892c",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1140,
-40
],
"parameters": {
"height": 420,
"content": "### 📥 Google Sheets1（更新）"
},
"typeVersion": 1
}
],
"pinData": {},
"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 ‘Execute workflow’": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在 Google Sheets 中使用 Email Validator AI 自动化邮件验证
使用 Email Validator AI 在 Google Sheets 中实现邮件验证自动化
Http Request
Google Sheets
Manual Trigger
+2
11 节点Sk developer
潜在客户开发
批量下载无水印TikTok视频至Google Drive并追踪
批量下载无水印TikTok视频至Google Drive并追踪
Wait
Google Drive
Http Request
+4
21 节点Sk developer
文件管理
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
使用ZoomInfo、Serper和Oxylabs到Google Sheets自动化公司数据丰富
通过ZoomInfo、Serper和Oxylabs到Google Sheets自动化公司数据丰富
If
Code
Html
+6
19 节点Naveen Choudhary
潜在客户开发
使用 Anymail Finder 根据公司名称查找邮箱
使用 Anymail Finder、Google Sheets 和 Telegram 提醒自动化公司邮箱发现
Switch
Telegram
Http Request
+4
12 节点Davide
潜在客户开发
