Chargeur de base de données vectorielle Google Drive

Name: Chargeur de base de données vectorielle Google Drive
Rating: 4.5 (10 reviews)
Author: Alex Kim

Intermédiaire

Ceci est unBuilding Blocks, AI, IT Opsworkflow d'automatisation du domainecontenant 15 nœuds.Utilise principalement des nœuds comme Switch, GoogleDrive, ManualTrigger, SplitInBatches, ExtractFromFile, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. 📥 Conversion de documents Google Drive en embeddings vectoriels

Prérequis

•Informations d'identification Google Drive API
•Clé API OpenAI

Nœuds utilisés (15)

DocumentDefaultDataLoader

TextSplitterRecursiveCharacterTextSplitter

Catégorie

Blocs de construction

Intelligence Artificielle

Opérations IT

Aperçu du workflow

Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement

Chargeur de données par défaut

Séparateur de texte récursif par caractères

Embeddings OpenAI

Postgres PGVector Store

Lors du clic sur 'Tester le workflow'

Boucle sur les éléments

Déplacer le fichier

Télécharger le fichier

Rechercher le dossier

Déclencheur planifié

Commutateur

Extraire d'un PDF

Extraire d'un texte

Extraire de JSON

React Flow

Exporter le workflow

Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow

{
  "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": "Chargeur de données par défaut",
      "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "position": [
        1240,
        1100
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "8ae38b72-52fd-46bc-ab47-50bebe5ac4ee",
      "name": "Séparateur de texte récursif par caractères",
      "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": "Lors du clic sur 'Tester le workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -280,
        740
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4cd7a934-04cc-47b5-a771-db554680ba77",
      "name": "Boucle sur les éléments",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        160,
        740
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "778593d8-fe1c-4eb9-865a-e6ce9ed5f900",
      "name": "Déplacer le fichier",
      "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": "Télécharger le fichier",
      "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": "Rechercher le dossier",
      "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": "Déclencheur planifié",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -280,
        940
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 3
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "0fe604ed-e886-4aa3-856f-c46fb79ce0de",
      "name": "Note autocollante",
      "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": "Commutateur",
      "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": "Extraire d'un PDF",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        780,
        480
      ],
      "parameters": {
        "options": {},
        "operation": "pdf"
      },
      "typeVersion": 1
    },
    {
      "id": "63b3a751-5726-4821-8379-72af15226584",
      "name": "Extraire d'un texte",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        780,
        680
      ],
      "parameters": {
        "options": {},
        "operation": "text"
      },
      "typeVersion": 1
    },
    {
      "id": "44a5980a-17aa-4a09-8040-a7d9804c7998",
      "name": "Extraire de 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": {
    "f8055452-b487-46c7-92fe-14b3c88d193f": {
      "main": [
        [
          {
            "node": "c704f48e-a1f5-4539-bde2-545862d21bc6",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "63b3a751-5726-4821-8379-72af15226584",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "44a5980a-17aa-4a09-8040-a7d9804c7998",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "778593d8-fe1c-4eb9-865a-e6ce9ed5f900": {
      "main": [
        [
          {
            "node": "4cd7a934-04cc-47b5-a771-db554680ba77",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3a6584f5-ed86-4900-9177-40ffe82d0ad3": {
      "main": [
        [
          {
            "node": "f8055452-b487-46c7-92fe-14b3c88d193f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e1931ab6-4391-46c3-9d7d-22cbfbf90327": {
      "main": [
        [
          {
            "node": "4cd7a934-04cc-47b5-a771-db554680ba77",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4cd7a934-04cc-47b5-a771-db554680ba77": {
      "main": [
        [],
        [
          {
            "node": "3a6584f5-ed86-4900-9177-40ffe82d0ad3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c704f48e-a1f5-4539-bde2-545862d21bc6": {
      "main": [
        [
          {
            "node": "e6bed8bc-f629-41fd-aa6e-9158b1cbc323",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "95134ab4-806f-4c47-96a6-e261b3176ebf": {
      "main": [
        [
          {
            "node": "e1931ab6-4391-46c3-9d7d-22cbfbf90327",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "57ce64af-88d4-4dc4-8c8e-01717c1bd47d": {
      "ai_embedding": [
        [
          {
            "node": "e6bed8bc-f629-41fd-aa6e-9158b1cbc323",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "44a5980a-17aa-4a09-8040-a7d9804c7998": {
      "main": [
        [
          {
            "node": "e6bed8bc-f629-41fd-aa6e-9158b1cbc323",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "63b3a751-5726-4821-8379-72af15226584": {
      "main": [
        [
          {
            "node": "e6bed8bc-f629-41fd-aa6e-9158b1cbc323",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6652e41a-d14a-4e17-9dcd-34df114d219a": {
      "ai_document": [
        [
          {
            "node": "e6bed8bc-f629-41fd-aa6e-9158b1cbc323",
            "type": "ai_document",
            "index": 0
          }
        ]
      ]
    },
    "e6bed8bc-f629-41fd-aa6e-9158b1cbc323": {
      "main": [
        [
          {
            "node": "778593d8-fe1c-4eb9-865a-e6ce9ed5f900",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8ae38b72-52fd-46bc-ab47-50bebe5ac4ee": {
      "ai_textSplitter": [
        [
          {
            "node": "6652e41a-d14a-4e17-9dcd-34df114d219a",
            "type": "ai_textSplitter",
            "index": 0
          }
        ]
      ]
    },
    "96fbc1f3-920d-44c9-9314-742efa3a698a": {
      "main": [
        [
          {
            "node": "e1931ab6-4391-46c3-9d7d-22cbfbf90327",
            "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 - Blocs de construction, Intelligence Artificielle, Opérations IT

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.