Supabase 设置 Postgres
中级
这是一个Building Blocks, AI, Marketing, IT Ops领域的自动化工作流，包含 6 个节点。主要使用 Set, Supabase, ManualTrigger, Agent, LmChatGoogleGemini 等节点，结合人工智能技术实现智能自动化。 将WhatsApp/Slack聊天数据存储到Supabase PostgreSQL，集成Gemini AI
前置要求
- •Supabase URL 和 API Key
- •Google Gemini API Key
- •PostgreSQL 数据库连接信息
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "gUx6hY0bOoReluxE",
"meta": {
"instanceId": "5ce52989094be90be3b3bdd9ed9cee1d7ce1fcecaa598afaec4a50646d32e291",
"templateCredsSetupCompleted": true
},
"name": "Supabase 设置 Postgres",
"tags": [
{
"id": "fSDcaaN3w5sV5e3S",
"name": "Templates",
"createdAt": "2025-02-23T15:20:47.262Z",
"updatedAt": "2025-02-23T15:20:47.262Z"
}
],
"nodes": [
{
"id": "c2c95cc1-d10e-40c9-9663-625e8a2ab30b",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
340,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "30a4ae0f-c7ae-4b00-b826-a0a2759f2dd5",
"name": "设置示例输入变量",
"type": "n8n-nodes-base.set",
"position": [
600,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ed7bc826-fd48-4c9e-8ba7-11e4e7bb73ac",
"name": "session_id",
"type": "string",
"value": "=491634502879"
},
{
"id": "d381c930-a92f-404f-ac91-ad6437d6b0c9",
"name": "name",
"type": "string",
"value": "=Genn Sverster"
},
{
"id": "4ead1fb5-098b-4cbc-bc78-d65b188ca5b0",
"name": "chatInput",
"type": "string",
"value": "=wie gehts dir?"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "f56b629c-5374-43ce-b55b-efd7f14f1231",
"name": "GeminiFlash2.0",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
840,
140
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.0-flash"
},
"credentials": {
"googlePalmApi": {
"id": "clmB8ZYJMHaHmnsu",
"name": "Stardawn#1"
}
},
"typeVersion": 1
},
{
"id": "1da22e93-504e-4616-bac3-dabd9a4b145a",
"name": "Supabase Postgres 数据库",
"type": "@n8n/n8n-nodes-langchain.memoryPostgresChat",
"position": [
1100,
140
],
"parameters": {
"tableName": "whatsapp_messages3",
"sessionKey": "={{ $json.session_id }}",
"sessionIdType": "customKey",
"contextWindowLength": 20
},
"credentials": {
"postgres": {
"id": "B2m18ScvYBKPNF9s",
"name": "Supabase SD - N8N Demo Chatbot"
}
},
"typeVersion": 1.3
},
{
"id": "29a7eb84-2244-41e1-99c0-5daaeb80cf6e",
"name": "更新其他值（例如姓名、地址...）",
"type": "n8n-nodes-base.supabase",
"position": [
1300,
-80
],
"parameters": {
"filters": {
"conditions": [
{
"keyName": "session_id",
"keyValue": "={{ $('Set sample Input Variables').item.json.session_id }}",
"condition": "eq"
},
{
"keyName": "name",
"keyValue": "NULL",
"condition": "is"
}
]
},
"tableId": "whatsapp_messages3",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "name",
"fieldValue": "={{ $('Set sample Input Variables').item.json.name }}"
}
]
},
"matchType": "allFilters",
"operation": "update"
},
"credentials": {
"supabaseApi": {
"id": "GHuUG6pmPATBHgob",
"name": "N8N Chatbot"
}
},
"typeVersion": 1
},
{
"id": "8094fdd7-f238-47dc-94f9-5e962d5f0c2f",
"name": "示例代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
960,
-80
],
"parameters": {
"text": "={{ $json.chatInput }}",
"options": {
"systemMessage": "You are a helpful assistant"
},
"promptType": "define"
},
"typeVersion": 1.7
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "49fd22da-2875-49be-a3c0-6c0fcf378a8e",
"connections": {
"Sample Agent ": {
"main": [
[
{
"node": "Update additonal Values e.g. Name, Address ...",
"type": "main",
"index": 0
}
]
]
},
"GeminiFlash2.0": {
"ai_languageModel": [
[
{
"node": "Sample Agent ",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Set sample Input Variables": {
"main": [
[
{
"node": "Sample Agent ",
"type": "main",
"index": 0
}
]
]
},
"Supabase Postgres Database": {
"ai_memory": [
[
{
"node": "Sample Agent ",
"type": "ai_memory",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Set sample Input Variables",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 构建模块, 人工智能, 营销, IT 运维
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
YouTube 自动化
自动化 YouTube 视频排程和 AI 元数据生成 🎬
If
Set
Code
+11
33 节点JPres
人工智能
YouTube Discord 机器人
使用 Gemini 2.0 Flash 的自动化 Discord 频道聊天交互机器人
Code
Webhook
Agent
+3
6 节点JPres
构建模块
使用Bright Data和Google Gemini提取并汇总Indeed公司信息
使用Bright Data和Google Gemini提取和汇总Indeed公司信息
Set
Markdown
Http Request
+7
15 节点Ranjan Dailata
人力资源
Indeed公司数据抓取与Airtable、Bright Data和Google Gemini的汇总
使用Airtable、Bright Data和Google Gemini进行Indeed数据抓取与汇总
If
Set
Wait
+11
19 节点Ranjan Dailata
人力资源
使用Bright Data、Google Gemini和MCP自动化AI代理抓取网页数据
使用Bright Data、Google Gemini和MCP自动化AI代理抓取网页数据
Set
Function
Mcp Client
+8
19 节点Ranjan Dailata
人工智能
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+38
244 节点Amanda Benks
销售
