piepdrive测试
中级
这是一个Sales, AI领域的自动化工作流,包含 8 个节点。主要使用 Code, Slack, Markdown, Pipedrive, HttpRequest 等节点,结合人工智能技术实现智能自动化。 使用OpenAI GPT-4o丰富Pipedrive组织数据并在Slack中通知
前置要求
- •Slack Bot Token 或 Webhook URL
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "",
"meta": {
"instanceId": "",
"templateCredsSetupCompleted": true
},
"name": "piepdrive-test",
"tags": [],
"nodes": [
{
"id": "b2838678-c796-4c99-a3da-a2cd1b42ea97",
"name": "Pipedrive 触发器 - 创建组织时",
"type": "n8n-nodes-base.pipedriveTrigger",
"position": [
820,
380
],
"webhookId": "f5de09a8-6601-4ad5-8bc8-9b3f4b83e997",
"parameters": {
"action": "added",
"object": "organization"
},
"credentials": {
"pipedriveApi": {
"id": "",
"name": "Pipedrive Connection"
}
},
"typeVersion": 1
},
{
"id": "5aa05d79-b2fa-4040-b4ca-cad83adf2798",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
120
],
"parameters": {
"width": 656.3637637842876,
"height": 1455.9537026322007,
"content": "# 当 Pipedrive 中创建组织时使用 GPT-4o 丰富 Pipedrive 的组织数据"
},
"typeVersion": 1
},
{
"id": "47ee8bfb-2f9d-4790-a929-1533215d6746",
"name": "Pipedrive - 使用 OpenAI 输出创建备注",
"type": "n8n-nodes-base.pipedrive",
"position": [
1640,
380
],
"parameters": {
"content": "={{ $json.message.content }}",
"resource": "note",
"additionalFields": {
"org_id": "={{ $('Pipedrive Trigger - An Organization is created').item.json.meta.id }}"
}
},
"credentials": {
"pipedriveApi": {
"id": "",
"name": "Pipedrive Connection"
}
},
"typeVersion": 1
},
{
"id": "7783b531-0469-4bee-868e-4b26a1bb41ba",
"name": "代码 - Markdown 转 Slack Markdown",
"type": "n8n-nodes-base.code",
"position": [
2080,
380
],
"parameters": {
"jsCode": "const inputMarkdown = items[0].json.data;\n\nfunction convertMarkdownToSlackFormat(markdown) {\n let slackFormatted = markdown;\n \n // Convert headers\n slackFormatted = slackFormatted.replace(/^# (.*$)/gim, '*$1*');\n slackFormatted = slackFormatted.replace(/^## (.*$)/gim, '*$1*');\n \n // Convert unordered lists\n slackFormatted = slackFormatted.replace(/^\\* (.*$)/gim, '➡️ $1');\n \n // Convert tables\n const tableRegex = /\\n\\|.*\\|\\n\\|.*\\|\\n((\\|.*\\|\\n)+)/;\n const tableMatch = slackFormatted.match(tableRegex);\n if (tableMatch) {\n const table = tableMatch[0];\n const rows = table.split('\\n').slice(3, -1);\n const formattedRows = rows.map(row => {\n const columns = row.split('|').slice(1, -1).map(col => col.trim());\n return `*${columns[0]}*: ${columns[1]}`;\n }).join('\\n');\n slackFormatted = slackFormatted.replace(table, formattedRows);\n }\n \n return slackFormatted;\n}\n\nconst slackMarkdown = convertMarkdownToSlackFormat(inputMarkdown);\nconsole.log(slackMarkdown);\n\n// Return data\nreturn [{ slackFormattedMarkdown: slackMarkdown }];\n"
},
"typeVersion": 2
},
{
"id": "cf2b02df-07e8-4ebb-ba3d-bfd294dcfab0",
"name": "Scrapingbee - 获取组织 URL 内容",
"type": "n8n-nodes-base.httpRequest",
"position": [
1040,
380
],
"parameters": {
"url": "https://app.scrapingbee.com/api/v1",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "api_key",
"value": "<YOUR_SCRAPINGBEE_API_KEY>"
},
{
"name": "url",
"value": "={{ $json.current.<random_api_id_custom_website_field> }}"
},
{
"name": "render_js",
"value": "false"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "906d44f0-7582-4742-9fd8-4c8dfba918e0",
"name": "HTML 转 Markdown",
"type": "n8n-nodes-base.markdown",
"position": [
1860,
380
],
"parameters": {
"html": "={{ $json.content }}",
"options": {}
},
"typeVersion": 1
},
{
"id": "8c1a5d64-4f38-4f9e-8878-443f750206b7",
"name": "Slack - 通知",
"type": "n8n-nodes-base.slack",
"position": [
2300,
380
],
"parameters": {
"text": "=*New Organizaton {{ $('Pipedrive Trigger - An Organization is created').item.json.current.name }} created on Pipedrive* :\n\n\n {{ $json.slackFormattedMarkdown }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultName": "pipedrive-notification"
},
"otherOptions": {},
"authentication": "oAuth2"
},
"credentials": {
"slackOAuth2Api": {
"id": "",
"name": "Slack Connection"
}
},
"typeVersion": 2.2
},
{
"id": "2414a5d3-1d4b-447b-b401-4b6f823a0cf9",
"name": "OpenAI - 使用抓取的数据向 GPT-4o 发送消息",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1260,
380
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"options": {},
"messages": {
"values": [
{
"content": "={{ $json.data }}"
},
{
"role": "system",
"content": "You're an assistant that summarizes website content for CRM entries. The user will provide HTML content from a company's website. Your task is to analyze the HTML content and create a concise summary that includes:\n\n1. A brief description of the company's services or products.\n2. Any information about the company's target market or customer base.\n3. Key points about the company's unique selling propositions or competitive advantages.\n4. Based on the provided information, suggest potential competitors if you know any.\n\nFormat your response as HTML.\n\nExample response :\n\n <h1>Company Description</h1>\n <p>Company1 specializes in services related to electric vehicles. The company focuses on providing resources and information about electric car chargers, battery life, different car brands, and the environmental impact of electric vehicles.</p>\n\n <h2>Target Market</h2>\n <p>The target market for Company1 includes electric vehicle owners and potential buyers who are interested in making the shift from traditional fossil fuel vehicles to electric cars. The company also targets environmentally conscious consumers who are looking for sustainable mobility solutions.</p>\n\n <h2>Unique Selling Propositions</h2>\n <ul>\n <li>Comprehensive information about electric vehicle charging solutions, including how to install home charging stations.</li>\n <li>Detailed articles on the advantages of electric vehicles such as ecology and reliability.</li>\n <li>Educational resources on the autonomy and battery life of different electric car models.</li>\n <li>Insights into premier electric vehicle brands.</li>\n </ul>\n\n <h2>Potential Competitors</h2>\n <table border=\"1\">\n <tr>\n <th>Competitor Name</th>\n <th>Website</th>\n </tr>\n <tr>\n <td>Competitor1</td>\n <td><a href=\"https://www.example1.com\">https://www.example1.com</a></td>\n </tr>\n <tr>\n <td>Competitor2</td>\n <td><a href=\"https://www.example2.com\">https://www.example2.com</a></td>\n </tr>\n <tr>\n <td>Competitor3</td>\n <td><a href=\"https://www.example3.com\">https://www.example3.com</a></td>\n </tr>\n <tr>\n <td>Competitor4</td>\n <td><a href=\"https://www.example4.com\">https://www.example4.com</a></td>\n </tr>\n </table>\n"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "",
"name": "OpenAi Connection"
}
},
"typeVersion": 1.3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"HTML To Markdown": {
"main": [
[
{
"node": "Code - Markdown to Slack Markdown",
"type": "main",
"index": 0
}
]
]
},
"Code - Markdown to Slack Markdown": {
"main": [
[
{
"node": "Slack - Notify ",
"type": "main",
"index": 0
}
]
]
},
"OpenAI - Message GPT-4o with Scraped Data": {
"main": [
[
{
"node": "Pipedrive - Create a Note with OpenAI output",
"type": "main",
"index": 0
}
]
]
},
"Pipedrive - Create a Note with OpenAI output": {
"main": [
[
{
"node": "HTML To Markdown",
"type": "main",
"index": 0
}
]
]
},
"Scrapingbee - Get Organization's URL content": {
"main": [
[
{
"node": "OpenAI - Message GPT-4o with Scraped Data",
"type": "main",
"index": 0
}
]
]
},
"Pipedrive Trigger - An Organization is created": {
"main": [
[
{
"node": "Scrapingbee - Get Organization's URL content",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 销售, 人工智能
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
使用 OpenAI、Google Sheets、Jina AI 和 Slack 的 AI 驱动信息监控
基于AI的信息监控,集成OpenAI、Google Sheets、Jina AI和Slack
If
Set
Code
+10
31 节点Dataki
销售
AI生成的WordPress文章摘要块
WordPress文章的AI生成摘要块
If
Set
Slack
+14
32 节点Dataki
人工智能
基于视觉的AI代理爬虫 - 使用Google Sheets、ScrapingBee和Gemini
✨ 基于视觉的AI代理爬虫 - 使用Google Sheets、ScrapingBee和Gemini
Set
Markdown
Split Out
+9
29 节点Dataki
销售
基于AI的潜在客户评分(Salesforce、GPT-4o和Slack,含数据脱敏)
基于AI的潜在客户评分:使用Salesforce、GPT-4o和Slack,包含数据脱敏
Code
Slack
Http Request
+4
11 节点Le Nguyen
销售
AI潜在客户机器专业版:Google地图→Slack→HubSpot→$$$
使用Google地图、GPT-4和HubSpot的自动化潜在客户生成与资格认证
If
Set
Code
+7
16 节点David Olusola
销售
使用Apollo和人工验证发现并丰富决策者信息
使用Apollo和人工验证发现并丰富决策者信息
If
Code
Merge
+10
35 节点Uche Madu
销售
工作流信息
难度等级
中级
节点数量8
分类2
节点类型8
作者
Dataki
@datakiI am passionate about transforming complex processes into seamless automations with n8n. My expertise spans across creating ETL pipelines, sales automations, and data & AI-driven workflows. As an avid problem solver, I thrive on optimizing workflows to drive efficiency and innovation.
外部链接
在 n8n.io 查看 →
分享此工作流