Supabase插入、更新与检索
高级
这是一个Building Blocks, AI领域的自动化工作流，包含 21 个节点。主要使用 Set, Supabase, GoogleDrive, ChatTrigger, LmChatOpenAi 等节点，结合人工智能技术实现智能自动化。 Supabase插入、更新与检索
前置要求
- •Supabase URL 和 API Key
- •Google Drive API 凭证
- •OpenAI API Key
使用的节点 (21)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "1a23006df50de49624f69e85993be557d137b6efe723a867a7d68a84e0b32704"
},
"nodes": [
{
"id": "54065cc9-047c-4741-95f6-cec3e352abd7",
"name": "Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
2700,
-1840
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "url",
"value": "https://drive.google.com/file/d/xxxxxxxxxxxxxxx/view"
},
"options": {},
"operation": "download"
},
"typeVersion": 3
},
{
"id": "62af57f5-a001-4174-bece-260a1fc595e8",
"name": "默认数据加载器",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
3120,
-1620
],
"parameters": {
"loader": "epubLoader",
"options": {},
"dataType": "binary"
},
"typeVersion": 1
},
{
"id": "ce3d9c7c-6ce9-421a-b4d0-4235217cf8e6",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
2620,
-2000
],
"parameters": {
"width": 749.1276349295781,
"height": 820.5109034066329,
"content": "# 插入"
},
"typeVersion": 1
},
{
"id": "81cb3d3e-70af-46c8-bc18-3d076a222d0b",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1720,
-1160
],
"parameters": {
"color": 3,
"width": 873.9739981925188,
"height": 534.0012007720542,
"content": "# 更新插入"
},
"typeVersion": 1
},
{
"id": "60ebdb71-c7e0-429b-9394-b680cc000951",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1720,
-2000
],
"parameters": {
"color": 4,
"width": 876.5116990000852,
"height": 821.787041589866,
"content": "# 准备（在 Supabase 中）"
},
"typeVersion": 1
},
{
"id": "ae95b0c3-b8b3-44eb-8070-b1bc6cac5cd2",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
3400,
-2000
],
"parameters": {
"color": 5,
"width": 810.9488123113013,
"height": 821.9537074055816,
"content": "# 检索"
},
"typeVersion": 1
},
{
"id": "58168721-cbd7-498c-9d16-41b4d5c6a68f",
"name": "问答链",
"type": "@n8n/n8n-nodes-langchain.chainRetrievalQa",
"position": [
3680,
-1860
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "ddf1228f-f051-445b-8a42-54c2510a0b2e",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
3600,
-1680
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "734a2c48-b445-4e62-99b7-dc1dcd921c52",
"name": "向量存储检索器",
"type": "@n8n/n8n-nodes-langchain.retrieverVectorStore",
"position": [
3760,
-1680
],
"parameters": {
"topK": 10
},
"typeVersion": 1
},
{
"id": "43f761b7-f4da-4b29-8099-9b2c15f79fe9",
"name": "递归字符文本分割器1",
"type": "@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter",
"position": [
3120,
-1460
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "de0d2666-88e4-4a4d-ba46-cf789b9cba85",
"name": "自定义响应",
"type": "n8n-nodes-base.set",
"notes": "output || text",
"position": [
4020,
-1860
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "440fc115-ccae-4e30-85a5-501d0617b2cf",
"name": "output",
"type": "string",
"value": "={{ $json.response.text }}"
}
]
}
},
"notesInFlow": true,
"typeVersion": 3.4
},
{
"id": "a396671f-a217-4f05-b969-cb64f10e4b01",
"name": "当收到聊天消息时",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
3480,
-1860
],
"webhookId": "d7431c58-89aa-4d70-b5bd-044be981b3a9",
"parameters": {
"public": true,
"options": {
"responseMode": "lastNode"
},
"initialMessages": "=Hi there! 🙏\n\nYou can ask me anything about Venerable Geshe Kelsang Gyatso's Book - 'How To Transform Your Life'\n\nWhat would you like to know? "
},
"typeVersion": 1.1
},
{
"id": "6312f6bc-c69c-4d4f-8838-8a9d0d22ed55",
"name": "按查询检索",
"type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
"position": [
3700,
-1520
],
"parameters": {
"options": {
"queryName": "match_documents"
},
"tableName": {
"__rl": true,
"mode": "list",
"value": "Kadampa",
"cachedResultName": "Kadampa"
}
},
"typeVersion": 1
},
{
"id": "ba6b87b9-e96d-47a3-83f8-169d7172325a",
"name": "OpenAI 检索嵌入",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
3700,
-1360
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "bcd1b31f-c60b-4c40-b039-d47dadc86b23",
"name": "OpenAI 插入嵌入",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
2920,
-1620
],
"parameters": {
"model": "text-embedding-3-small",
"options": {}
},
"typeVersion": 1
},
{
"id": "dfd7f734-eb00-4af3-9179-724503422fe4",
"name": "占位符（要更新插入的文件/内容）",
"type": "n8n-nodes-base.set",
"position": [
1900,
-1000
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={\n \"Date\": \"{{ $now.format('dd MMM yyyy') }}\",\n \"Time\": \"{{ $now.format('HH:mm ZZZZ z') }}\"\n}\n"
},
"typeVersion": 3.4
},
{
"id": "c54c9458-9b8a-4ef1-a6db-5265729be19d",
"name": "OpenAI 更新插入嵌入",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
2120,
-840
],
"parameters": {
"model": "text-embedding-3-small",
"options": {}
},
"typeVersion": 1
},
{
"id": "30c18e9e-d047-40d3-8324-f5d0e7892db6",
"name": "插入文档",
"type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
"position": [
2920,
-1840
],
"parameters": {
"mode": "insert",
"options": {},
"tableName": {
"__rl": true,
"mode": "list",
"value": "Kadampa",
"cachedResultName": "Kadampa"
}
},
"typeVersion": 1
},
{
"id": "3c0ed0ee-9134-4b4e-bcfd-632dd67a57da",
"name": "从表中检索行",
"type": "n8n-nodes-base.supabase",
"position": [
3960,
-1380
],
"parameters": {
"tableId": "n8n",
"operation": "getAll",
"returnAll": true
},
"typeVersion": 1
},
{
"id": "53aca1b4-31e8-4699-b158-673623bc9b95",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2620,
-1160
],
"parameters": {
"color": 6,
"width": 1587.0771183771394,
"height": 537.3056597675153,
"content": "# 删除"
},
"typeVersion": 1
},
{
"id": "4ffaccdb-9e0f-464d-9284-7771f6599fd8",
"name": "更新文档",
"type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
"position": [
2100,
-1000
],
"parameters": {
"id": "1",
"mode": "update",
"options": {
"queryName": "match_documents"
},
"tableName": {
"__rl": true,
"mode": "list",
"value": "n8n",
"cachedResultName": "n8n"
}
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Google Drive": {
"main": [
[
{
"node": "Insert Documents",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Question and Answer Chain",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Retrieve by Query": {
"ai_vectorStore": [
[
{
"node": "Vector Store Retriever",
"type": "ai_vectorStore",
"index": 0
}
]
]
},
"Default Data Loader": {
"ai_document": [
[
{
"node": "Insert Documents",
"type": "ai_document",
"index": 0
}
]
]
},
"Vector Store Retriever": {
"ai_retriever": [
[
{
"node": "Question and Answer Chain",
"type": "ai_retriever",
"index": 0
}
]
]
},
"Question and Answer Chain": {
"main": [
[
{
"node": "Customize Response",
"type": "main",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "Question and Answer Chain",
"type": "main",
"index": 0
}
]
]
},
"Embeddings OpenAI Insertion": {
"ai_embedding": [
[
{
"node": "Insert Documents",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Embeddings OpenAI Retrieval": {
"ai_embedding": [
[
{
"node": "Retrieve by Query",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Embeddings OpenAI Upserting": {
"ai_embedding": [
[
{
"node": "Update Documents",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Recursive Character Text Splitter1": {
"ai_textSplitter": [
[
{
"node": "Default Data Loader",
"type": "ai_textSplitter",
"index": 0
}
]
]
},
"Placeholder (File/Content to Upsert)": {
"main": [
[
{
"node": "Update Documents",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 构建模块, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
实时数据RAG系统
使用Supabase和Notion将大型文档插入向量数据库
Limit
Notion
Supabase
+14
34 节点Mario
构建模块
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+38
244 节点Amanda Benks
销售
AI智能助手：与Supabase存储和Google Drive文件对话
AI智能助手：与Supabase存储和Google Drive文件对话
If
Set
Wait
+20
62 节点Mark Shcherbakov
工程
高级AI演示（在AI开发者第14次聚会中展示）
高级AI演示（在AI开发者第14次聚会中展示）
If
Code
Gmail
+19
39 节点Max Tkacz
构建模块
使用 Qdrant 的完整 RAG 系统，带自动来源引用
使用Qdrant、Gemini和OpenAI构建带自动引用的RAG系统
Set
Code
Wait
+15
29 节点Davide
人工智能
启用RAG中文档的更新功能
使用Google Drive、Qdrant和Gemini Chat构建和更新RAG系统
Set
Wait
Google Drive
+12
29 节点Davide
人工智能
