使用 Reoon 邮箱验证和 Apollo 在表格中验证并丰富 JotForm 潜在客户
中级
这是一个自动化工作流，包含 14 个节点。主要使用 If, HttpRequest, GoogleSheets, JotFormTrigger 等节点。 使用 Reoon 邮箱验证和 Apollo 在表格中验证并丰富 JotForm 潜在客户
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "8d41476c63702cd0f2be55363b48153c5d4820bb18197ca147e7be50ef236112",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "563f7548-f33f-4901-95bb-63906f42dbe0",
"name": "触发器：JotForm 提交",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
-400,
32
],
"webhookId": "f32145a7-f0e6-4574-b420-4aa42b8fac01",
"parameters": {
"form": "252806830916461"
},
"credentials": {
"jotFormApi": {
"id": "ZQzE9kLfYcfbpT81",
"name": "[Naveen]JotForm account"
}
},
"typeVersion": 1
},
{
"id": "b20bd2fb-f973-43b5-aec7-f64dfc96224a",
"name": "Sheets：创建联系人记录",
"type": "n8n-nodes-base.googleSheets",
"position": [
-192,
32
],
"parameters": {
"columns": {
"value": {
"email": "={{ $json['E-mail'] }}",
"phone": "={{ $json.Phone }}",
"message": "={{ $json.Message }}",
"last_name": "={{ $json['Last Name'] }}",
"first_name": "={{ $json['First Name'] }}"
},
"schema": [
{
"id": "first_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "message",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "overall_score",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "overall_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_deliverable",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_deliverable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_free_email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_free_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_catch_all",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_catch_all",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_disposable",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_disposable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_role_account",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_role_account",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_safe_to_send",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_safe_to_send",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_spamtrap",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_spamtrap",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_valid_syntax",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_valid_syntax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_firstname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_lastname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_organization_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_organization_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "processed_at",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "processed_at",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit#gid=0",
"cachedResultName": "Contact Form"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit?usp=drivesdk",
"cachedResultName": "JotForm Contact Validation & Enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "V4NHfo08zBK4IW4e",
"name": "[Naveen]Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "368f029f-630b-4860-9e26-e8e36c3a8115",
"name": "API：电子邮件验证 (Reoon)",
"type": "n8n-nodes-base.httpRequest",
"position": [
32,
32
],
"parameters": {
"url": "https://emailverifier.reoon.com/api/v1/verify",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth",
"queryParameters": {
"parameters": [
{
"name": "email",
"value": "={{ $json.email }}"
},
{
"name": "mode",
"value": "power"
}
]
}
},
"credentials": {
"httpQueryAuth": {
"id": "gLP6fzinBZjfgHu0",
"name": "[Reoon/Sean]Query Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "5f3fd91f-914e-4ceb-970b-9f266f17eae3",
"name": "Sheets：保存验证状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
240,
32
],
"parameters": {
"columns": {
"value": {
"email": "={{ $json.email }}",
"domain": "={{ $json.domain }}",
"status": "={{ $json.status }}",
"is_spamtrap": "={{ $json.is_spamtrap }}",
"is_catch_all": "={{ $json.is_catch_all }}",
"processed_at": "=",
"is_disposable": "={{ $json.is_disposable }}",
"is_free_email": "={{ $json.is_free_email }}",
"overall_score": "={{ $json.overall_score }}",
"is_deliverable": "={{ $json.is_deliverable }}",
"is_role_account": "={{ $json.is_role_account }}",
"is_safe_to_send": "={{ $json.is_safe_to_send }}",
"is_valid_syntax": "={{ $json.is_valid_syntax }}"
},
"schema": [
{
"id": "first_name",
"type": "string",
"display": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "message",
"type": "string",
"display": true,
"required": false,
"displayName": "message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "overall_score",
"type": "string",
"display": true,
"required": false,
"displayName": "overall_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_deliverable",
"type": "string",
"display": true,
"required": false,
"displayName": "is_deliverable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_free_email",
"type": "string",
"display": true,
"required": false,
"displayName": "is_free_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_catch_all",
"type": "string",
"display": true,
"required": false,
"displayName": "is_catch_all",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_disposable",
"type": "string",
"display": true,
"required": false,
"displayName": "is_disposable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_role_account",
"type": "string",
"display": true,
"required": false,
"displayName": "is_role_account",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_safe_to_send",
"type": "string",
"display": true,
"required": false,
"displayName": "is_safe_to_send",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_spamtrap",
"type": "string",
"display": true,
"required": false,
"displayName": "is_spamtrap",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_valid_syntax",
"type": "string",
"display": true,
"required": false,
"displayName": "is_valid_syntax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_firstname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_lastname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_organization_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "enriched_organization_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "processed_at",
"type": "string",
"display": true,
"required": false,
"displayName": "processed_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit#gid=0",
"cachedResultName": "Contact Form"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit?usp=drivesdk",
"cachedResultName": "JotForm Contact Validation & Enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "V4NHfo08zBK4IW4e",
"name": "[Naveen]Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "94a9dbf1-120f-4203-a7e6-1e4055a2acc3",
"name": "筛选器：仅安全电子邮件",
"type": "n8n-nodes-base.if",
"position": [
448,
32
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "1a2bc2ad-ac91-4474-be1b-4e687a9e34b7",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "safe"
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "e63a1b68-d28b-4ff6-a0fa-440741587541",
"name": "API：联系人丰富化 (Apollo)",
"type": "n8n-nodes-base.httpRequest",
"position": [
720,
-48
],
"parameters": {
"url": "https://api.apollo.io/api/v1/people/match",
"method": "POST",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "email",
"value": "={{ $json.email }}"
},
{
"name": "reveal_personal_emails",
"value": "false"
},
{
"name": "reveal_phone_number",
"value": "false"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Cache-Control",
"value": "no-cache"
},
{
"name": "accept",
"value": "application/json"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "XwELyyFjq7zjLcVP",
"name": "[Apollo/Sean]Header Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "7555fc87-fbf2-43a0-a873-3a72776e64fa",
"name": "Sheets：保存丰富化数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
928,
-48
],
"parameters": {
"columns": {
"value": {
"email": "={{ $json.person.email }}",
"processed_at": "={{ $now.toFormat('yyyy-MM-dd') }}",
"enriched_title": "={{ $json.person.title }}",
"enriched_lastname": "={{ $json.person.last_name }}",
"enriched_firstname": "={{ $json.person.first_name }}",
"enriched_linkedin_url": "={{ $json.person.linkedin_url }}",
"enriched_organization_name": "={{ $json.person.organization.name }}"
},
"schema": [
{
"id": "first_name",
"type": "string",
"display": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "message",
"type": "string",
"display": true,
"required": false,
"displayName": "message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "overall_score",
"type": "string",
"display": true,
"required": false,
"displayName": "overall_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_deliverable",
"type": "string",
"display": true,
"required": false,
"displayName": "is_deliverable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_free_email",
"type": "string",
"display": true,
"required": false,
"displayName": "is_free_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_catch_all",
"type": "string",
"display": true,
"required": false,
"displayName": "is_catch_all",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_disposable",
"type": "string",
"display": true,
"required": false,
"displayName": "is_disposable",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_role_account",
"type": "string",
"display": true,
"required": false,
"displayName": "is_role_account",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_safe_to_send",
"type": "string",
"display": true,
"required": false,
"displayName": "is_safe_to_send",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_spamtrap",
"type": "string",
"display": true,
"required": false,
"displayName": "is_spamtrap",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_valid_syntax",
"type": "string",
"display": true,
"required": false,
"displayName": "is_valid_syntax",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_firstname",
"type": "string",
"display": true,
"required": false,
"displayName": "enriched_firstname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_lastname",
"type": "string",
"display": true,
"required": false,
"displayName": "enriched_lastname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_linkedin_url",
"type": "string",
"display": true,
"required": false,
"displayName": "enriched_linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_title",
"type": "string",
"display": true,
"required": false,
"displayName": "enriched_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enriched_organization_name",
"type": "string",
"display": true,
"required": false,
"displayName": "enriched_organization_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "processed_at",
"type": "string",
"display": true,
"required": false,
"displayName": "processed_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit#gid=0",
"cachedResultName": "Contact Form"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RBZ_VcxxkNqU6weYv5OxX7OWj1Y46WLHM1sbLw-iCVc/edit?usp=drivesdk",
"cachedResultName": "JotForm Contact Validation & Enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "V4NHfo08zBK4IW4e",
"name": "[Naveen]Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "6f6293ca-42e9-42f3-892c-5c35237dc959",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1088,
-128
],
"parameters": {
"width": 560,
"height": 480,
"content": "## 📋 JotForm 联系人验证与丰富化"
},
"typeVersion": 1
},
{
"id": "1bb22245-1a9e-403b-8369-5739573588a2",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-144
],
"parameters": {
"color": 7,
"width": 256,
"height": 144,
"content": "**步骤 1：表单提交**"
},
"typeVersion": 1
},
{
"id": "c7aff216-b33a-4bc2-a1e2-eba6b8739003",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
32,
432
],
"parameters": {
"color": 3,
"width": 608,
"height": 272,
"content": "⚠️ **重要 - 更新这些设置：**"
},
"typeVersion": 1
},
{
"id": "fc5f1647-efbb-43d8-8b3c-7a1fb21b7dda",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-288,
240
],
"parameters": {
"color": 7,
"width": 272,
"height": 144,
"content": "**步骤 2：初始存储**"
},
"typeVersion": 1
},
{
"id": "2708f469-4f86-41cb-b017-d5df61c9fcd9",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-64,
-144
],
"parameters": {
"color": 7,
"width": 256,
"height": 144,
"content": "**步骤 3：电子邮件验证**"
},
"typeVersion": 1
},
{
"id": "eb3af6ad-a6f1-48f3-b0ad-8073aef0c8dc",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
416,
224
],
"parameters": {
"color": 7,
"width": 288,
"height": 144,
"content": "**步骤 4：安全筛选器**"
},
"typeVersion": 1
},
{
"id": "21b92677-1283-497e-8723-f59ec2e2535b",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
608,
-208
],
"parameters": {
"color": 7,
"width": 304,
"height": 128,
"content": "**步骤 5：联系人丰富化**"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Filter: Safe Emails Only": {
"main": [
[
{
"node": "API: Contact Enrichment (Apollo)",
"type": "main",
"index": 0
}
]
]
},
"Trigger: JotForm Submission": {
"main": [
[
{
"node": "Sheets: Create Contact Record",
"type": "main",
"index": 0
}
]
]
},
"Sheets: Create Contact Record": {
"main": [
[
{
"node": "API: Email Verification (Reoon)",
"type": "main",
"index": 0
}
]
]
},
"API: Email Verification (Reoon)": {
"main": [
[
{
"node": "Sheets: Save Verification Status",
"type": "main",
"index": 0
}
]
]
},
"API: Contact Enrichment (Apollo)": {
"main": [
[
{
"node": "Sheets: Save Enriched Data",
"type": "main",
"index": 0
}
]
]
},
"Sheets: Save Verification Status": {
"main": [
[
{
"node": "Filter: Safe Emails Only",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于AI的潜在客户评分与个性化回复（JotForm、GPT和Gmail）
基于AI的潜在客户评分与个性化回复：使用JotForm、GPT和Gmail
Code
Gmail
Http Request
+4
15 节点Naveen Choudhary
客户培育
使用ZoomInfo、Serper和Oxylabs到Google Sheets自动化公司数据丰富
通过ZoomInfo、Serper和Oxylabs到Google Sheets自动化公司数据丰富
If
Code
Html
+6
19 节点Naveen Choudhary
潜在客户开发
YouTube RSS到Slack摘要
使用Google Sheets、RapidAPI和GPT-4o-mini将新YouTube视频摘要发送到Slack
If
Set
Xml
+13
40 节点Naveen Choudhary
人工智能
使用自动分页将LinkedIn Sales Navigator联系人提取到Google Sheets
使用自动分页将LinkedIn Sales Navigator联系人提取到Google Sheets
If
Set
Code
+5
15 节点Naveen Choudhary
内容创作
通过Apify和Firecrawl抓取Google Maps商家并提取联系方式
使用Apify和Firecrawl抓取Google Maps商家信息并提取联系方式
If
Code
Wait
+6
18 节点Naveen Choudhary
销售
Google表格集成的自动化SEC Form D申报追踪器
Google表格集成的自动化SEC Form D申报追踪器
Xml
Code
Http Request
+4
11 节点Naveen Choudhary
加密货币交易
工作流信息
难度等级
中级
节点数量14
分类-
节点类型5
作者
Naveen Choudhary
@n8nsteinI create AI-driven n8n workflows that turn repetitive tasks into smooth, hands-off automations. Want to explore an idea? Book a quick consult: https://cal.com/nickchoudhary/30min
外部链接
在 n8n.io 查看 →
分享此工作流