Vektorspeicher
Fortgeschritten
Dies ist ein Engineering, Multimodal AI-Bereich Automatisierungsworkflow mit 13 Nodes. Hauptsächlich werden GoogleSheets, ConvertToFile, Agent, ChatTrigger, EmbeddingsOpenAi und andere Nodes verwendet. Erstellen Sie einen persönlichen Datenvektorspeicher aus Google Sheets mit OpenAI und Gemini AI
Voraussetzungen
- •Google Sheets API-Anmeldedaten
- •OpenAI API Key
- •Google Gemini API Key
- •PostgreSQL-Datenbankverbindungsdaten
- •Supabase URL und API Key
Verwendete Nodes (13)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"id": "nd6AMUkZTTyLUCao",
"meta": {
"instanceId": "c3aa3d6f2185f4557415de4fd4d9322e835a16c7857dfc9bb5c578a3453c93b8",
"templateCredsSetupCompleted": true
},
"name": "Vector Store",
"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": "Bei Empfang einer Chat-Nachricht",
"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": "KI-Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-256,
-848
],
"parameters": {
"options": {}
},
"typeVersion": 2.1
},
{
"id": "213e8d03-3414-4b87-8374-4bb56179695c",
"name": "Google Gemini-Chat-Modell",
"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": "Zeile(n) in sheet1 abrufen",
"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 Vektorspeicher",
"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": "Default Data Loader2",
"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 Chat Speicher",
"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": "Einbettungen 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": "Einbettungen 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": "In Datei konvertieren",
"type": "n8n-nodes-base.convertToFile",
"position": [
-368,
-272
],
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "88200923-f5f3-433e-aa50-1cdd05b9d178",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
-384
],
"parameters": {
"width": 1024,
"height": 528,
"content": "## Vector Store Load :file_folder:\n### Insert Personal Data to Vector Store"
},
"typeVersion": 1
},
{
"id": "00c44b09-2c0f-4a23-8360-77e681be263e",
"name": "Haftnotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
-1024
],
"parameters": {
"color": 5,
"width": 1024,
"height": 592,
"content": "## Agent :information_desk_person:\n### Agent can answer any personal information on Vector Store"
},
"typeVersion": 1
},
{
"id": "bc8e0fe2-5d56-4cfc-9eb8-b8c6c75b6cee",
"name": "Vektorspeicher",
"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": {
"b0d9356b-9899-4a6b-8ed3-7251dd95907b": {
"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
}
]
]
},
"8510b172-bfe6-4aab-8ca0-c6437e66b766": {
"ai_document": [
[
{
"node": "Vector Store",
"type": "ai_document",
"index": 0
}
]
]
},
"79899926-cff5-45eb-af1e-f468e427dfda": {
"main": [
[
{
"node": "b0d9356b-9899-4a6b-8ed3-7251dd95907b",
"type": "main",
"index": 0
}
]
]
},
"Postgres Chat Memory": {
"ai_memory": [
[
{
"node": "0513d68e-6da9-4dae-8afb-1dc02223e727",
"type": "ai_memory",
"index": 0
}
]
]
},
"Supabase Vector Store": {
"ai_tool": [
[
{
"node": "0513d68e-6da9-4dae-8afb-1dc02223e727",
"type": "ai_tool",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "0513d68e-6da9-4dae-8afb-1dc02223e727",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"3de1a952-043a-46cc-be79-7e314399351a": {
"main": [
[
{
"node": "0513d68e-6da9-4dae-8afb-1dc02223e727",
"type": "main",
"index": 0
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Fortgeschritten - Engineering, Multimodales KI
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
n8n-Knoten in der visuellen Referenzbibliothek erkunden
Erkundung von n8n-Knoten in der visuellen Referenzbibliothek
If
Ftp
Set
+
If
Ftp
Set
113 NodesI versus AI
Sonstiges
Neu-Ranking #1
Automatisierung des Telefonmarketings durch Web-Scraping, GPT-4o und WhatsApp
Set
Code
Webhook
+
Set
Code
Webhook
48 NodesKhaisa Studio
Lead-Pflege
RAG-Chatbot mit Google Drive
RAG-Wissens-Chatbot mit OpenAI, Google Drive und Supabase bauen
Set
Supabase
Google Drive
+
Set
Supabase
Google Drive
20 NodesBabish Shrestha
Verschiedenes
Mit Dokumenten via RAG chatten: von Google Drive zu GPT-5, mit Supabase-Vektordatenbank
Mit Dokumenten durch RAG sprechen: von Google Drive zu GPT-5 mit Supabase-Vektordatenbank
Set
Gmail
Slack
+
Set
Gmail
Slack
30 NodesPaul
Internes Wiki
Ein sich selbst aktualisierender RAG-Chatbot (Google Drive, Gemini und Supabase) erstellen
Erstellen Sie einen sich selbst aktualisierenden RAG-Chatbot mit Google Drive, Gemini und Supabase
Set
Code
Merge
+
Set
Code
Merge
45 NodesAnirudh Aeran
Content-Erstellung
Neuanordnung #1
Automatisierung der Kaltakquise-Pipeline für Verkäufe mit Apify, GPT-4o und WhatsApp
Set
Code
Webhook
+
Set
Code
Webhook
48 NodesKhairul Muhtadin
Lead-Pflege
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes13
Kategorie2
Node-Typen10
Autor
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.
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen