向量存储
中级
这是一个Engineering, Multimodal AI领域的自动化工作流，包含 13 个节点。主要使用 GoogleSheets, ConvertToFile, Agent, ChatTrigger, EmbeddingsOpenAi 等节点。 使用OpenAI和Gemini AI从Google Sheets创建个人数据向量存储
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
- •Google Gemini API Key
- •PostgreSQL 数据库连接信息
- •Supabase URL 和 API Key
使用的节点 (13)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "nd6AMUkZTTyLUCao",
"meta": {
"instanceId": "c3aa3d6f2185f4557415de4fd4d9322e835a16c7857dfc9bb5c578a3453c93b8",
"templateCredsSetupCompleted": true
},
"name": "向量存储",
"tags": [
{
"id": "0CVNvLkMsFx0fYp2",
"name": "vector",
"createdAt": "2025-08-12T15:02:22.969Z",
"updatedAt": "2025-08-12T15:02:22.969Z"
},
{
"id": "AGb9sgonhJTDopA7",
"name": "agent",
"createdAt": "2025-08-12T15:02:28.571Z",
"updatedAt": "2025-08-12T15:02:28.571Z"
},
{
"id": "7KrXwk3m9PhErl7A",
"name": "memory",
"createdAt": "2025-08-12T15:02:37.615Z",
"updatedAt": "2025-08-12T15:02:37.615Z"
}
],
"nodes": [
{
"id": "3de1a952-043a-46cc-be79-7e314399351a",
"name": "当收到聊天消息时",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-592,
-848
],
"webhookId": "a1c07fe3-73c6-458c-bf3d-30040273a27e",
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "0513d68e-6da9-4dae-8afb-1dc02223e727",
"name": "AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-256,
-848
],
"parameters": {
"options": {}
},
"typeVersion": 2.1
},
{
"id": "213e8d03-3414-4b87-8374-4bb56179695c",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
-272,
-672
],
"parameters": {
"options": {}
},
"credentials": {
"googlePalmApi": {
"id": "yZQEvQxhWU0JUDgM",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "79899926-cff5-45eb-af1e-f468e427dfda",
"name": "获取 sheet1 中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-576,
-272
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gORnXWKOs9ENYCUki_9hLE_H3bZVKnerZqOPhNzVMRc/edit#gid=0",
"cachedResultName": "Birthday"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1gORnXWKOs9ENYCUki_9hLE_H3bZVKnerZqOPhNzVMRc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gORnXWKOs9ENYCUki_9hLE_H3bZVKnerZqOPhNzVMRc/edit?usp=drivesdk",
"cachedResultName": "Personal Birthday"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "rNId5842mzkdaFvl",
"name": "Google Sheets GRM"
}
},
"typeVersion": 4.6
},
{
"id": "a7f53efa-8819-4b5a-9489-20fe543b2624",
"name": "Supabase Vector Store",
"type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
"position": [
-32,
-720
],
"parameters": {
"mode": "retrieve-as-tool",
"options": {
"queryName": "match_personal_data"
},
"tableName": {
"__rl": true,
"mode": "list",
"value": "personal_data",
"cachedResultName": "personal_data"
},
"toolDescription": "Personal details table"
},
"credentials": {
"supabaseApi": {
"id": "mQIo3PRJSDAr1T7Y",
"name": "Supabase account"
}
},
"typeVersion": 1.3
},
{
"id": "8510b172-bfe6-4aab-8ca0-c6437e66b766",
"name": "默认数据加载器2",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
96,
-32
],
"parameters": {
"loader": "csvLoader",
"options": {},
"dataType": "binary"
},
"typeVersion": 1.1
},
{
"id": "b178e5a3-3fad-457d-85e1-60505dda4bdd",
"name": "Postgres 聊天记忆",
"type": "@n8n/n8n-nodes-langchain.memoryPostgresChat",
"position": [
-160,
-640
],
"parameters": {},
"credentials": {
"postgres": {
"id": "7UcDVxFeJ671y1tk",
"name": "Postgres account"
}
},
"typeVersion": 1.3
},
{
"id": "89597607-b666-4b6b-8f55-63b8bf6f44db",
"name": "OpenAI嵌入",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
-112,
-80
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "iUylyqZDd8P9Lu2O",
"name": "OpenAi GRM"
}
},
"typeVersion": 1.2
},
{
"id": "b8c7629a-1ff0-401c-888d-b79def975fe3",
"name": "嵌入 OpenAI1",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
-32,
-592
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "iUylyqZDd8P9Lu2O",
"name": "OpenAi GRM"
}
},
"typeVersion": 1.2
},
{
"id": "b0d9356b-9899-4a6b-8ed3-7251dd95907b",
"name": "[{",
"type": "n8n-nodes-base.convertToFile",
"position": [
-368,
-272
],
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "88200923-f5f3-433e-aa50-1cdd05b9d178",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
-384
],
"parameters": {
"width": 1024,
"height": 528,
"content": "## Vector Store 加载 :file_folder:"
},
"typeVersion": 1
},
{
"id": "00c44b09-2c0f-4a23-8360-77e681be263e",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
-1024
],
"parameters": {
"color": 5,
"width": 1024,
"height": 592,
"content": "## 代理 :information_desk_person:"
},
"typeVersion": 1
},
{
"id": "bc8e0fe2-5d56-4cfc-9eb8-b8c6c75b6cee",
"name": "向量存储",
"type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
"position": [
-112,
-272
],
"parameters": {
"mode": "insert",
"options": {
"queryName": "match_personal_data"
},
"tableName": {
"__rl": true,
"mode": "list",
"value": "personal_data",
"cachedResultName": "personal_data"
}
},
"credentials": {
"supabaseApi": {
"id": "mQIo3PRJSDAr1T7Y",
"name": "Supabase account"
}
},
"typeVersion": 1.3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "6ff1646e-f18a-4228-8d17-bd22b50b2bdb",
"connections": {
"Convert to File": {
"main": [
[
{
"node": "Vector Store",
"type": "main",
"index": 0
}
]
]
},
"Embeddings OpenAI": {
"ai_embedding": [
[
{
"node": "Vector Store",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Embeddings OpenAI1": {
"ai_embedding": [
[
{
"node": "Supabase Vector Store",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Default Data Loader2": {
"ai_document": [
[
{
"node": "Vector Store",
"type": "ai_document",
"index": 0
}
]
]
},
"Get row(s) in sheet1": {
"main": [
[
{
"node": "Convert to File",
"type": "main",
"index": 0
}
]
]
},
"Postgres Chat Memory": {
"ai_memory": [
[
{
"node": "AI Agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"Supabase Vector Store": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 工程, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
重新排名 #1
通过网页爬取、GPT-4o和WhatsApp自动化电话营销
Set
Code
Webhook
+18
48 节点Khaisa Studio
客户培育
使用 Google Drive 的 RAG 聊天机器人
使用OpenAI、Google Drive和Supabase构建RAG知识聊天机器人
Set
Supabase
Google Drive
+12
20 节点Babish Shrestha
杂项
通过RAG与文档对话：从Google Drive到GPT-5，使用Supabase向量数据库
通过RAG与文档对话：从Google Drive到GPT-5，使用Supabase向量数据库
Set
Gmail
Slack
+19
30 节点Paul
内部知识库
创建自更新的RAG聊天机器人（Google Drive、Gemini和Supabase）
使用Google Drive、Gemini和Supabase创建自更新的RAG聊天机器人
Set
Code
Merge
+19
45 节点Anirudh Aeran
内容创作
具有增强检索、过滤器和记忆功能的智能 RAG 代理 - 由 ascuncia 开发
具备增强检索和模块化工作流的智能 RAG 代理
Set
Wait
Merge
+16
32 节点Alejandro Scuncia
AI RAG 检索增强
工作流信息
难度等级
中级
节点数量13
分类2
节点类型10
作者
Mustafa Polat
@mpolatWith 20+ years in marketing, I’ve worked as a developer and manager, leading teams and building innovative solutions. My expertise includes data engineering, designing native architectures on Google and AWS cloud, and integrating APIs to optimize workflows. I specialize in developing custom APIs and leveraging data to drive business efficiency, making impactful, data-driven decisions for organizations.
外部链接
在 n8n.io 查看 →
分享此工作流