Fluentform导出
中级
这是一个Lead Generation领域的自动化工作流，包含 9 个节点。主要使用 If, Set, Webhook, GoogleSheets, RespondToWebhook 等节点。 从 Fluentform 自动导出潜在客户到 Google 表格，支持表单分类
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "utlCHj75iFNNfZRx",
"meta": {
"instanceId": "c2650793f644091dc80fb900fe63448ad1f4b774008de9608064d67294f8307c",
"templateCredsSetupCompleted": true
},
"name": "Fluentform导出",
"tags": [],
"nodes": [
{
"id": "f9a0fc6b-4644-4079-8c00-234a6a4e6e92",
"name": "响应 Webhook",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1080,
0
],
"parameters": {
"options": {},
"respondWith": "json",
"responseBody": "={\n \"status\": \"success\"\n}"
},
"typeVersion": 1.1
},
{
"id": "bac186bc-e19d-431b-a6bb-e5cd3af9a031",
"name": "新闻通讯",
"type": "n8n-nodes-base.set",
"position": [
620,
-100
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "5eecb1d8-1dde-4db6-9a99-c5ab39c58653",
"name": "email",
"type": "string",
"value": "={{ $json.body.__submission.user_inputs.email }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "68dc8440-a45c-4577-b303-3c127e2bd880",
"name": "表单",
"type": "n8n-nodes-base.set",
"position": [
620,
100
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "b7d088f7-6335-4390-b8cf-1e1caf4249bc",
"name": "fullname",
"type": "string",
"value": "={{ $json.body.names.first_name }} {{ $json.body.names.last_name }}"
},
{
"id": "ba15b685-5fdf-49c5-a5cf-0581355032b9",
"name": "email",
"type": "string",
"value": "={{ $json.body.email }}"
},
{
"id": "f8db42b1-3b5d-4b42-b5cd-c6d7696dba1a",
"name": "no hp",
"type": "string",
"value": "={{ $json.body.numeric_field }}"
},
{
"id": "c3b4c6d6-a227-4263-98ca-f3c20d09846d",
"name": "subject",
"type": "string",
"value": "={{ $json.body.subject }}"
},
{
"id": "279f2943-cb5d-4ed7-8ea8-a839e3c1b9cc",
"name": "message",
"type": "string",
"value": "={{ $json.body.message }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "64383e9d-39ac-41b6-9369-88a8ac3cf441",
"name": "追加新闻通讯",
"type": "n8n-nodes-base.googleSheets",
"position": [
840,
-100
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $json.email }}"
},
"schema": [
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII/edit#gid=0",
"cachedResultName": "News Letter"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII/edit?usp=drivesdk",
"cachedResultName": "leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gnUSHhCw4cKx3pwo",
"name": "khaisa sheet"
}
},
"typeVersion": 4.6
},
{
"id": "25bc2a16-19d6-4e15-9735-316b9aea5e60",
"name": "POST - 获取潜在客户",
"type": "n8n-nodes-base.webhook",
"position": [
180,
0
],
"webhookId": "1c16c205-1617-43ca-83de-207e5fcc6de6",
"parameters": {
"path": "your-path",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "19fa286d-10ae-4afc-bf19-113a085fc371",
"name": "表单还是新闻通讯？",
"type": "n8n-nodes-base.if",
"position": [
400,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b096ba9d-1b60-47ab-ab9f-a4e83c953e8b",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.body._fluentform_2_fluentformnonce }}",
"rightValue": "c40c9119f6"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "1a5b1211-c7cb-46b7-a108-4c9dca305d24",
"name": "追加表单",
"type": "n8n-nodes-base.googleSheets",
"position": [
840,
100
],
"parameters": {
"columns": {
"value": {
"email": "={{ $json.email }}",
"no hp": "={{ $json['no hp'] }}",
"message": "={{ $json.message }}",
"subject": "={{ $json.subject }}",
"full name": "={{ $json.fullname }}"
},
"schema": [
{
"id": "full name",
"type": "string",
"display": true,
"required": false,
"displayName": "full name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "no hp",
"type": "string",
"display": true,
"required": false,
"displayName": "no hp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "message",
"type": "string",
"display": true,
"required": false,
"displayName": "message",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 799661662,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII/edit#gid=799661662",
"cachedResultName": "form"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fnNjkwA12R1wDyevySgkMaYbkJVAtagfRC8dyeyJMII/edit?usp=drivesdk",
"cachedResultName": "leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gnUSHhCw4cKx3pwo",
"name": "khaisa sheet"
}
},
"typeVersion": 4.6
},
{
"id": "node_tuuo8spg6",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-200
],
"parameters": {
"width": 320,
"content": "## 指南"
},
"typeVersion": 1
},
{
"id": "25381d46-98e9-49a1-911f-5d2928ed906b",
"name": "粘性解析器1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1020,
160
],
"parameters": {
"color": 4,
"width": 280,
"content": "### 此工作流免费！"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "6fc3feab-072e-4c00-92a9-b5d4399dd624",
"connections": {
"form": {
"main": [
[
{
"node": "append form",
"type": "main",
"index": 0
}
]
]
},
"newsletter": {
"main": [
[
{
"node": "Append newsletter",
"type": "main",
"index": 0
}
]
]
},
"append form": {
"main": [
[
{
"node": "Respond to Webhook",
"type": "main",
"index": 0
}
]
]
},
"Append newsletter": {
"main": [
[
{
"node": "Respond to Webhook",
"type": "main",
"index": 0
}
]
]
},
"Form or newsletter?": {
"main": [
[
{
"node": "newsletter",
"type": "main",
"index": 0
}
],
[
{
"node": "form",
"type": "main",
"index": 0
}
]
]
},
"POST - Retreive Leads": {
"main": [
[
{
"node": "Form or newsletter?",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
自动化Leadfeeder和Apollo.io数据收集
线索丰富管道：从Leadfeeder到Apollo再到Google Sheets
If
Set
Code
+9
23 节点Khairul Muhtadin
潜在客户开发
票务后端
活动票务后端：使用Google Sheets和Gmail自动生成二维码门票
If
Code
Gmail
+7
35 节点Khairul Muhtadin
内容创作
LinkedIn潜在客户生成与CRM自动化套件
使用Apify提取LinkedIn个人资料并为Google Sheets CRM自动生成潜在客户数据
If
Set
Code
+7
18 节点David Olusola
潜在客户开发
优惠码搜寻器：通过SerpAPI、Gemini和Telegram自动查找优惠码
优惠码搜寻器：通过SerpAPI、Gemini和Telegram自动查找优惠码
If
Set
Gmail
+13
18 节点Khairul Muhtadin
内容创作
智能资金管理器
基于Telegram、Google Sheets和OpenAI的AI驱动收据和支出追踪器
If
Set
Code
+13
50 节点Khairul Muhtadin
财务
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
