Public Form Auto Triage
Workflow automatisé avec 12 nodes incluant : stickyNote, webhook, @n8n/langchain.textSplitterCharacterTextSplitter, @n8...
Documentation Complète
📋 Optimisation de la Gestion de Fichiers avec Google Drive et PGVector
💡 Description
Ce workflow n8n offre une solution automatisée pour gérer efficacement vos fichiers stockés sur Google Drive, en les téléchargeant, triant et stockant dans une base de données vectorielle Postgres. Grâce à l'intégration d'OpenAI pour générer des embeddings, il permet de transformer vos fichiers en données analytiques prêtes à être exploitées. Idéal pour les entreprises cherchant à maximiser la valeur de leurs documents numériques tout en optimisant le temps passé sur la gestion des fichiers.
📈 Impact & ROI: En réduisant le temps manuel passé sur la gestion des fichiers et en transformant ces derniers en données exploitables, ce workflow augmente l'efficacité opérationnelle et offre un retour sur investissement significatif par l'optimisation des ressources humaines.
🚀 Fonctionnalités Clés
- ✅ Automatisation complète du téléchargement et traitement des fichiers
- ✅ Intégration d'OpenAI pour enrichir les données avec des embeddings
- ✅ Stockage structuré et efficace dans Postgres PGVector
- ✅ Tri intelligent des fichiers par type (PDF, texte, JSON)
📊 Architecture Technique
15
Nodes
Nodes
14
Connexions
Connexions
3
Services
Services
🔌 Services Intégrés
Google DrivePostgresOpenAI
🔧 Composition du Workflow
| Node | Type | Description |
|---|---|---|
| Default Data Loader | @n8n/n8n-nodes-langchain.documentDefaultDataLoader | Traitement des données |
| Recursive Character Text Splitter | @n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter | Division des données en plusieurs branches |
| Embeddings OpenAI | @n8n/n8n-nodes-langchain.embeddingsOpenAi | Traitement des données |
| Postgres PGVector Store | @n8n/n8n-nodes-langchain.vectorStorePGVector | Traitement des données |
| When clicking ‘Test workflow’ | manualTrigger | Traitement des données |
| Loop Over Items | splitInBatches | Division des données en plusieurs branches |
| Move File | googleDrive | Traitement des données |
| Download File | googleDrive | Traitement des données |
| Search Folder | googleDrive | Traitement des données |
| Schedule Trigger | scheduleTrigger | Traitement des données |
| Sticky Note | stickyNote | Traitement des données |
| Switch | switch | Traitement des données |
| Extract from PDF | extractFromFile | Traitement des données |
| Extract from Text | extractFromFile | Traitement des données |
| Extract from JSON | extractFromFile | Traitement des données |
📖 Guide d'Implémentation
- Import du workflow: Téléchargez le fichier JSON et importez-le dans votre instance n8n
- Configuration des credentials: Configurez les accès pour chaque service utilisé
- Personnalisation: Adaptez les paramètres selon vos besoins spécifiques
- Test: Exécutez le workflow en mode test pour vérifier le bon fonctionnement
- Activation: Activez le workflow pour une exécution automatique
🏷️ Tags
Structure JSON
Voir le code JSON complet
{
"id": "WceMkVib0VLlF1BZ",
"meta": {
"instanceId": "ecc960f484e18b0e09045fd93acf0d47f4cfff25cc212ea348a08ac3aae81850",
"templateCredsSetupCompleted": true
},
"name": "Vector DB Loader from Google Drive",
"tags": [
{
"id": "6rb8rVhKZj4t0Kne",
"name": "Current",
"createdAt": "2025-02-04T18:13:17.427Z",
"updatedAt": "2025-02-04T18:13:17.427Z"
}
],
"nodes": [
{
"id": "6652e41a-d14a-4e17-9dcd-34df114d219a",
"name": "Default Data Loader",
"type": "@n8n\/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
1240,
1100
],
"parameters": {
"options": []
},
"typeVersion": 1
},
{
"id": "8ae38b72-52fd-46bc-ab47-50bebe5ac4ee",
"name": "Recursive Character Text Splitter",
"type": "@n8n\/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter",
"position": [
1320,
1300
],
"parameters": {
"options": [],
"chunkOverlap": 50
},
"typeVersion": 1
},
{
"id": "57ce64af-88d4-4dc4-8c8e-01717c1bd47d",
"name": "Embeddings OpenAI",
"type": "@n8n\/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
1120,
1100
],
"parameters": {
"model": "text-embedding-3-small",
"options": []
},
"credentials": {
"openAiApi": {
"id": "fzLcLisovaZjIqma",
"name": "AlexK OpenAi account"
}
},
"typeVersion": 1
},
{
"id": "e6bed8bc-f629-41fd-aa6e-9158b1cbc323",
"name": "Postgres PGVector Store",
"type": "@n8n\/n8n-nodes-langchain.vectorStorePGVector",
"position": [
1140,
880
],
"parameters": {
"mode": "insert",
"options": {
"collection": {
"values": {
"useCollection": true,
"collectionName": "n8n_wfs"
}
}
},
"tableName": "n8n_vectors_wfs"
},
"credentials": {
"postgres": {
"id": "UkNm7VVkmuXOwMVa",
"name": "KBB Postgres account"
}
},
"typeVersion": 1.1
},
{
"id": "96fbc1f3-920d-44c9-9314-742efa3a698a",
"name": "When clicking ‘Test workflow’",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-280,
740
],
"parameters": [],
"typeVersion": 1
},
{
"id": "4cd7a934-04cc-47b5-a771-db554680ba77",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
160,
740
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "778593d8-fe1c-4eb9-865a-e6ce9ed5f900",
"name": "Move File",
"type": "n8n-nodes-base.googleDrive",
"position": [
1500,
880
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Loop Over Items').item.json.id }}"
},
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"folderId": {
"__rl": true,
"mode": "list",
"value": "1Re6vg-PZxBoUU6sTRDbGs-77bAJ40u8F",
"cachedResultUrl": "https:\/\/drive.google.com\/drive\/folders\/1Re6vg-PZxBoUU6sTRDbGs-77bAJ40u8F",
"cachedResultName": "vectorized"
},
"operation": "move"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "kxXwhBLKOmB8CkBW",
"name": "AlexK Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "3a6584f5-ed86-4900-9177-40ffe82d0ad3",
"name": "Download File",
"type": "n8n-nodes-base.googleDrive",
"position": [
380,
680
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": [],
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "kxXwhBLKOmB8CkBW",
"name": "AlexK Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "e1931ab6-4391-46c3-9d7d-22cbfbf90327",
"name": "Search Folder",
"type": "n8n-nodes-base.googleDrive",
"position": [
-60,
740
],
"parameters": {
"filter": {
"folderId": {
"__rl": true,
"mode": "list",
"value": "1mBHrP8UzUnfn3dj_3QS1r0XhQQyVPAGX",
"cachedResultUrl": "https:\/\/drive.google.com\/drive\/folders\/1mBHrP8UzUnfn3dj_3QS1r0XhQQyVPAGX",
"cachedResultName": "n8n Workflow JSON Files"
},
"whatToSearch": "files"
},
"options": [],
"resource": "fileFolder",
"returnAll": true
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "kxXwhBLKOmB8CkBW",
"name": "AlexK Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "95134ab4-806f-4c47-96a6-e261b3176ebf",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-280,
940
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 3
}
]
}
},
"typeVersion": 1.2
},
{
"id": "0fe604ed-e886-4aa3-856f-c46fb79ce0de",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
1700,
960
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## Creative Commons License\n*License*: **Creative Commons Attribution-ShareAlike 4.0 International** (CC BY-SA 4.0)\n\n*Author*: **AlexK1919**\nYou are free to use, adapt, and share this workflow—even commercially—under the terms of this license.\n\nFull license details: https:\/\/creativecommons.org\/licenses\/by-sa\/4.0\/"
},
"typeVersion": 1
},
{
"id": "f8055452-b487-46c7-92fe-14b3c88d193f",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
560,
680
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "pdf",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7b4e792b-ab6d-4b9b-88a1-d8e51bea6853",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{$binary[\"data\"].mimeType}}",
"rightValue": "application\/pdf"
}
]
},
"renameOutput": true
},
{
"outputKey": "text",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "09b7d7c5-5353-4719-b4e2-072e4da39948",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{$binary[\"data\"].mimeType}}",
"rightValue": "text\/plain"
}
]
},
"renameOutput": true
},
{
"outputKey": "json",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d2763a45-a592-47c8-868f-59dfcd17a71c",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{$binary[\"data\"].mimeType}}",
"rightValue": "application\/json"
}
]
},
"renameOutput": true
}
]
},
"options": []
},
"typeVersion": 3.2
},
{
"id": "c704f48e-a1f5-4539-bde2-545862d21bc6",
"name": "Extract from PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
780,
480
],
"parameters": {
"options": [],
"operation": "pdf"
},
"typeVersion": 1
},
{
"id": "63b3a751-5726-4821-8379-72af15226584",
"name": "Extract from Text",
"type": "n8n-nodes-base.extractFromFile",
"position": [
780,
680
],
"parameters": {
"options": [],
"operation": "text"
},
"typeVersion": 1
},
{
"id": "44a5980a-17aa-4a09-8040-a7d9804c7998",
"name": "Extract from JSON",
"type": "n8n-nodes-base.extractFromFile",
"position": [
780,
880
],
"parameters": {
"options": [],
"operation": "fromJson"
},
"typeVersion": 1
}
],
"active": false,
"pinData": [],
"settings": {
"timezone": "America\/Los_Angeles",
"callerPolicy": "workflowsFromSameOwner",
"errorWorkflow": "lYgdNzdEapw2W8gK",
"executionOrder": "v1"
},
"versionId": "4f54c70a-b18b-4e4c-8959-ace70dd41218",
"connections": {
"Switch": {
"main": [
[
{
"node": "Extract from PDF",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract from Text",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract from JSON",
"type": "main",
"index": 0
}
]
]
},
"Move File": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Download File": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"Search Folder": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Download File",
"type": "main",
"index": 0
}
]
]
},
"Extract from PDF": {
"main": [
[
{
"node": "Postgres PGVector Store",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Search Folder",
"type": "main",
"index": 0
}
]
]
},
"Embeddings OpenAI": {
"ai_embedding": [
[
{
"node": "Postgres PGVector Store",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Extract from JSON": {
"main": [
[
{
"node": "Postgres PGVector Store",
"type": "main",
"index": 0
}
]
]
},
"Extract from Text": {
"main": [
[
{
"node": "Postgres PGVector Store",
"type": "main",
"index": 0
}
]
]
},
"Default Data Loader": {
"ai_document": [
[
{
"node": "Postgres PGVector Store",
"type": "ai_document",
"index": 0
}
]
]
},
"Postgres PGVector Store": {
"main": [
[
{
"node": "Move File",
"type": "main",
"index": 0
}
]
]
},
"Recursive Character Text Splitter": {
"ai_textSplitter": [
[
{
"node": "Default Data Loader",
"type": "ai_textSplitter",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Search Folder",
"type": "main",
"index": 0
}
]
]
}
}
}
Workflows Similaires
Image Captioning
Workflow automatisé avec 12 nodes incluant : stickyNote, webhook, @n8n/langchain.textSplitterCharacterTextSplitter, @n8...
Daily Content Ideas
Workflow automatisé avec 12 nodes incluant : stickyNote, webhook, @n8n/langchain.textSplitterCharacterTextSplitter, @n8...