中文网

冷触达自动化：使用Dumpling AI抓取本地线索并通过Vapi拨打电话

中级

这是一个自动化工作流，包含 11 个节点。主要使用 Set、Filter、SplitOut、HttpRequest、GoogleSheets 等节点。 冷触达自动化：使用Dumpling AI抓取本地线索并通过Vapi拨打电话

前置要求
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (11 个)

Set
Filter
SplitOut
StickyNote
HttpRequest
GoogleSheets
ManualTrigger

分类

未分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "guzv1hyyxqP3NW8n",
  "meta": {
    "instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
    "templateCredsSetupCompleted": true
  },
  "name": "冷触达自动化：使用 Dumpling AI 抓取本地线索并通过 Vapi 拨打电话",
  "tags": [],
  "nodes": [
    {
      "id": "ec17b443-6dbd-46c1-8331-797ce6290801",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -860,
        -900
      ],
      "parameters": {
        "width": 900,
        "height": 320,
        "content": "### 📍 使用 Dumpling AI 从 Google Maps 获取本地企业数据"
      },
      "typeVersion": 1
    },
    {
      "id": "5345e653-8442-4caa-bb7e-a597b3779db0",
      "name": "手动启动工作流",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -820,
        -580
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "072baaf9-81d8-4989-9354-822f02b2f922",
      "name": "从 Google Sheets 获取搜索关键词",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -600,
        -580
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1QXZk6D8hW29f9umrmsYv_HeZYRKWOjsxOaFZ2BZtu3Y/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1QXZk6D8hW29f9umrmsYv_HeZYRKWOjsxOaFZ2BZtu3Y/edit?usp=drivesdk",
          "cachedResultName": "leads"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GaJqJHuS5mQxap7q",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "004427b8-e8d7-4f28-b03e-4b459f2a7b2b",
      "name": "使用 Dumpling AI 抓取 Google Map 企业",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -380,
        -580
      ],
      "parameters": {
        "url": "https://app.dumplingai.com/api/v1/search-maps",
        "method": "POST",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "={\n  \"query\":\"{{ $json.URLs }}\", \n  \"language\": \"en\"\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "headerParameters": {
          "parameters": [
            {}
          ]
        }
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "5CBvzXCLjwWzCJRE",
          "name": "n8n_integration"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "21eed6ed-ca94-48b1-a164-1a0841ec376b",
      "name": "拆分每个企业结果",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -160,
        -580
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "places"
      },
      "typeVersion": 1
    },
    {
      "id": "5efb54a1-0b80-46aa-861d-2ef53f069a22",
      "name": "提取企业名称、电话和网站",
      "type": "n8n-nodes-base.set",
      "position": [
        60,
        -580
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "79cc91c6-28bd-47a1-86db-b936e6958428",
              "name": "website",
              "type": "string",
              "value": "={{ $json.website }}"
            },
            {
              "id": "7a0455bb-b235-4e03-a93d-0e3b31b40df2",
              "name": "phoneNumber",
              "type": "string",
              "value": "={{ $json.phoneNumber }}"
            },
            {
              "id": "a493dd1f-b495-4c01-983a-4e417aca80fc",
              "name": "title",
              "type": "string",
              "value": "={{ $json.title }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "91ec444a-44be-471b-8f2d-e192f58b085d",
      "name": "仅筛选有效电话号码",
      "type": "n8n-nodes-base.filter",
      "position": [
        280,
        -580
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "dab1310e-6566-4e77-b1a6-362363b2e025",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.phoneNumber }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "77d150c3-0908-443e-afb9-c2e1a740e749",
      "name": "格式化呼叫电话号码",
      "type": "n8n-nodes-base.set",
      "position": [
        500,
        -580
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "045d4c64-61f3-4b39-9b5c-35b7e95783fd",
              "name": "formattedPhone",
              "type": "string",
              "value": "={{ '+1' + $json[\"phoneNumber\"].replace(/\\D/g, '') }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "1dbe296d-c422-4ae6-ba7e-6bd7dbe0a5e9",
      "name": "向企业发起 Vapi AI 呼叫",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        720,
        -580
      ],
      "parameters": {
        "url": "https://api.vapi.ai/call",
        "method": "POST",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "={\n  \"customers\": [\n    {\n      \"number\": \"{{ $json.formattedPhone}}\",\n      \"name\": \"\"\n    }\n  ],\n  \"assistantId\": \"\",\n  \"phoneNumberId\": \"\",\n  \"assistantOverrides\": {\n    \"variableValues\": {\n      \"Name\": \"{{ $('Filter Valid Phone Numbers Only').item.json.title }}\",\n    }\n  }\n}",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "6X2b4RLVRbz8I4Z8",
          "name": "Vapi"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "fc705d86-98b2-4219-9b19-0350657b845b",
      "name": "将已呼叫企业信息记录到表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        940,
        -600
      ],
      "parameters": {
        "columns": {
          "value": {
            "website": "={{ $('Extract Business Name, Phone and website').item.json.website }}",
            "company name": "={{ $('Extract Business Name, Phone and website').item.json.title }}",
            "phone number ": "={{ $('Format Phone Number for Calling').item.json.formattedPhone }}"
          },
          "schema": [
            {
              "id": "company name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "company name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "phone number ",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "phone number ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "website",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1315810611,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1QXZk6D8hW29f9umrmsYv_HeZYRKWOjsxOaFZ2BZtu3Y/edit#gid=1315810611",
          "cachedResultName": "leads"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1QXZk6D8hW29f9umrmsYv_HeZYRKWOjsxOaFZ2BZtu3Y",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1QXZk6D8hW29f9umrmsYv_HeZYRKWOjsxOaFZ2BZtu3Y/edit?usp=drivesdk",
          "cachedResultName": "leads"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GaJqJHuS5mQxap7q",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "e30e0706-3732-4a2f-81f2-d50e63043632",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        -900
      ],
      "parameters": {
        "color": 3,
        "width": 900,
        "height": 320,
        "content": "### 📞 自动呼叫企业并跟踪结果"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "da88eae8-0530-4674-8afa-196c8da7f47f",
  "connections": {
    "Start Workflow Manually": {
      "main": [
        [
          {
            "node": "Get Search Keywords from Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Each Business Result": {
      "main": [
        [
          {
            "node": "Extract Business Name, Phone and website",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Valid Phone Numbers Only": {
      "main": [
        [
          {
            "node": "Format Phone Number for Calling",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Phone Number for Calling": {
      "main": [
        [
          {
            "node": "Initiate Vapi AI Call to Business",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Initiate Vapi AI Call to Business": {
      "main": [
        [
          {
            "node": "Log Called Business Info to Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Search Keywords from Google Sheets": {
      "main": [
        [
          {
            "node": "Scrape Google Map Businesses using Dumpling AI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Business Name, Phone and website": {
      "main": [
        [
          {
            "node": "Filter Valid Phone Numbers Only",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape Google Map Businesses using Dumpling AI": {
      "main": [
        [
          {
            "node": "Split Each Business Result",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

这是一个中级难度的通用自动化工作流。适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

需要付费吗？

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

相关工作流推荐

AI新闻简报构建器：使用Dumpling AI抓取网站，GPT-4o摘要
AI新闻简报构建器：Dumpling AI抓取网站，GPT-4o摘要
Set
Code
Gmail
+6
10 节点Yang
AI
使用Dumpling AI和GPT-4o从文章自动生成LinkedIn帖子
使用Dumpling AI和GPT-4o从文章自动生成LinkedIn帖子
Set
Http Request
Google Sheets
+4
10 节点Yang
AI
基于本地商业搜索的冷邮件开场白：GPT-4和Dumpling AI
基于本地商业搜索的冷邮件开场白：GPT-4和Dumpling AI
Filter
Split Out
Form Trigger
+5
10 节点Yang
Lead Generation
使用 Dumpling AI 从表单自动生成电影级动物视频和声音
使用GPT-4、Dumpling AI和ElevenLabs音频将表单输入转换为电影级视频
Set
Code
Wait
+9
23 节点Yang
Content Creation
使用Dumpling AI从Google地图提取商业线索并保存到Google表格
使用Dumpling AI从Google地图提取商业线索到Google表格
Split Out
Http Request
Google Sheets
+2
5 节点Yang
Sales
使用Dumpling AI + GPT-4o根据自动补全建议生成标题
使用Dumpling AI + GPT-4o从自动补全建议生成标题
Set
Split Out
Http Request
+4
8 节点Yang
Design
工作流信息
难度等级
中级
节点数量11
分类-
节点类型7
难度说明

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

作者
Yang

Yang

@yang
外部链接
在 n8n.io 上查看 →

分享此工作流