AI驱动联系人智能与丰富,使用OpenAI/Anthropic和Supabase
中级
这是一个自动化工作流,包含 9 个节点。主要使用 Code, Webhook, Supabase, HttpRequest 等节点。 AI驱动联系人智能与丰富,使用OpenAI/Anthropic和Supabase
前置要求
- •HTTP Webhook 端点(n8n 会自动生成)
- •Supabase URL 和 API Key
- •可能需要目标 API 的认证凭证
分类
-
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"name": "AI Contact Enrichment",
"tags": [
{
"id": "customer-support",
"name": "customer-support",
"createdAt": "2025-01-14T00:00:00.000Z",
"updatedAt": "2025-01-14T00:00:00.000Z"
},
{
"id": "ai-automation",
"name": "ai-automation",
"createdAt": "2025-01-14T00:00:00.000Z",
"updatedAt": "2025-01-14T00:00:00.000Z"
}
],
"nodes": [
{
"id": "webhook-trigger",
"name": "Webhook Trigger",
"type": "n8n-nodes-base.webhook",
"position": [
250,
300
],
"webhookId": "contact-enrichment-webhook",
"parameters": {
"path": "contact-enrichment",
"options": {}
},
"typeVersion": 1
},
{
"id": "process-data",
"name": "Process Data",
"type": "n8n-nodes-base.code",
"position": [
450,
300
],
"parameters": {
"functionCode": "// Extract and process data\nconst data = {\n id: Date.now().toString(),\n ...$input.item.json,\n timestamp: new Date().toISOString()\n};\nreturn { json: data };"
},
"typeVersion": 2
},
{
"id": "prepare-ai",
"name": "Prepare AI Request",
"type": "n8n-nodes-base.code",
"position": [
650,
300
],
"parameters": {
"functionCode": "// AI Configuration\nconst aiConfig = {\n provider: $env.AI_PROVIDER || 'openai',\n apiKey: $env.AI_API_KEY,\n model: $env.AI_MODEL || 'gpt-3.5-turbo',\n endpoint: $env.AI_ENDPOINT\n};\nreturn { json: { aiConfig, data: $json } };"
},
"typeVersion": 2
},
{
"id": "call-ai",
"name": "Call AI API",
"type": "n8n-nodes-base.httpRequest",
"position": [
850,
300
],
"parameters": {
"url": "={{$json.aiConfig.provider === 'openai' ? 'https://api.openai.com/v1/chat/completions' : $json.aiConfig.endpoint}}",
"method": "POST",
"sendBody": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "model",
"value": "={{$json.aiConfig.model}}"
},
{
"name": "messages",
"value": "={{JSON.stringify([{role: 'user', content: JSON.stringify($json.data)}])}}"
}
]
},
"genericAuthType": "httpHeaderAuth",
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "Authorization",
"value": "=Bearer {{$json.aiConfig.apiKey}}"
}
]
}
},
"typeVersion": 4
},
{
"id": "save-to-db",
"name": "Save to Supabase",
"type": "n8n-nodes-base.supabase",
"position": [
1050,
300
],
"parameters": {
"table": "workflow_logs",
"values": "=AI Contact Enrichment,={{JSON.stringify($json)}},={{JSON.stringify($json)}},={{new Date().toISOString()}}",
"columns": "workflow_name,data,ai_response,created_at",
"operation": "insert"
},
"credentials": {
"supabaseApi": {
"id": "supabase-credentials",
"name": "Supabase API"
}
},
"typeVersion": 1
},
{
"id": "format-response",
"name": "Format Response",
"type": "n8n-nodes-base.code",
"position": [
1250,
300
],
"parameters": {
"functionCode": "return { json: { success: true, workflow: 'AI Contact Enrichment', timestamp: new Date().toISOString() } };"
},
"typeVersion": 2
},
{
"id": "sticky-overview",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
60
],
"parameters": {
"width": 380,
"height": 380,
"content": "## 🔍 AI Contact Enrichment Workflow\n\n**Purpose:** Automatically enhance contact data with AI-powered insights including job roles, company details, and persona analysis.\n\n**Key Features:**\n✅ Universal AI provider support (OpenAI, Anthropic, etc.)\n✅ Enrich partial contact data\n✅ Generate buyer personas\n✅ Automatic data logging to Supabase\n✅ Perfect for sales & marketing teams"
},
"typeVersion": 1
},
{
"id": "sticky-setup",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
60
],
"parameters": {
"width": 360,
"height": 380,
"content": "## 📋 Setup Required\n\n**Environment Variables:**\n• AI_PROVIDER (openai/anthropic/etc.)\n• AI_API_KEY\n• AI_MODEL (gpt-3.5-turbo/gpt-4)\n• AI_ENDPOINT (for custom providers)\n\n**Credentials:**\n• Supabase API credentials\n\n**Database:**\n• Table: workflow_logs\n• Columns: workflow_name, data, ai_response, created_at"
},
"typeVersion": 1
},
{
"id": "sticky-flow",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1040,
60
],
"parameters": {
"width": 340,
"height": 300,
"content": "## 🔄 Workflow Flow\n\n1️⃣ Webhook receives contact data\n2️⃣ Data is processed and timestamped\n3️⃣ AI configuration prepared from env vars\n4️⃣ AI enriches contact with insights\n5️⃣ Enriched data logged to Supabase\n6️⃣ Success response returned\n\n**Output:** Enhanced contact profile with insights"
},
"typeVersion": 1
}
],
"settings": {
"executionOrder": "v1"
},
"updatedAt": "2025-01-14T00:00:00.000Z",
"versionId": "1",
"staticData": null,
"connections": {
"call-ai": {
"main": [
[
{
"node": "save-to-db",
"type": "main",
"index": 0
}
]
]
},
"process-data": {
"main": [
[
{
"node": "prepare-ai",
"type": "main",
"index": 0
}
]
]
},
"webhook-trigger": {
"main": [
[
{
"node": "process-data",
"type": "main",
"index": 0
}
]
]
},
"save-to-db": {
"main": [
[
{
"node": "format-response",
"type": "main",
"index": 0
}
]
]
},
"prepare-ai": {
"main": [
[
{
"node": "call-ai",
"type": "main",
"index": 0
}
]
]
}
},
"triggerCount": 1
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
企业Reddit智能参与平台
基于AI的Reddit潜在客户生成与社区管理,具备高级评分功能
If
Code
Wait
+
If
Code
Wait
52 节点Shelly-Ann Davy
从Notion自动执行客户培育邮件和评价收集
通过Telegram使用Google日历和Notion CRM自动化会议安排
If
Set
Code
+
If
Set
Code
19 节点Shelly-Ann Davy
客服机器人
使用AI求职信自动搜索职位
使用 Google Jobs、RemoteOK 和 GPT-3.5 自动化带AI求职信的职位搜索
If
Set
Code
+
If
Set
Code
17 节点Shelly-Ann Davy
个人效率
自动化客户培育邮件与Notion客户评价收集
使用WhatsApp、GPT-4V和Google Sheets提取并整理收据数据
If
Code
Notion
+
If
Code
Notion
18 节点Shelly-Ann Davy
发票处理
自动化错误报告:GitHub Issues → AI分析 → Jira工单,附带Slack和Discord提醒
GitHub到Jira错误同步,含GPT-4o分析与团队提醒
If
Code
Jira
+
If
Code
Jira
22 节点Shelly-Ann Davy
内容创作
保险新闻聚合与关键词分析
通过Supabase实现保险新闻聚合、关键词分析及双数据库存储
If
Code
Wait
+
If
Code
Wait
16 节点Shelly-Ann Davy
工作流信息
难度等级
中级
节点数量9
分类-
节点类型5
作者
Shelly-Ann Davy
@SheCodesFlowFounder of The Workflow Muse & @SheCodesFlow. I craft elegant, task-focused automations for creators, founders, and soft-tech enthusiasts. “Automate with grace. Scale with power.”
外部链接
在 n8n.io 查看 →
分享此工作流