自动化会议参与者信息丰富
中级
这是一个Lead Generation领域的自动化工作流，包含 13 个节点。主要使用 If, Set, Code, CalTrigger, HttpRequest 等节点。 使用 Apollo.io 和 Google Sheets 自动丰富会议参与者信息
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "28099d2544433ae0f39c65315a4d4c531947fcb0f060a94d6047d7be5df31063",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "f6a8a3c9-b1c7-4143-95b9-f21a7e6ee7c1",
"name": "Cal.com 触发器",
"type": "n8n-nodes-base.calTrigger",
"position": [
-6540,
1540
],
"webhookId": "6f065eed-9538-4a27-b4b5-8277abe70040",
"parameters": {
"events": [
"BOOKING_CREATED"
],
"options": {}
},
"credentials": {
"calApi": {
"id": "Q7phxuZZAyZJzXxP",
"name": "Cal account"
}
},
"typeVersion": 2
},
{
"id": "ac8e37e7-0e6d-48ea-af24-d145f64dd5cf",
"name": "创建 URL",
"type": "n8n-nodes-base.code",
"position": [
-5660,
1440
],
"parameters": {
"jsCode": "// Retrieve the input data from node \"JSON\".\nlet inputData = $node[\"Generate Query\"].json;\n\n// If the output from the \"JSON\" node is an array, take the first element; otherwise, use it as is.\nif (Array.isArray(inputData)) {\n inputData = inputData[0];\n}\n\n// Access the \"query\" property, expecting it to be an array and taking its first element.\nconst paramsData = inputData.query[0];\n\n// Base URL for Apollo\nconst baseURL = 'https://app.apollo.io/#/people';\n\n// Array to hold each part of the query string\nconst queryParts = [];\n\n// Helper function to process and add array parameters to queryParts.\n// - Spaces in values will be encoded as %20.\n// - Parameter names like 'paramName[]' will have their brackets encoded as 'paramName%5B%5D'.\nconst addArrayParams = (paramName, values) => {\n values.forEach(val => {\n // Decode any existing '+' in input string to spaces, then URI encode the whole value.\n const decodedValue = String(val).replace(/\\+/g, ' ');\n const encodedValue = encodeURIComponent(decodedValue); // Ensures spaces become %20\n queryParts.push(`${paramName}%5B%5D=${encodedValue}`); // Appends paramName%5B%5D=encodedValue\n });\n};\n\n// === Construct the query string in the DESIRED ORDER ===\n\n// 1. page=1 (Static)\nqueryParts.push('page=1');\n\n// 2. Process locations (personLocations[])\n// Example: personLocations%5B%5D=London\nif (paramsData.location && Array.isArray(paramsData.location) && paramsData.location.length > 0) {\n addArrayParams('personLocations', paramsData.location);\n}\n\n// 3. Process organization keyword tags (qOrganizationKeywordTags[])\n// Used for searching by company NAME.\n// Example: qOrganizationKeywordTags%5B%5D=Paddle\nif (paramsData.business && Array.isArray(paramsData.business) && paramsData.business.length > 0) {\n addArrayParams('qOrganizationKeywordTags', paramsData.business);\n}\n\n// 4. Static parameters: includedOrganizationKeywordFields[]\n// Example: includedOrganizationKeywordFields%5B%5D=tags & includedOrganizationKeywordFields%5B%5D=name\n// Using addArrayParams to ensure consistent encoding.\naddArrayParams('includedOrganizationKeywordFields', ['tags', 'name']);\n\n// 5. Static parameter: sortByField (value is pre-encoded)\n// Example: sortByField=%5Bnone%5D\nqueryParts.push('sortByField=%5Bnone%5D');\n\n// 6. Static parameter: sortAscending\n// Example: sortAscending=false\nqueryParts.push('sortAscending=false');\n\n// 7. Process qKeywords (person's name/keyword search)\n// Example: qKeywords=Rob%20Fletcher (spaces as %20)\nif (paramsData.keyword && Array.isArray(paramsData.keyword) && paramsData.keyword.length > 0) {\n // Decode any existing '+' in input string to spaces\n const keywordVal = String(paramsData.keyword[0]).replace(/\\+/g, ' ');\n const encodedKeyword = encodeURIComponent(keywordVal); // Ensures spaces become %20\n queryParts.push(`qKeywords=${encodedKeyword}`);\n}\n\n// Optional: Process job_title (personTitles[]) if needed in the future.\n// Ensure 'personTitles' is the correct Apollo parameter name and uncomment if required.\n/*\nif (paramsData.job_title && Array.isArray(paramsData.job_title) && paramsData.job_title.length > 0) {\n addArrayParams('personTitles', paramsData.job_title); // This will also use %5B%5D encoding for brackets\n}\n*/\n\n// Combine all query parts with '&' to form the full query string\nconst queryString = queryParts.join('&');\n\n// Build the final URL\nconst finalURL = `${baseURL}?${queryString}`;\n\n// Return the output as an array of objects, with the finalURL nested under a json key.\nreturn [{ json: { finalURL } }];"
},
"typeVersion": 2
},
{
"id": "83bc2e49-06d9-4752-a816-c88328afd24b",
"name": "Calendly 触发器",
"type": "n8n-nodes-base.calendlyTrigger",
"position": [
-6540,
1340
],
"webhookId": "0b5d887d-dfce-4370-9c00-9dc60813f1de",
"parameters": {
"events": [
"invitee.created"
]
},
"credentials": {
"calendlyApi": {
"id": "qbBQbeE3Cm62E2jm",
"name": "Calendly account"
}
},
"typeVersion": 1
},
{
"id": "abb4448c-9c1d-4d56-b2e4-f19ec0631a3f",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-4980,
1320
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $('Log entry').first().json.Email }}",
"Name ": "={{ $('Log entry').first().json['Name '] }}",
"Notes": "={{ $('Log entry').first().json.Notes }}",
"Phone": "={{ $('Scrape Apollo').first().json.contactPhoneNumbers[0].sanitizedNumber }}",
"Status": "Enriched ",
"Company": "={{ $('Scrape Apollo').first().json.companyName }}",
"Country": "={{ $('Scrape Apollo').first().json.countryName }}",
"Socials": "=1. LinkedIn\nPerson: {{ $('Scrape Apollo').first().json.linkedInProfileUrl }}\nCompany: {{ $json.company.linkedInProfileUrl }}\n2. Twitter\nPerson:{{ $json.twitterProfileUrl }}\nCompany:{{ $json.company.twitterProfileUrl }}\n3. Facebook\nPerson: {{ $json.facebookProfileUrl }}\nCompany: {{ $json.company.facebookProfileUrl }}\n4. Github\nPerson: {{ $json.githubProfileUrl }}\n",
"Industry": "={{ $('Scrape Apollo').first().json.company.businessIndustry }}",
"Location": "={{ $('Scrape Apollo').first().json.cityName }}",
"Created At": "={{ $('Log entry').first().json['Created At'] }}",
"Job Title ": "={{ $('Scrape Apollo').first().json.positionHistory[0].jobTitle }}",
"Website URL": "={{ $('Scrape Apollo').first().json.company.websiteUrl }}",
"Company Size": "=Employee Count: {{ $('Scrape Apollo').first().json.company.employeeEstimate }}\nESTD: {{ $('Scrape Apollo').first().json.company.yearFounded }}\nStock Exchange: {{ $('Scrape Apollo').first().json.company.stockExchange }}\nStock Symbol: {{ $('Scrape Apollo').first().json.company.stockSymbol }}\n"
},
"schema": [
{
"id": "Created At",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Created At",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name ",
"type": "string",
"display": true,
"required": false,
"displayName": "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": "Country",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Socials",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Socials",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Job Title ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Website URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Size",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Created At"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xQ66nuVVjws8sEXhiWPtYZfg6hv-Q2az9OKTrhUIABY/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1xQ66nuVVjws8sEXhiWPtYZfg6hv-Q2az9OKTrhUIABY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xQ66nuVVjws8sEXhiWPtYZfg6hv-Q2az9OKTrhUIABY/edit?usp=drivesdk",
"cachedResultName": "Meeting Prep"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "NdBpgqV7UHdZ3CZc",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "0581ea56-4e36-4d8a-81b7-9ef57ba41183",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
-4960,
1520
],
"parameters": {
"columns": {
"value": {
"Status": "Info Not Available",
"Created At": "={{ $('Log entry').first().json['Created At'] }}"
},
"schema": [
{
"id": "Created At",
"type": "string",
"display": true,
"required": false,
"displayName": "Created At",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name ",
"type": "string",
"display": true,
"required": false,
"displayName": "Name ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Socials",
"type": "string",
"display": true,
"required": false,
"displayName": "Socials",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title ",
"type": "string",
"display": true,
"required": false,
"displayName": "Job Title ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website URL",
"type": "string",
"display": true,
"required": false,
"displayName": "Website URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Size",
"type": "string",
"display": true,
"required": false,
"displayName": "Company Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xQ66nuVVjws8sEXhiWPtYZfg6hv-Q2az9OKTrhUIABY/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1xQ66nuVVjws8sEXhiWPtYZfg6hv-Q2az9OKTrhUIABY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xQ66nuVVjws8sEXhiWPtYZfg6hv-Q2az9OKTrhUIABY/edit?usp=drivesdk",
"cachedResultName": "Meeting Prep"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "NdBpgqV7UHdZ3CZc",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "5fd126bb-f58c-4894-97e9-3b0da6959bf1",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-6630,
1240
],
"parameters": {
"width": 1840,
"height": 520,
"content": "# 丰富会议参与者信息"
},
"typeVersion": 1
},
{
"id": "60254652-adc6-4614-aac0-f5b269d8e3b7",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-7060,
1240
],
"parameters": {
"width": 420,
"height": 520,
"content": "## 1. 资源"
},
"typeVersion": 1
},
{
"id": "491cbbcd-851c-49f3-9139-9bc010b44e24",
"name": "提取数据",
"type": "n8n-nodes-base.set",
"position": [
-6340,
1340
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "75c90c99-eefa-4bcf-94f1-0600dd2e17ac",
"name": "Name",
"type": "string",
"value": "={{ $json.payload.name }}"
},
{
"id": "dea8cbbd-b4d3-47f4-8a5d-8898002a5bd6",
"name": "Email",
"type": "string",
"value": "={{ $json.payload.email }}"
},
{
"id": "f6e07fc3-3196-441b-8398-0d4c2358bd53",
"name": "Company ",
"type": "string",
"value": "={{ $json.payload.questions_and_answers[0].answer }}"
},
{
"id": "1195b3c9-ce35-4b7c-8922-52192f80eddb",
"name": "Notes",
"type": "string",
"value": "={{ $json.payload.questions_and_answers[1].answer }}"
},
{
"id": "680c22c0-0518-44b0-94fb-11f245c1c74e",
"name": "Created at",
"type": "string",
"value": "={{ $json.created_at.toDateTime() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "d0ee5e40-5c57-4b51-a6f5-d6184f907772",
"name": "提取数据",
"type": "n8n-nodes-base.set",
"position": [
-6340,
1540
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "75c90c99-eefa-4bcf-94f1-0600dd2e17ac",
"name": "Name",
"type": "string",
"value": "={{ $json.responses.name.value }}"
},
{
"id": "dea8cbbd-b4d3-47f4-8a5d-8898002a5bd6",
"name": "Email",
"type": "string",
"value": "={{ $json.responses.email.value }}"
},
{
"id": "f6e07fc3-3196-441b-8398-0d4c2358bd53",
"name": "Company ",
"type": "string",
"value": "={{ $json.responses.title.value }}"
},
{
"id": "1195b3c9-ce35-4b7c-8922-52192f80eddb",
"name": "Notes",
"type": "string",
"value": "={{ $json.responses.notes.value }}"
},
{
"id": "6871b932-5193-4a6c-ab90-442a063f7365",
"name": "Created at",
"type": "string",
"value": "={{ $json.createdAt.toDateTime() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "8555fefe-a522-4a5b-aaa5-a502f55ce57b",
"name": "日志条目",
"type": "n8n-nodes-base.googleSheets",
"position": [
-6100,
1440
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $json.Email }}",
"Name ": "={{ $json.Name }}",
"Notes": "={{ $json.Notes }}",
"Company": "={{ $json['Company '] }}",
"Created At": "={{ $json['Created at'] }}"
},
"schema": [
{
"id": "Created At",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Created At",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name ",
"type": "string",
"display": true,
"required": false,
"displayName": "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": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Socials",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Socials",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title ",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Job Title ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Website URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Size",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Created At"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xQ66nuVVjws8sEXhiWPtYZfg6hv-Q2az9OKTrhUIABY/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1xQ66nuVVjws8sEXhiWPtYZfg6hv-Q2az9OKTrhUIABY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xQ66nuVVjws8sEXhiWPtYZfg6hv-Q2az9OKTrhUIABY/edit?usp=drivesdk",
"cachedResultName": "Meeting Prep"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "NdBpgqV7UHdZ3CZc",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "f3f0d32e-8b44-49f5-aa61-a5dccbb19f17",
"name": "生成查询",
"type": "n8n-nodes-base.set",
"position": [
-5880,
1440
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "=={\n \"query\": [\n {\n \"keyword\": [\"{{ $json['Name '] }}\"],\n \"business\": [\"{{ $json.Company }}\"]\n }\n ]\n}"
},
"typeVersion": 3.4
},
{
"id": "8f54f69c-2d51-4c90-8a6d-d6cd48527043",
"name": "抓取 Apollo",
"type": "n8n-nodes-base.httpRequest",
"position": [
-5440,
1440
],
"parameters": {
"url": "https://api.apify.com/v2/acts/supreme_coder~apollo-scraper/run-sync-get-dataset-items?token=<YOURAPIKEY>",
"method": "POST",
"options": {},
"jsonBody": "={\n \"count\": 25,\n \"excludeGuessedEmails\": false,\n \"excludeNoEmails\": false,\n \"getEmails\": true,\n \"searchUrl\": \"{{ $json.finalURL }}\"\n}",
"sendBody": true,
"specifyBody": "json"
},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "c98b7806-6f2a-4a1d-869b-1a2aec0fde18",
"name": "数据可用吗？",
"type": "n8n-nodes-base.if",
"position": [
-5220,
1440
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6869b0dd-f1b3-4431-a0d5-d02b0acdb6e8",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $('Scrape Apollo').all().toJsonString() }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
}
],
"pinData": {},
"connections": {
"Log entry": {
"main": [
[
{
"node": "Generate Query",
"type": "main",
"index": 0
}
]
]
},
"Create URL": {
"main": [
[
{
"node": "Scrape Apollo",
"type": "main",
"index": 0
}
]
]
},
"Extract Data": {
"main": [
[
{
"node": "Log entry",
"type": "main",
"index": 0
}
]
]
},
"Extract data": {
"main": [
[
{
"node": "Log entry",
"type": "main",
"index": 0
}
]
]
},
"Scrape Apollo": {
"main": [
[
{
"node": "If Data available?",
"type": "main",
"index": 0
}
]
]
},
"Generate Query": {
"main": [
[
{
"node": "Create URL",
"type": "main",
"index": 0
}
]
]
},
"Cal.com Trigger1": {
"main": [
[
{
"node": "Extract data",
"type": "main",
"index": 0
}
]
]
},
"Calendly Trigger": {
"main": [
[
{
"node": "Extract Data",
"type": "main",
"index": 0
}
]
]
},
"If Data available?": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
],
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于AI的潜在客户生成（Apollo、LinkedIn研究和4步个性化邮件）
基于AI的潜在客户生成：使用Apollo、LinkedIn研究和4步个性化邮件
If
Set
Code
+8
30 节点Gain FLow AI
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
社交媒体资料丰富流程
使用Extruct.ai收集公司社交媒体资料并存储到Google表格
If
Set
Code
+5
13 节点Extruct AI
潜在客户开发
使用Perplexity和OpenAI为社交媒体创建AI新闻视频内容创意
使用Perplexity和OpenAI为社交媒体创建AI新闻视频内容创意
Set
Code
Gmail
+7
18 节点Gain FLow AI
内容创作
基于公司ID的Apollo数据丰富
使用Apollo、Google Sheets和Telegram基于公司ID丰富采购联系人
If
Set
Code
+9
27 节点Khaisa Studio
潜在客户开发
丰富并提取Google表格中商业线索的邮箱
使用Serper.dev和ScrapingBee从Google表格提取商业邮箱地址
If
Set
Code
+6
26 节点Jorge Martínez
潜在客户开发
工作流信息
难度等级
中级
节点数量13
分类1
节点类型8
作者
Gain FLow AI
@gain-flowGainFlow AI is your go-to AI automation agency, specializing in Python and no-code solutions to eliminate repetitive tasks for individuals and businesses. Free up your time and boost efficiency. For inquiries, Fill this [form](https://docs.google.com/forms/d/e/1FAIpQLSfIiXdw4HMcI2HM-Obng13j_RFiKv7X-mjOVm_mcy2ucRA8EA/viewform) reach out to us at info.gainflow@gmail.com.
外部链接
在 n8n.io 查看 →
分享此工作流