🔐 双重确认邮件验证系统（使用Google Sheets）
高级
这是一个Marketing, IT Ops领域的自动化工作流，包含 24 个节点。主要使用 If, Code, Form, EmailSend, FormTrigger 等节点。 🔐 使用Google Sheets的双重确认邮件验证系统
前置要求
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "bWbwE1qVduRTdWmc",
"meta": {
"instanceId": "a98b2884375a41e5c54ee9fdf1ece06db7f5771d5abd20450875f3922d7c41f8"
},
"name": "🔐 双重确认邮件验证系统（使用 Google Sheets）",
"tags": [
{
"id": "2E1hRaAa0axOUCXV",
"name": "UTCM",
"createdAt": "2025-05-08T22:11:01.814Z",
"updatedAt": "2025-05-08T22:11:01.814Z"
},
{
"id": "GZT3Cgu3i4As1Giz",
"name": "Doble-OptIn",
"createdAt": "2025-05-08T22:10:58.928Z",
"updatedAt": "2025-05-08T22:10:58.928Z"
},
{
"id": "UZnyfKrtC83mHOyK",
"name": "Forms",
"createdAt": "2025-05-08T22:10:50.602Z",
"updatedAt": "2025-05-08T22:10:50.602Z"
}
],
"nodes": [
{
"id": "93c4049b-138e-4cb1-906a-8aada9485ffd",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
-4460,
-160
],
"webhookId": "13e025ae-a071-4659-ad64-6aab4fdf26c8",
"parameters": {},
"notesInFlow": false,
"typeVersion": 2.2
},
{
"id": "358d84d7-381b-4de9-8c5e-d1d988c0b4a7",
"name": "邮件表单",
"type": "n8n-nodes-base.form",
"position": [
-4140,
-160
],
"webhookId": "65c69d26-adef-48d9-8bff-2f152fc5ce94",
"parameters": {},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "d0106dca-e3d1-45bc-b0e4-a0ac7a82a903",
"name": "生成验证码",
"type": "n8n-nodes-base.code",
"position": [
-3800,
-160
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "659f0327-c4ee-45f8-a38d-80e9aada20db",
"name": "发送电子邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
-3020,
-160
],
"webhookId": "7a787e42-b725-454a-99e6-71f95863d37f",
"parameters": {},
"notesInFlow": false,
"typeVersion": 2.1
},
{
"id": "ac5dfb19-9254-45fd-92bb-2d78a3062f51",
"name": "存储数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
-3440,
-120
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 4.5
},
{
"id": "f9586647-ea00-4b21-bd54-76f4314f926d",
"name": "验证表单",
"type": "n8n-nodes-base.form",
"position": [
-2700,
-160
],
"webhookId": "d21ac010-2872-4320-af3b-6f5e398dc8e5",
"parameters": {},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "e33fb6cd-59c2-4c84-9d51-5c8f7af1e2a1",
"name": "检查验证码",
"type": "n8n-nodes-base.if",
"position": [
-2380,
-160
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 2.2
},
{
"id": "47dd37e4-409c-42dd-9554-b14c18b65cb0",
"name": "主表单",
"type": "n8n-nodes-base.form",
"position": [
-1840,
-440
],
"webhookId": "5c229f26-1625-4367-a3f9-ebd2cc3e8241",
"parameters": {},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "016ff76e-12f6-42ed-ad3c-234c585d6126",
"name": "错误验证码表单",
"type": "n8n-nodes-base.form",
"position": [
-1920,
600
],
"webhookId": "c69a7027-4453-43ba-a5ae-5601d912978e",
"parameters": {},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "b1692894-3759-4f56-bd98-1c57a91dbb3c",
"name": "二次检查",
"type": "n8n-nodes-base.if",
"position": [
-1200,
60
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 2.2
},
{
"id": "f883c1c1-4529-41a8-9ec4-4f2396fcc972",
"name": "重置表单",
"type": "n8n-nodes-base.form",
"position": [
-640,
760
],
"webhookId": "16d0402a-20a1-4a6c-9ab8-13c353a1efe7",
"parameters": {},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "dc335784-6532-4e63-b4a1-5b9cf77b5de6",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4540,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2160baa2-a011-4bd8-b4bb-a11845e0323c",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4240,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6fed7946-cac4-48c0-836d-863f87ac1da0",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3920,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4d8dbcce-1dc3-48fa-a2f9-1561e6399462",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3600,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3b1cdbbd-28f3-420a-b507-0a707e857845",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3120,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "59276d85-d217-4883-86ac-427eb70083df",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2800,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6c0df430-39c0-4dc9-b0a4-6b9a2aeabc12",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2480,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "05973b8b-b873-44c6-8274-1bae17118cb8",
"name": "便签 8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2120,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1479b495-1d18-4a03-8fdb-d276b33e70ac",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1480,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9936331c-2fb5-4d4f-ab8d-b586310a75ca",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2ae131e8-69a1-4212-81d6-95aabaf5cd3e",
"name": "便签 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2120,
-740
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2a429ebd-460c-4a33-bc57-7576e31e1fea",
"name": "继续您的流程",
"type": "n8n-nodes-base.noOp",
"position": [
-1200,
-440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0935942e-3a27-4f5c-ac0f-9a0ddc68ac8a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1420,
-1000
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "5ace2a5e-1f6c-4c13-a069-d71dcb22ee1d",
"connections": {
"Main Form": {
"main": [
[
{
"node": "Continue With Your Flow",
"type": "main",
"index": 0
}
]
]
},
"Check Code": {
"main": [
[
{
"node": "Main Form",
"type": "main",
"index": 0
}
],
[
{
"node": "Incorrect Code Form",
"type": "main",
"index": 0
}
]
]
},
"Email Form": {
"main": [
[
{
"node": "Generate Code",
"type": "main",
"index": 0
}
]
]
},
"Reset Form": {
"main": [
[
{
"node": "Email Form",
"type": "main",
"index": 0
}
]
]
},
"Send Email": {
"main": [
[
{
"node": "Verification Form",
"type": "main",
"index": 0
}
]
]
},
"Store Data": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
]
]
},
"Second Check": {
"main": [
[
{
"node": "Main Form",
"type": "main",
"index": 0
}
],
[
{
"node": "Reset Form",
"type": "main",
"index": 0
}
]
]
},
"Generate Code": {
"main": [
[
{
"node": "Store Data",
"type": "main",
"index": 0
}
]
]
},
"Verification Form": {
"main": [
[
{
"node": "Check Code",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Email Form",
"type": "main",
"index": 0
}
]
]
},
"Incorrect Code Form": {
"main": [
[
{
"node": "Second Check",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 营销, IT 运维
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
CSV到HubSpot上传器（动态字段映射与Google Sheets集成）
具有动态字段映射和Google Sheets集成的CSV到HubSpot上传器
If
Set
Code
+10
36 节点PollupAI
人工智能
网站抓取器
基于Airtop的LLM网站抓取器
If
Set
Code
+6
24 节点Airtop
营销
实时Notion Todoist双向同步模板
使用Redis的Notion Todoist实时双向同步
If
Set
Code
+26
246 节点Mario
销售
使用Google Sheets、Forms和Gmail通知自动化多步骤入职流程
使用Google Sheets、Forms和Gmail通知自动化多步骤入职流程
If
Set
Code
+11
31 节点PollupAI
人力资源
亚马逊产品价格追踪器
使用 ScrapeOps API 和 Google Sheets 警报跟踪亚马逊产品价格
If
Set
Email Send
+5
16 节点ScrapeOps
构建模块
YouTube 趋势发现器
YouTube 趋势发现助手
If
Set
Code
+8
17 节点Rakin Jakaria
市场调研
