Google-Drive-Dateieninjektion in Supabase-Wissensdatenbank
Dies ist ein Support, AI-Bereich Automatisierungsworkflow mit 46 Nodes. Hauptsächlich werden If, Set, Gmail, Switch, Postgres und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Interaktives Wissensbasis-Chat basierend auf Supabase RAG und GPT-4o-mini
- •Google-Konto + Gmail API-Anmeldedaten
- •PostgreSQL-Datenbankverbindungsdaten
- •Supabase URL und API Key
- •Google Drive API-Anmeldedaten
- •OpenAI API Key
Verwendete Nodes (46)
Kategorie
{
"id": "6fZffoKqrzLAmbHc",
"meta": {
"instanceId": "3aaeb6eaba3494bbdbe57e25fa3d02783cfbc460b1e823f7b741cf26edc7ca3d"
},
"name": "Google Drive File Ingestion to Supabase for Knowledge Base",
"tags": [],
"nodes": [
{
"id": "eff80cb0-26e5-4a19-a4d6-671a11fe26b6",
"name": "Datei erstellt",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-80,
880
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a78ad8a2-93a9-4c71-8916-e6247d408d82",
"name": "Dateiaktualisierung",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-80,
680
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f8a528ba-9638-4a32-a2e2-596c4a63da0c",
"name": "Elemente durchlaufen",
"type": "n8n-nodes-base.splitInBatches",
"position": [
140,
780
],
"parameters": {},
"typeVersion": 3
},
{
"id": "bf8e763f-fff5-4fa4-a0ec-4b13bdeb498d",
"name": "Datei-ID setzen",
"type": "n8n-nodes-base.set",
"position": [
360,
640
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "47bc2891-8f9f-416d-b2ce-8fd656796348",
"name": "Auf Duplikate prüfen",
"type": "n8n-nodes-base.postgres",
"position": [
800,
540
],
"parameters": {},
"typeVersion": 2.6,
"alwaysOutputData": true
},
{
"id": "71dd64ed-9c40-4ef0-bf24-5243b2cff499",
"name": "Metadaten einfügen",
"type": "n8n-nodes-base.postgres",
"position": [
1900,
740
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "6a66a187-30c1-46b0-830f-484add803b1d",
"name": "Aus PDF extrahieren",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ebc02b0a-0481-42e8-8043-e9bcd6c0f02e",
"name": "Aus CSV extrahieren",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2560,
580
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8bb13f35-03c3-413a-9dcc-1526f40325d3",
"name": "Aus XLSX extrahieren",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2560,
980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a598e49c-d9bc-4305-b917-ccc64feb4c68",
"name": "Aggregieren",
"type": "n8n-nodes-base.aggregate",
"position": [
2780,
740
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e1c0c059-66f5-4a1b-b76a-8db1823c25e1",
"name": "Zusammenfassen",
"type": "n8n-nodes-base.summarize",
"position": [
3000,
740
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "cb46dfca-96ce-478a-98cb-5c94fd48e104",
"name": "Aus RTF extrahieren",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
1160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9832240d-7cea-465e-b167-17fcf254f5f7",
"name": "Fehlerprotokoll",
"type": "n8n-nodes-base.supabase",
"position": [
1240,
1380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "01b5f966-e5b7-436e-9551-c31f6b9d4eac",
"name": "Datei validieren",
"type": "n8n-nodes-base.if",
"position": [
580,
640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "466e1cc8-25e7-462c-b19f-467c66eb1d77",
"name": "IF Duplikatprüfung",
"type": "n8n-nodes-base.if",
"position": [
1020,
540
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0dd9891e-7dd3-4f2d-8a2e-094ab3cecec6",
"name": "Duplikat protokollieren",
"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": "Default Data Loader",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
3340,
660
],
"parameters": {},
"typeVersion": 1
},
{
"id": "86c648a9-4b9d-4afb-9e2e-f4fff12a1ce0",
"name": "Datei-ID debuggen",
"type": "n8n-nodes-base.set",
"position": [
1240,
740
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "392916f3-2265-4c57-abfd-37054da9e741",
"name": "Datei herunterladen",
"type": "n8n-nodes-base.googleDrive",
"position": [
2120,
740
],
"parameters": {},
"typeVersion": 3
},
{
"id": "a7367c0f-6f22-4099-ac6c-8511081b79f6",
"name": "Schema setzen",
"type": "n8n-nodes-base.set",
"position": [
3360,
1160
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7051505f-4da8-44c0-90c4-c522d3a2f6d3",
"name": "Schema Dokument-Metadaten",
"type": "n8n-nodes-base.postgres",
"position": [
3600,
1160
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "6f76fa9d-d1f9-4e05-80af-ec78fed5416c",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
2340,
680
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "f62efcf8-bb87-4e4e-9c73-0c86ec1c55fd",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-120,
-60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "82015f8b-1456-4b04-bf38-2735e7f416f6",
"name": "Aus DOC extrahieren",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
1360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7af0771c-bed1-4cbb-8122-01ec2d8b4664",
"name": "Slack Duplicate Notification",
"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": "Error Notification",
"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": "Altes Dokument löschen",
"type": "n8n-nodes-base.supabase",
"position": [
1460,
740
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "98d0c000-5d9b-419b-aa7c-e98a9f0a90e2",
"name": "Aus TXT extrahieren",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a53ca5ed-b9f0-4f9e-bb55-017dc5ed1451",
"name": "Haftnotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1880,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a1c76c00-0bed-48f0-ad8c-f686d5186222",
"name": "Haftnotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1620,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "71f8678a-ef8b-40ef-a3ef-3ee90afe65dc",
"name": "RAG AI Agent",
"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": "Postgres Chat Memory",
"type": "@n8n/n8n-nodes-langchain.memoryPostgresChat",
"position": [
-1280,
1180
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "223791e6-5148-47cd-aab6-ca9cb20b7017",
"name": "Dokumente auflisten",
"type": "n8n-nodes-base.postgresTool",
"position": [
-1060,
1180
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "25cc4ca1-4910-4ae7-a755-c5611946c325",
"name": "Dokumentenzeilen abfragen",
"type": "n8n-nodes-base.postgresTool",
"position": [
-620,
1180
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "194c1ee8-1c21-4a1d-b8d2-9991dc8133fd",
"name": "Character Text Splitter",
"type": "@n8n/n8n-nodes-langchain.textSplitterCharacterTextSplitter",
"position": [
3440,
860
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f311ab63-88fa-413a-8ba9-aa866e1fb5f0",
"name": "Tabellenzeilen einfügen",
"type": "n8n-nodes-base.postgres",
"position": [
2780,
940
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "529e05ca-0494-4eb3-b0f4-275ba252f646",
"name": "Alte Datenzeilen löschen",
"type": "n8n-nodes-base.supabase",
"position": [
1680,
740
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "d1702791-fe65-4068-982b-8b378f9c2e0a",
"name": "Fehlertyp setzen",
"type": "n8n-nodes-base.set",
"position": [
1020,
1200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "23a05be3-2b40-400b-b8d4-21ee6db78ac4",
"name": "Bei Chat-Nachrichtenempfang",
"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": "Felder bearbeiten2",
"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": "Vollständigen Dokumenttext abrufen - Dateiinhalt holen",
"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
}
]
]
}
}
}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?
Experte - Support, Künstliche Intelligenz
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
Immanuel
@spectrabitDiesen Workflow teilen