Ingesta de archivos de Google Drive a la base de conocimientos de Supabase
Este es unSupport, AIflujo de automatización del dominio deautomatización que contiene 46 nodos.Utiliza principalmente nodos como If, Set, Gmail, Switch, Postgres, combinando tecnología de inteligencia artificial para lograr automatización inteligente. Base de conocimientos conversacional interactiva basada en Supabase RAG y GPT-4o-mini
- •Cuenta de Google y credenciales de API de Gmail
- •Información de conexión de la base de datos PostgreSQL
- •URL y Clave de API de Supabase
- •Credenciales de API de Google Drive
- •Clave de API de OpenAI
Nodos utilizados (46)
Categoría
{
"id": "6fZffoKqrzLAmbHc",
"meta": {
"instanceId": "3aaeb6eaba3494bbdbe57e25fa3d02783cfbc460b1e823f7b741cf26edc7ca3d"
},
"name": "Google Drive File Ingestion to Supabase for Knowledge Base",
"tags": [],
"nodes": [
{
"id": "eff80cb0-26e5-4a19-a4d6-671a11fe26b6",
"name": "Archivo Creado",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-80,
880
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a78ad8a2-93a9-4c71-8916-e6247d408d82",
"name": "Actualización de Archivo",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-80,
680
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f8a528ba-9638-4a32-a2e2-596c4a63da0c",
"name": "Iterar sobre Elementos",
"type": "n8n-nodes-base.splitInBatches",
"position": [
140,
780
],
"parameters": {},
"typeVersion": 3
},
{
"id": "bf8e763f-fff5-4fa4-a0ec-4b13bdeb498d",
"name": "Establecer ID de Archivo",
"type": "n8n-nodes-base.set",
"position": [
360,
640
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "47bc2891-8f9f-416d-b2ce-8fd656796348",
"name": "Verificar Duplicados",
"type": "n8n-nodes-base.postgres",
"position": [
800,
540
],
"parameters": {},
"typeVersion": 2.6,
"alwaysOutputData": true
},
{
"id": "71dd64ed-9c40-4ef0-bf24-5243b2cff499",
"name": "Insertar Metadatos",
"type": "n8n-nodes-base.postgres",
"position": [
1900,
740
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "6a66a187-30c1-46b0-830f-484add803b1d",
"name": "Extraer de Archivo PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ebc02b0a-0481-42e8-8043-e9bcd6c0f02e",
"name": "Extraer de CSV",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2560,
580
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8bb13f35-03c3-413a-9dcc-1526f40325d3",
"name": "Extraer de XLSX",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2560,
980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a598e49c-d9bc-4305-b917-ccc64feb4c68",
"name": "Agregar",
"type": "n8n-nodes-base.aggregate",
"position": [
2780,
740
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e1c0c059-66f5-4a1b-b76a-8db1823c25e1",
"name": "Resumir",
"type": "n8n-nodes-base.summarize",
"position": [
3000,
740
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "cb46dfca-96ce-478a-98cb-5c94fd48e104",
"name": "Extraer de RTF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
1160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9832240d-7cea-465e-b167-17fcf254f5f7",
"name": "Registrador de Errores",
"type": "n8n-nodes-base.supabase",
"position": [
1240,
1380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "01b5f966-e5b7-436e-9551-c31f6b9d4eac",
"name": "Validar Archivo",
"type": "n8n-nodes-base.if",
"position": [
580,
640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "466e1cc8-25e7-462c-b19f-467c66eb1d77",
"name": "SI Verificación de Duplicado",
"type": "n8n-nodes-base.if",
"position": [
1020,
540
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0dd9891e-7dd3-4f2d-8a2e-094ab3cecec6",
"name": "Registrar Duplicado",
"type": "n8n-nodes-base.supabase",
"position": [
1240,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7d05de17-7909-4da3-bba3-c7f512af1708",
"name": "Supabase Almacén Vectorial",
"type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
"position": [
3240,
440
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "a764be2e-110f-4320-8bae-f04a749a3ac5",
"name": "Incrustaciones OpenAI",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
3220,
660
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "0ef91d4c-7d6b-4544-9ef5-09a0bdb6dd7c",
"name": "Cargador de Datos Predeterminado",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
3340,
660
],
"parameters": {},
"typeVersion": 1
},
{
"id": "86c648a9-4b9d-4afb-9e2e-f4fff12a1ce0",
"name": "Depurar ID de Archivo",
"type": "n8n-nodes-base.set",
"position": [
1240,
740
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "392916f3-2265-4c57-abfd-37054da9e741",
"name": "Descargar Archivo",
"type": "n8n-nodes-base.googleDrive",
"position": [
2120,
740
],
"parameters": {},
"typeVersion": 3
},
{
"id": "a7367c0f-6f22-4099-ac6c-8511081b79f6",
"name": "Establecer Esquema",
"type": "n8n-nodes-base.set",
"position": [
3360,
1160
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7051505f-4da8-44c0-90c4-c522d3a2f6d3",
"name": "Metadatos de Documento de Esquema",
"type": "n8n-nodes-base.postgres",
"position": [
3600,
1160
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "6f76fa9d-d1f9-4e05-80af-ec78fed5416c",
"name": "Selector",
"type": "n8n-nodes-base.switch",
"position": [
2340,
680
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "f62efcf8-bb87-4e4e-9c73-0c86ec1c55fd",
"name": "Nota Adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
-120,
-60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "82015f8b-1456-4b04-bf38-2735e7f416f6",
"name": "Extraer de DOC",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
1360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7af0771c-bed1-4cbb-8122-01ec2d8b4664",
"name": "Slack Notificación de Duplicado",
"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": "Notificación de Error",
"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": "Eliminar Documento Antiguo",
"type": "n8n-nodes-base.supabase",
"position": [
1460,
740
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "98d0c000-5d9b-419b-aa7c-e98a9f0a90e2",
"name": "Extraer de TXT",
"type": "n8n-nodes-base.extractFromFile",
"position": [
3000,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a53ca5ed-b9f0-4f9e-bb55-017dc5ed1451",
"name": "Nota Adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1880,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a1c76c00-0bed-48f0-ad8c-f686d5186222",
"name": "Nota Adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1620,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "71f8678a-ef8b-40ef-a3ef-3ee90afe65dc",
"name": "Agente de IA RAG",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-880,
700
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "7c7ebb71-1699-46a5-a756-cf2589815dc8",
"name": "OpenAI Modelo de Chat",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-1460,
1180
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "510482ba-030b-4777-9740-bf8993dce021",
"name": "Memoria de Chat Postgres",
"type": "@n8n/n8n-nodes-langchain.memoryPostgresChat",
"position": [
-1280,
1180
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "223791e6-5148-47cd-aab6-ca9cb20b7017",
"name": "Listar Documentos",
"type": "n8n-nodes-base.postgresTool",
"position": [
-1060,
1180
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "25cc4ca1-4910-4ae7-a755-c5611946c325",
"name": "Consultar Filas de Documento",
"type": "n8n-nodes-base.postgresTool",
"position": [
-620,
1180
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "194c1ee8-1c21-4a1d-b8d2-9991dc8133fd",
"name": "Separador de Texto por Caracteres",
"type": "@n8n/n8n-nodes-langchain.textSplitterCharacterTextSplitter",
"position": [
3440,
860
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f311ab63-88fa-413a-8ba9-aa866e1fb5f0",
"name": "Insertar Filas de Tabla",
"type": "n8n-nodes-base.postgres",
"position": [
2780,
940
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "529e05ca-0494-4eb3-b0f4-275ba252f646",
"name": "Eliminar Filas de Datos Antiguas",
"type": "n8n-nodes-base.supabase",
"position": [
1680,
740
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "d1702791-fe65-4068-982b-8b378f9c2e0a",
"name": "Establecer Tipo de Error",
"type": "n8n-nodes-base.set",
"position": [
1020,
1200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "23a05be3-2b40-400b-b8d4-21ee6db78ac4",
"name": "Al recibir mensaje 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": "Editar Campos2",
"type": "n8n-nodes-base.set",
"position": [
-1180,
700
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2325e26f-6237-4128-bead-17e0a9ccb50d",
"name": "Supabase Almacén Vectorial2",
"type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
"position": [
-460,
840
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "1289b037-7bc9-4d13-9516-328f1f781c14",
"name": "Incrustaciones OpenAI2",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
-240,
1060
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "3d15f7db-e7b7-4bb7-a5f7-9962f3a81051",
"name": "Obtener Texto Completo del Documento - Obtener Contenidos del Archivo",
"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
}
]
]
}
}
}¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Soporte, Inteligencia Artificial
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Immanuel
@spectrabitCompartir este flujo de trabajo