Stockage vectoriel
Intermédiaire
Ceci est unEngineering, Multimodal AIworkflow d'automatisation du domainecontenant 13 nœuds.Utilise principalement des nœuds comme GoogleSheets, ConvertToFile, Agent, ChatTrigger, EmbeddingsOpenAi. Utiliser OpenAI et Gemini AI pour créer un stockage de vecteurs de données personnelles à partir de Google Sheets
Prérequis
- •Informations d'identification Google Sheets API
- •Clé API OpenAI
- •Clé API Google Gemini
- •Informations de connexion à la base de données PostgreSQL
- •URL et Clé API Supabase
Nœuds utilisés (13)
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"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": "À la réception d'un message chat",
"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": "Agent IA",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-256,
-848
],
"parameters": {
"options": {}
},
"typeVersion": 2.1
},
{
"id": "213e8d03-3414-4b87-8374-4bb56179695c",
"name": "Google Gemini Chat Model",
"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": "Obtenir la/les ligne(s) dans 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": "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": "Mémoire de Chat 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": "Embeddings 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": "Embeddings 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": "Convertir en Fichier",
"type": "n8n-nodes-base.convertToFile",
"position": [
-368,
-272
],
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "88200923-f5f3-433e-aa50-1cdd05b9d178",
"name": "Note Adhésive",
"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": "Note Adhésive1",
"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": "Vector Store",
"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": "bc8e0fe2-5d56-4cfc-9eb8-b8c6c75b6cee",
"type": "main",
"index": 0
}
]
]
},
"89597607-b666-4b6b-8f55-63b8bf6f44db": {
"ai_embedding": [
[
{
"node": "bc8e0fe2-5d56-4cfc-9eb8-b8c6c75b6cee",
"type": "ai_embedding",
"index": 0
}
]
]
},
"b8c7629a-1ff0-401c-888d-b79def975fe3": {
"ai_embedding": [
[
{
"node": "a7f53efa-8819-4b5a-9489-20fe543b2624",
"type": "ai_embedding",
"index": 0
}
]
]
},
"8510b172-bfe6-4aab-8ca0-c6437e66b766": {
"ai_document": [
[
{
"node": "bc8e0fe2-5d56-4cfc-9eb8-b8c6c75b6cee",
"type": "ai_document",
"index": 0
}
]
]
},
"79899926-cff5-45eb-af1e-f468e427dfda": {
"main": [
[
{
"node": "b0d9356b-9899-4a6b-8ed3-7251dd95907b",
"type": "main",
"index": 0
}
]
]
},
"b178e5a3-3fad-457d-85e1-60505dda4bdd": {
"ai_memory": [
[
{
"node": "0513d68e-6da9-4dae-8afb-1dc02223e727",
"type": "ai_memory",
"index": 0
}
]
]
},
"a7f53efa-8819-4b5a-9489-20fe543b2624": {
"ai_tool": [
[
{
"node": "0513d68e-6da9-4dae-8afb-1dc02223e727",
"type": "ai_tool",
"index": 0
}
]
]
},
"213e8d03-3414-4b87-8374-4bb56179695c": {
"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
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Intermédiaire - Ingénierie, IA Multimodale
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Explorer les nœuds n8n dans la bibliothèque de références visuelles
Explorer les nœuds n8n dans la base de références visuelles
If
Ftp
Set
+
If
Ftp
Set
113 NœudsI versus AI
Autres
Reclassement #1
Automatisation du marketing téléphonique avec le web scraping, GPT-4o et WhatsApp
Set
Code
Webhook
+
Set
Code
Webhook
48 NœudsKhaisa Studio
Nurturing de leads
Chatbot RAG avec Google Drive
Construire un chatbot de connaissances RAG avec OpenAI, Google Drive et Supabase
Set
Supabase
Google Drive
+
Set
Supabase
Google Drive
20 NœudsBabish Shrestha
Divers
Discuter avec des documents via RAG : de Google Drive à GPT-5, avec une base de données vectorielle Supabase
Dialoguer avec des documents via RAG : de Google Drive à GPT-5, en utilisant la base de vecteurs Supabase
Set
Gmail
Slack
+
Set
Gmail
Slack
30 NœudsPaul
Wiki interne
Créer un chatbot RAG auto-mis à jour (Google Drive, Gemini et Supabase)
Utiliser Google Drive, Gemini et Supabase pour créer un chatbot RAG auto-mis à jour
Set
Code
Merge
+
Set
Code
Merge
45 NœudsAnirudh Aeran
Création de contenu
Réorganiser #1
Automatiser le pipeline d'appels froids commerciaux avec Apify, GPT-4o et WhatsApp
Set
Code
Webhook
+
Set
Code
Webhook
48 NœudsKhairul Muhtadin
Nurturing de leads
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds13
Catégorie2
Types de nœuds10
Description de la difficulté
Auteur
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.
Liens externes
Voir sur n8n.io →
Partager ce workflow