8
n8n 中文网amn8n.com

自动化Tally表单处理

中级

这是一个Lead Generation领域的自动化工作流，包含 11 个节点。主要使用 Set, Wait, Gmail, Webhook, Airtable 等节点。 使用Gmail回复自动化Tally表单提交到Airtable

前置要求
  • •Google 账号和 Gmail API 凭证
  • •HTTP Webhook 端点（n8n 会自动生成）
  • •Airtable API Key

使用的节点 (11)

Set
Wait
Gmail
Webhook
Airtable
StickyNote

分类

潜在客户开发
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "5ecs295v3ZaiY8HM",
  "meta": {
    "instanceId": "e95c8554b03e2c16a5c8c44cc7d45f6192b966fba75d5438d1201989ceff13e2",
    "templateCredsSetupCompleted": true
  },
  "name": "自动化 Tally 表单处理",
  "tags": [],
  "nodes": [
    {
      "id": "de34d97a-e3e8-4be7-9a2b-c77222eeb2ca",
      "name": "编辑字段",
      "type": "n8n-nodes-base.set",
      "position": [
        1060,
        1060
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "0186e9c9-424c-4ad8-8382-1614cf48c9d1",
              "name": "full_name",
              "type": "string",
              "value": "={{ $json.body.data.fields[0].value }}"
            },
            {
              "id": "e5559efc-1458-48e6-a207-f7fea896e930",
              "name": "company_name",
              "type": "string",
              "value": "={{ $json.body.data.fields[1].value }}"
            },
            {
              "id": "bbc04ed4-a8f7-4778-bfdc-038c637320fa",
              "name": "job_title",
              "type": "string",
              "value": "={{ $json.body.data.fields[2].value }}"
            },
            {
              "id": "8175addd-ef95-45f9-b307-b218d6ede2be",
              "name": "email",
              "type": "string",
              "value": "={{ $json.body.data.fields[3].value }}"
            },
            {
              "id": "f017c0bd-bd5d-4a5e-967f-bb27c514f5ee",
              "name": "phone_number",
              "type": "string",
              "value": "={{ $json.body.data.fields[4].value }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "635a0ccc-dd60-4e24-aaff-50dda69e9705",
      "name": "等待",
      "type": "n8n-nodes-base.wait",
      "position": [
        1960,
        1060
      ],
      "webhookId": "f647bd2e-8bdd-49ab-8eba-8a1db07bc2e8",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "8592b7dc-baa5-4306-9ffa-f341ade8e434",
      "name": "Webhook：Tally",
      "type": "n8n-nodes-base.webhook",
      "position": [
        620,
        1060
      ],
      "webhookId": "e92bb825-14ff-43e0-bd7c-24504d4acb56",
      "parameters": {
        "path": "formulaire-tally",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 2
    },
    {
      "id": "316dcbae-3957-4109-a984-cbf068529c74",
      "name": "Airtable：创建记录",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1600,
        1060
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "appPk6zfIQ1EbBq43",
          "cachedResultUrl": "https://airtable.com/appPk6zfIQ1EbBq43",
          "cachedResultName": "Client Requests"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "tblLkuoQ9AYsAQ0io",
          "cachedResultUrl": "https://airtable.com/appPk6zfIQ1EbBq43/tblLkuoQ9AYsAQ0io",
          "cachedResultName": "Client Requests"
        },
        "columns": {
          "value": {
            "Email": "={{ $json.email }}",
            "Full Name": "={{ $json.full_name }}",
            "Job Title": "={{ $json.job_title }}",
            "Company Name": "={{ $json.company_name }}",
            "Phone Number": "={{ $json.phone_number }}"
          },
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company Name",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Company Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Job Title",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Job Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone Number",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Phone Number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submission Date",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "Submission Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "create"
      },
      "credentials": {
        "airtableTokenApi": {
          "id": "fbET2GdSoJjK5Idu",
          "name": "Airtable Personal Access Token account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "9fc0fee1-0896-4d3b-bb97-30c6bc8e9493",
      "name": "GMAIL：发送消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2360,
        1060
      ],
      "webhookId": "52b3183a-ee31-49ed-8711-d822c07ea3aa",
      "parameters": {
        "sendTo": "={{ $json.fields.Email }}",
        "message": "=<p>Hi {{ $json.fields['Full Name'] }},</p>\n\n<p>Thanks for reaching out! We’ve received your request and our team will get back to you as soon as possible.</p>\n\n<p><strong>Here’s a quick summary:</strong></p>\n<ul>\n\n <li><strong>Company:</strong>{{ $json.fields['Company Name'] }} </li>\n  <li><strong>Job Title:</strong> {{ $json.fields['Job Title'] }}</li>\n\n<p>We’ll be in touch very soon!</p>\n<p>— The Team</p>\n\n",
        "options": {},
        "subject": "Thanks for reaching out!"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "FKD43HaVeVoUXOi0",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "531b37a5-ab97-401f-b8c1-71b076319121",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        620
      ],
      "parameters": {
        "width": 200,
        "height": 340,
        "content": "**还在手动复制粘贴 Tally 表单回复吗？**"
      },
      "typeVersion": 1
    },
    {
      "id": "90a2d5a9-1138-468e-b5be-1f98b0a027eb",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        560,
        1240
      ],
      "parameters": {
        "color": 3,
        "height": 1460,
        "content": "## 步骤 1 — 捕获 Tally 表单回复"
      },
      "typeVersion": 1
    },
    {
      "id": "28b97f32-e5ac-4368-a644-663ce1f0fce7",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        1240
      ],
      "parameters": {
        "color": 6,
        "width": 300,
        "height": 1160,
        "content": "## 步骤 2 — 清理并结构化表单数据（Set 节点）"
      },
      "typeVersion": 1
    },
    {
      "id": "6bd0534c-1b1f-43ae-927a-b976d7a8de7e",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1540,
        1220
      ],
      "parameters": {
        "color": 2,
        "width": 280,
        "height": 1500,
        "content": "## 步骤 3 — 在 Airtable 中保存数据"
      },
      "typeVersion": 1
    },
    {
      "id": "0ecbb548-23dd-4f81-9ba7-b60da12227d9",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1980,
        1240
      ],
      "parameters": {
        "color": 4,
        "width": 520,
        "height": 900,
        "content": "## 步骤 4 — 发送自动确认邮件"
      },
      "typeVersion": 1
    },
    {
      "id": "27ecea70-1450-40a4-9adc-b71c3916d403",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2580,
        1020
      ],
      "parameters": {
        "width": 320,
        "height": 200,
        "content": "## 工作流结束"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "734ed2ae-e251-4b36-a008-4f8f1703fe45",
  "connections": {
    "Wait": {
      "main": [
        [
          {
            "node": "GMAIL : Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Airtable : Create a record",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook : Tally": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Airtable : Create a record": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 潜在客户开发

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

报价请求？Tally发送，Airtable记录，Slack提醒，Gmail致谢。
使用Tally、Airtable、Slack和Gmail自动化报价请求处理
Set
Wait
Gmail
+4
13 节点Baptiste Fort
潜在客户开发
自动化Tally表单的Slack通知
自动化Tally表单：使用Airtable存储，通过Slack通知
Set
Wait
Gmail
+3
11 节点Baptiste Fort
潜在客户开发
Google Maps 潜在客户：姓名、邮箱、电话，使用 Apify + Airtable + 个性化邮件
使用 Apify 和 Airtable 抓取 Google Maps 企业潜在客户并发送个性化邮件
Set
Wait
Gmail
+4
13 节点Baptiste Fort
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
自动化每日股市报告
使用 Bright Data、GPT-4.1、Airtable 和 Gmail 的自动化每日股市报告
Set
Wait
Switch
+10
27 节点Baptiste Fort
内容创作
从Telegram自动发送会议记录到Airtable、Slack和Gmail
使用GPT-4.1从Telegram消息创建会议记录并发送至Airtable、Slack、Gmail
If
Code
Wait
+10
29 节点Baptiste Fort
AI 摘要总结
工作流信息
难度等级
中级
节点数量11
分类1
节点类型6
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Baptiste Fort

Baptiste Fort

@baptistefort

👋 I'm Baptiste Fort. What if automating was simply our way of taking back control in a world that's moving too fast? I build workflows that are simple, useful — sometimes invisible lol. Automation isn’t cheating. It’s just being one step ahead.

外部链接
在 n8n.io 查看 →

分享此工作流