Ingestion de fichiers Google Drive vers la base de connaissances Supabase
Ceci est unSupport, AIworkflow d'automatisation du domainecontenant 46 nœuds.Utilise principalement des nœuds comme If, Set, Gmail, Switch, Postgres, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Base de connaissances interactive de type chat basée sur RAG Supabase et GPT-4o-mini
- •Compte Google et informations d'identification Gmail API
- •Informations de connexion à la base de données PostgreSQL
- •URL et Clé API Supabase
- •Informations d'identification Google Drive API
- •Clé API OpenAI
Nœuds utilisés (46)
Catégorie
{
"id": "6fZffoKqrzLAmbHc",
"meta": {
"instanceId": "3aaeb6eaba3494bbdbe57e25fa3d02783cfbc460b1e823f7b741cf26edc7ca3d"
},
"name": "Google Drive File Ingestion to Supabase for Knowledge Base",
"tags": [],
"nodes": [
{
"id": "eff80cb0-26e5-4a19-a4d6-671a11fe26b6",
"name": "Fichier créé",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-80,
880
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a78ad8a2-93a9-4c71-8916-e6247d408d82",
"name": "Mise à jour de fichier",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-80,
680
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f8a528ba-9638-4a32-a2e2-596c4a63da0c",
"name": "Boucle sur les éléments",
"type": "n8n-nodes-base.splitInBatches",
"position": [
140,
780
],
"parameters": {},
"typeVersion": 3
},
{
"id": "bf8e763f-fff5-4fa4-a0ec-4b13bdeb498d",
"name": "Définir l'ID du fichier",
"type": "n8n-nodes-base.set",
"position": [
360,
640
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "47bc2891-8f9f-416d-b2ce-8fd656796348",
"name": "Vérifier les doublons",
"type": "n8n-nodes-base.postgres",
"position": [
800,
540
],
"parameters": {},
"typeVersion": 2.6,
"alwaysOutputData": true
},
{
"id": "71dd64ed-9c40-4ef0-bf24-5243b2cff499",
"name": "Insérer les métadonnées",
"type": "n8n-nodes-base.postgres",
"position": [
1900,
740
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "6a66a187-30c1-46b0-830f-484add803b1d",
"name": "Extraire du fichier PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ebc02b0a-0481-42e8-8043-e9bcd6c0f02e",
"name": "Extraire de CSV",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2560,
580
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8bb13f35-03c3-413a-9dcc-1526f40325d3",
"name": "Extraire de XLSX",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2560,
980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a598e49c-d9bc-4305-b917-ccc64feb4c68",
"name": "Agréger",
"type": "n8n-nodes-base.aggregate",
"position": [
2780,
740
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e1c0c059-66f5-4a1b-b76a-8db1823c25e1",
"name": "Résumer",
"type": "n8n-nodes-base.summarize",
"position": [
3000,
740
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "cb46dfca-96ce-478a-98cb-5c94fd48e104",
"name": "Extraire de RTF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
1160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9832240d-7cea-465e-b167-17fcf254f5f7",
"name": "Enregistreur d'erreurs",
"type": "n8n-nodes-base.supabase",
"position": [
1240,
1380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "01b5f966-e5b7-436e-9551-c31f6b9d4eac",
"name": "Valider le fichier",
"type": "n8n-nodes-base.if",
"position": [
580,
640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "466e1cc8-25e7-462c-b19f-467c66eb1d77",
"name": "SI vérification doublon",
"type": "n8n-nodes-base.if",
"position": [
1020,
540
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0dd9891e-7dd3-4f2d-8a2e-094ab3cecec6",
"name": "Journaliser doublon",
"type": "n8n-nodes-base.supabase",
"position": [
1240,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7d05de17-7909-4da3-bba3-c7f512af1708",
"name": "Supabase Vector Store",
"type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
"position": [
3240,
440
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "a764be2e-110f-4320-8bae-f04a749a3ac5",
"name": "Embeddings OpenAI",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
3220,
660
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "0ef91d4c-7d6b-4544-9ef5-09a0bdb6dd7c",
"name": "Chargeur de données par défaut",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
3340,
660
],
"parameters": {},
"typeVersion": 1
},
{
"id": "86c648a9-4b9d-4afb-9e2e-f4fff12a1ce0",
"name": "Déboguer l'ID du fichier",
"type": "n8n-nodes-base.set",
"position": [
1240,
740
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "392916f3-2265-4c57-abfd-37054da9e741",
"name": "Télécharger le fichier",
"type": "n8n-nodes-base.googleDrive",
"position": [
2120,
740
],
"parameters": {},
"typeVersion": 3
},
{
"id": "a7367c0f-6f22-4099-ac6c-8511081b79f6",
"name": "Définir le schéma",
"type": "n8n-nodes-base.set",
"position": [
3360,
1160
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7051505f-4da8-44c0-90c4-c522d3a2f6d3",
"name": "Métadonnées du document de schéma",
"type": "n8n-nodes-base.postgres",
"position": [
3600,
1160
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "6f76fa9d-d1f9-4e05-80af-ec78fed5416c",
"name": "Commutateur",
"type": "n8n-nodes-base.switch",
"position": [
2340,
680
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "f62efcf8-bb87-4e4e-9c73-0c86ec1c55fd",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-120,
-60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "82015f8b-1456-4b04-bf38-2735e7f416f6",
"name": "Extraire de DOC",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
1360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7af0771c-bed1-4cbb-8122-01ec2d8b4664",
"name": "Slack Notification de doublon",
"type": "n8n-nodes-base.gmail",
"position": [
1460,
440
],
"webhookId": "b530b409-ce3a-44eb-9efc-ab091105fa54",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "a5ef8a35-ea86-466a-bb6b-2f3ef72acab7",
"name": "Notification d'erreur",
"type": "n8n-nodes-base.gmail",
"position": [
1460,
1400
],
"webhookId": "b530b409-ce3a-44eb-9efc-ab091105fa54",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "6ca4d2d7-536c-4229-ac19-39dcb0853c4c",
"name": "Supprimer ancien document",
"type": "n8n-nodes-base.supabase",
"position": [
1460,
740
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "98d0c000-5d9b-419b-aa7c-e98a9f0a90e2",
"name": "Extraire de TXT",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a53ca5ed-b9f0-4f9e-bb55-017dc5ed1451",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1880,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a1c76c00-0bed-48f0-ad8c-f686d5186222",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1620,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "71f8678a-ef8b-40ef-a3ef-3ee90afe65dc",
"name": "Agent IA RAG",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-880,
700
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "7c7ebb71-1699-46a5-a756-cf2589815dc8",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-1460,
1180
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "510482ba-030b-4777-9740-bf8993dce021",
"name": "Mémoire de chat Postgres",
"type": "@n8n/n8n-nodes-langchain.memoryPostgresChat",
"position": [
-1280,
1180
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "223791e6-5148-47cd-aab6-ca9cb20b7017",
"name": "Lister les documents",
"type": "n8n-nodes-base.postgresTool",
"position": [
-1060,
1180
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "25cc4ca1-4910-4ae7-a755-c5611946c325",
"name": "Interroger les lignes de document",
"type": "n8n-nodes-base.postgresTool",
"position": [
-620,
1180
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "194c1ee8-1c21-4a1d-b8d2-9991dc8133fd",
"name": "Séparateur de texte par caractère",
"type": "@n8n/n8n-nodes-langchain.textSplitterCharacterTextSplitter",
"position": [
3440,
860
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f311ab63-88fa-413a-8ba9-aa866e1fb5f0",
"name": "Insérer des lignes de table",
"type": "n8n-nodes-base.postgres",
"position": [
2780,
940
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "529e05ca-0494-4eb3-b0f4-275ba252f646",
"name": "Supprimer les anciennes lignes de données",
"type": "n8n-nodes-base.supabase",
"position": [
1680,
740
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "d1702791-fe65-4068-982b-8b378f9c2e0a",
"name": "Définir le type d'erreur",
"type": "n8n-nodes-base.set",
"position": [
1020,
1200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "23a05be3-2b40-400b-b8d4-21ee6db78ac4",
"name": "À la réception d'un message de chat",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-1440,
720
],
"webhookId": "db7e7558-fd4c-4743-b42c-d3b3a38e4d19",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "89262c14-2910-4a9d-b86a-84c015e0daa5",
"name": "Modifier les champs2",
"type": "n8n-nodes-base.set",
"position": [
-1180,
700
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2325e26f-6237-4128-bead-17e0a9ccb50d",
"name": "Supabase Vector Store2",
"type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
"position": [
-460,
840
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "1289b037-7bc9-4d13-9516-328f1f781c14",
"name": "Embeddings OpenAI2",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
-240,
1060
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "3d15f7db-e7b7-4bb7-a5f7-9962f3a81051",
"name": "Obtenir le texte complet du document - Obtenir le contenu du fichier",
"type": "n8n-nodes-base.postgresTool",
"position": [
-820,
1180
],
"parameters": {},
"typeVersion": 2.6
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "0c6700ed-433f-46ca-8907-c2f4f94adfda",
"connections": {
"6f76fa9d-d1f9-4e05-80af-ec78fed5416c": {
"main": [
[
{
"node": "6a66a187-30c1-46b0-830f-484add803b1d",
"type": "main",
"index": 0
}
],
[
{
"node": "98d0c000-5d9b-419b-aa7c-e98a9f0a90e2",
"type": "main",
"index": 0
}
],
[
{
"node": "ebc02b0a-0481-42e8-8043-e9bcd6c0f02e",
"type": "main",
"index": 0
}
],
[
{
"node": "8bb13f35-03c3-413a-9dcc-1526f40325d3",
"type": "main",
"index": 0
}
],
[
{
"node": "cb46dfca-96ce-478a-98cb-5c94fd48e104",
"type": "main",
"index": 0
}
],
[
{
"node": "82015f8b-1456-4b04-bf38-2735e7f416f6",
"type": "main",
"index": 0
}
]
]
},
"a598e49c-d9bc-4305-b917-ccc64feb4c68": {
"main": [
[
{
"node": "e1c0c059-66f5-4a1b-b76a-8db1823c25e1",
"type": "main",
"index": 0
}
]
]
},
"e1c0c059-66f5-4a1b-b76a-8db1823c25e1": {
"main": [
[
{
"node": "7d05de17-7909-4da3-bba3-c7f512af1708",
"type": "main",
"index": 0
},
{
"node": "a7367c0f-6f22-4099-ac6c-8511081b79f6",
"type": "main",
"index": 0
}
]
]
},
"a7367c0f-6f22-4099-ac6c-8511081b79f6": {
"main": [
[
{
"node": "7051505f-4da8-44c0-90c4-c522d3a2f6d3",
"type": "main",
"index": 0
}
]
]
},
"bf8e763f-fff5-4fa4-a0ec-4b13bdeb498d": {
"main": [
[
{
"node": "01b5f966-e5b7-436e-9551-c31f6b9d4eac",
"type": "main",
"index": 0
}
]
]
},
"89262c14-2910-4a9d-b86a-84c015e0daa5": {
"main": [
[
{
"node": "71f8678a-ef8b-40ef-a3ef-3ee90afe65dc",
"type": "main",
"index": 0
}
]
]
},
"9832240d-7cea-465e-b167-17fcf254f5f7": {
"main": [
[
{
"node": "a5ef8a35-ea86-466a-bb6b-2f3ef72acab7",
"type": "main",
"index": 0
}
]
]
},
"eff80cb0-26e5-4a19-a4d6-671a11fe26b6": {
"main": [
[
{
"node": "f8a528ba-9638-4a32-a2e2-596c4a63da0c",
"type": "main",
"index": 0
}
]
]
},
"86c648a9-4b9d-4afb-9e2e-f4fff12a1ce0": {
"main": [
[
{
"node": "6ca4d2d7-536c-4229-ac19-39dcb0853c4c",
"type": "main",
"index": 0
}
]
]
},
"392916f3-2265-4c57-abfd-37054da9e741": {
"main": [
[
{
"node": "6f76fa9d-d1f9-4e05-80af-ec78fed5416c",
"type": "main",
"index": 0
}
]
]
},
"0dd9891e-7dd3-4f2d-8a2e-094ab3cecec6": {
"main": [
[
{
"node": "7af0771c-bed1-4cbb-8122-01ec2d8b4664",
"type": "main",
"index": 0
}
]
]
},
"01b5f966-e5b7-436e-9551-c31f6b9d4eac": {
"main": [
[
{
"node": "47bc2891-8f9f-416d-b2ce-8fd656796348",
"type": "main",
"index": 0
}
],
[
{
"node": "d1702791-fe65-4068-982b-8b378f9c2e0a",
"type": "main",
"index": 0
}
]
]
},
"6ca4d2d7-536c-4229-ac19-39dcb0853c4c": {
"main": [
[
{
"node": "529e05ca-0494-4eb3-b0f4-275ba252f646",
"type": "main",
"index": 0
}
]
]
},
"223791e6-5148-47cd-aab6-ca9cb20b7017": {
"ai_tool": [
[
{
"node": "71f8678a-ef8b-40ef-a3ef-3ee90afe65dc",
"type": "ai_tool",
"index": 0
}
]
]
},
"d1702791-fe65-4068-982b-8b378f9c2e0a": {
"main": [
[
{
"node": "9832240d-7cea-465e-b167-17fcf254f5f7",
"type": "main",
"index": 0
}
]
]
},
"a78ad8a2-93a9-4c71-8916-e6247d408d82": {
"main": [
[
{
"node": "f8a528ba-9638-4a32-a2e2-596c4a63da0c",
"type": "main",
"index": 0
}
]
]
},
"71dd64ed-9c40-4ef0-bf24-5243b2cff499": {
"main": [
[
{
"node": "392916f3-2265-4c57-abfd-37054da9e741",
"type": "main",
"index": 0
}
]
]
},
"f8a528ba-9638-4a32-a2e2-596c4a63da0c": {
"main": [
[],
[
{
"node": "bf8e763f-fff5-4fa4-a0ec-4b13bdeb498d",
"type": "main",
"index": 0
}
]
]
},
"ebc02b0a-0481-42e8-8043-e9bcd6c0f02e": {
"main": [
[
{
"node": "a598e49c-d9bc-4305-b917-ccc64feb4c68",
"type": "main",
"index": 0
},
{
"node": "f311ab63-88fa-413a-8ba9-aa866e1fb5f0",
"type": "main",
"index": 0
}
]
]
},
"82015f8b-1456-4b04-bf38-2735e7f416f6": {
"main": [
[
{
"node": "7d05de17-7909-4da3-bba3-c7f512af1708",
"type": "main",
"index": 0
}
]
]
},
"cb46dfca-96ce-478a-98cb-5c94fd48e104": {
"main": [
[
{
"node": "7d05de17-7909-4da3-bba3-c7f512af1708",
"type": "main",
"index": 0
}
]
]
},
"98d0c000-5d9b-419b-aa7c-e98a9f0a90e2": {
"main": [
[
{
"node": "7d05de17-7909-4da3-bba3-c7f512af1708",
"type": "main",
"index": 0
}
]
]
},
"a764be2e-110f-4320-8bae-f04a749a3ac5": {
"ai_embedding": [
[
{
"node": "7d05de17-7909-4da3-bba3-c7f512af1708",
"type": "ai_embedding",
"index": 0
}
]
]
},
"8bb13f35-03c3-413a-9dcc-1526f40325d3": {
"main": [
[
{
"node": "a598e49c-d9bc-4305-b917-ccc64feb4c68",
"type": "main",
"index": 0
},
{
"node": "f311ab63-88fa-413a-8ba9-aa866e1fb5f0",
"type": "main",
"index": 0
}
]
]
},
"7c7ebb71-1699-46a5-a756-cf2589815dc8": {
"ai_languageModel": [
[
{
"node": "71f8678a-ef8b-40ef-a3ef-3ee90afe65dc",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"1289b037-7bc9-4d13-9516-328f1f781c14": {
"ai_embedding": [
[
{
"node": "2325e26f-6237-4128-bead-17e0a9ccb50d",
"type": "ai_embedding",
"index": 0
}
]
]
},
"466e1cc8-25e7-462c-b19f-467c66eb1d77": {
"main": [
[
{
"node": "0dd9891e-7dd3-4f2d-8a2e-094ab3cecec6",
"type": "main",
"index": 0
}
],
[
{
"node": "86c648a9-4b9d-4afb-9e2e-f4fff12a1ce0",
"type": "main",
"index": 0
}
]
]
},
"0ef91d4c-7d6b-4544-9ef5-09a0bdb6dd7c": {
"ai_document": [
[
{
"node": "7d05de17-7909-4da3-bba3-c7f512af1708",
"type": "ai_document",
"index": 0
}
]
]
},
"25cc4ca1-4910-4ae7-a755-c5611946c325": {
"ai_tool": [
[
{
"node": "71f8678a-ef8b-40ef-a3ef-3ee90afe65dc",
"type": "ai_tool",
"index": 0
}
]
]
},
"47bc2891-8f9f-416d-b2ce-8fd656796348": {
"main": [
[
{
"node": "466e1cc8-25e7-462c-b19f-467c66eb1d77",
"type": "main",
"index": 0
}
]
]
},
"529e05ca-0494-4eb3-b0f4-275ba252f646": {
"main": [
[
{
"node": "71dd64ed-9c40-4ef0-bf24-5243b2cff499",
"type": "main",
"index": 0
}
]
]
},
"510482ba-030b-4777-9740-bf8993dce021": {
"ai_memory": [
[
{
"node": "71f8678a-ef8b-40ef-a3ef-3ee90afe65dc",
"type": "ai_memory",
"index": 0
}
]
]
},
"6a66a187-30c1-46b0-830f-484add803b1d": {
"main": [
[
{
"node": "7d05de17-7909-4da3-bba3-c7f512af1708",
"type": "main",
"index": 0
}
]
]
},
"7d05de17-7909-4da3-bba3-c7f512af1708": {
"main": [
[
{
"node": "f8a528ba-9638-4a32-a2e2-596c4a63da0c",
"type": "main",
"index": 0
}
]
]
},
"2325e26f-6237-4128-bead-17e0a9ccb50d": {
"ai_tool": [
[
{
"node": "71f8678a-ef8b-40ef-a3ef-3ee90afe65dc",
"type": "ai_tool",
"index": 0
}
]
]
},
"194c1ee8-1c21-4a1d-b8d2-9991dc8133fd": {
"ai_textSplitter": [
[
{
"node": "0ef91d4c-7d6b-4544-9ef5-09a0bdb6dd7c",
"type": "ai_textSplitter",
"index": 0
}
]
]
},
"23a05be3-2b40-400b-b8d4-21ee6db78ac4": {
"main": [
[
{
"node": "89262c14-2910-4a9d-b86a-84c015e0daa5",
"type": "main",
"index": 0
}
]
]
},
"3d15f7db-e7b7-4bb7-a5f7-9962f3a81051": {
"ai_tool": [
[
{
"node": "71f8678a-ef8b-40ef-a3ef-3ee90afe65dc",
"type": "ai_tool",
"index": 0
}
]
]
}
}
}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é ?
Avancé - Support, Intelligence Artificielle
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
Immanuel
@spectrabitPartager ce workflow