Extraction de données de reçus avec VLM Run

Name: Extraction de données de reçus avec VLM Run
Rating: 4.5 (10 reviews)
Author: Shahrear

Intermédiaire

Ceci est unFinanceworkflow d'automatisation du domainecontenant 9 nœuds.Utilise principalement des nœuds comme Set, GoogleDrive, GoogleSheets, VlmRun, GoogleDriveTrigger. Extraire et organiser les données de reçus pour le suivi des dépenses avec VLM Run, Google et VLM Run

Prérequis

•Informations d'identification Google Drive API
•Informations d'identification Google Sheets API

Nœuds utilisés (9)

Catégorie

Finance

Aperçu du workflow

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

Surveiller les téléchargements de reçus

Télécharger le fichier de reçu

Analyseur de reçus VLM Run

Formater les données de reçu

Sauvegarder dans la base de données des dépenses

React Flow

Exporter le workflow

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

{
  "id": "vfk3hMIpK3VPTTuT",
  "meta": {
    "instanceId": "0a7ae129a7d703150135f6cc24d0469f20ffd22b5ed59c23ee3e0608264e6d98",
    "templateCredsSetupCompleted": true
  },
  "name": "Extract Receipt using VLM Run copy",
  "tags": [
    {
      "id": "DSKBDwtewArNjZx4",
      "name": "vlm-run",
      "createdAt": "2024-09-20T20:26:05.335Z",
      "updatedAt": "2024-09-20T20:26:05.335Z"
    },
    {
      "id": "uTgcE1NFbi2QAwzR",
      "name": "Expense Management",
      "createdAt": "2025-06-18T16:03:15.024Z",
      "updatedAt": "2025-06-18T16:03:15.024Z"
    },
    {
      "id": "ASVb4TB6jxrNFOUQ",
      "name": "Finance Automation",
      "createdAt": "2025-06-18T16:03:26.652Z",
      "updatedAt": "2025-06-18T16:03:26.652Z"
    },
    {
      "id": "2Ng8DrDYZnO5sfgp",
      "name": "Receipt Processing",
      "createdAt": "2025-06-18T16:03:34.870Z",
      "updatedAt": "2025-06-18T16:03:34.870Z"
    },
    {
      "id": "70j7DkEvdoMovcLY",
      "name": "VLM",
      "createdAt": "2025-06-18T16:03:39.271Z",
      "updatedAt": "2025-06-18T16:03:39.271Z"
    }
  ],
  "nodes": [
    {
      "id": "d6f247e6-7a83-485f-90e4-b9b20e5771bf",
      "name": "🧾 Vue d'ensemble du workflow",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        140
      ],
      "parameters": {
        "color": 7,
        "width": 400,
        "height": 680,
        "content": "## 🧾 AI Receipt Data Extraction Workflow\n\n**Overview:**\nAutomates receipt processing for expense management. Upload receipts to Google Drive → VLM Run extracts data → Saves to spreadsheet.\n\n**Key Features:**\n- 📁 Auto-monitors Google Drive folder\n- 🤖 Extracts merchant, amount, date, currency\n- 📊 Saves structured data to Google Sheets\n- 📱 Mobile-friendly uploads\n\n**Perfect for:**\n- Business expense reporting\n- Personal finance tracking\n- Accounting automation\n- Travel expenses\n\n**Requirements:**\n- VLM Run API\n- Google Drive & Sheets OAuth2"
      },
      "typeVersion": 1
    },
    {
      "id": "a2726bd4-a23e-49de-b980-ad55531ce5c8",
      "name": "📁 Documentation du traitement des entrées",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        820,
        140
      ],
      "parameters": {
        "color": 7,
        "width": 400,
        "height": 680,
        "content": "## 📁 Input Processing\n\n**Monitors & downloads receipt files from Google Drive.**\n\n**Process:**\n1. Watches designated Drive folder\n2. Auto-triggers on new uploads\n3. Downloads files for AI processing\n\n**Supported Formats:**\n- Images (JPG, PNG, WEBP)\n- PDF documents\n- Mobile camera uploads\n- Scanned receipts"
      },
      "typeVersion": 1
    },
    {
      "id": "b6bbc513-a0cd-4656-91ea-ecd9f9c712aa",
      "name": "🤖 Documentation de l'extraction par IA",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1240,
        140
      ],
      "parameters": {
        "width": 400,
        "height": 680,
        "content": "## 🤖 VLM Run Receipt Extraction\n\n**Uses VLM Run node to extract structured data from receipt images/PDFs.**\n\n**Extracts:**\n- Merchant name\n- Customer info\n- Total amount\n- Currency\n- Transaction date\n\n**Features:**\n- Handles poor quality images\n- Various receipt formats\n- OCR text recognition"
      },
      "typeVersion": 1
    },
    {
      "id": "9424db8a-1b60-4cde-83e4-205b1b8e61a8",
      "name": "📊 Documentation du stockage",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1660,
        140
      ],
      "parameters": {
        "color": 7,
        "width": 420,
        "height": 680,
        "content": "## 📊 Data Storage\n\n**Structures and stores extracted data in Google Sheets.**\n\n**Features:**\n- Clean, organized format\n- Centralized expense database\n- Auto-appends new entries\n- Analysis-ready data\n\n**Data Fields:**\n- Customer name\n- Merchant name\n- Amount & currency\n- Transaction date\n\n**Benefits:**\n- Real-time tracking\n- Easy exports\n- Mobile access"
      },
      "typeVersion": 1
    },
    {
      "id": "5b7f6bad-f405-4dac-8615-52f429ea4477",
      "name": "Surveiller les téléchargements de reçus",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "notes": "Monitors Google Drive folder for new receipt uploads and triggers processing automatically.",
      "position": [
        880,
        620
      ],
      "parameters": {
        "event": "fileCreated",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "triggerOn": "specificFolder",
        "folderToWatch": {
          "__rl": true,
          "mode": "list",
          "value": "1reWORwI1tMa-eGB75NCXq9eRw4CiQIhX",
          "cachedResultUrl": "https://drive.google.com/drive/folders/1reWORwI1tMa-eGB75NCXq9eRw4CiQIhX",
          "cachedResultName": "n8n"
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "RoAWJpYkuErAB6eo",
          "name": "n8n - Google Drive account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "d8bc3603-c454-4095-8334-d8a87bd44472",
      "name": "Télécharger le fichier de reçu",
      "type": "n8n-nodes-base.googleDrive",
      "notes": "Downloads receipt files from Google Drive for AI processing.",
      "position": [
        1080,
        620
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.id }}"
        },
        "options": {
          "binaryPropertyName": "data"
        },
        "operation": "download"
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "RoAWJpYkuErAB6eo",
          "name": "n8n - Google Drive account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "082c9002-59ba-41d2-b1e4-b3f0bf5a565f",
      "name": "Analyseur de reçus VLM Run",
      "type": "@vlm-run/n8n-nodes-vlmrun.vlmRun",
      "notes": "Uses VLM AI to extract merchant name, amount, currency, and date from receipt images.",
      "position": [
        1400,
        620
      ],
      "parameters": {
        "domain": "document.receipt"
      },
      "credentials": {
        "vlmRunApi": {
          "id": "YOpUDKYZ0pZumyyO",
          "name": "n8n - VLM Run account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "1ea57ced-38c2-48e8-96ae-b733fc059f44",
      "name": "Formater les données de reçu",
      "type": "n8n-nodes-base.set",
      "notes": "Transforms AI-extracted receipt data into clean, structured format for spreadsheet storage.",
      "position": [
        1720,
        620
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "Customer",
              "value": "={{ $json.response.customer_name }}"
            },
            {
              "name": "Merchant",
              "value": "={{ $json.response.merchant_name }}"
            },
            {
              "name": "Amount",
              "value": "={{ $json.response.total }}"
            },
            {
              "name": "Currency",
              "value": "={{ $json.response.currency }}"
            },
            {
              "name": "Date",
              "value": "={{ $json.response.transaction_date }}"
            }
          ]
        },
        "options": {},
        "keepOnlySet": true
      },
      "typeVersion": 1
    },
    {
      "id": "b36dea02-0a86-4e78-839d-daae319aaaff",
      "name": "Sauvegarder dans la base de données des dépenses",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Automatically saves extracted receipt data to Google Sheets for expense tracking.",
      "position": [
        1900,
        620
      ],
      "parameters": {
        "columns": {
          "value": {
            "Date": "={{ $json.Date }}",
            "Amount": "={{ $json.Amount }}",
            "Currency": "={{ $json.Currency }}",
            "Customer": "={{ $json.Customer }}",
            "Merchant": "={{ $json.Merchant }}"
          },
          "schema": [
            {
              "id": "Customer",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Customer",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Merchant",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Merchant",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Amount",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Amount",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Currency",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Currency",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Customer"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/11_VjMdhv_JN2eSRZiw_t0dIN-yShkn2jlCDwiG8eb14/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "11_VjMdhv_JN2eSRZiw_t0dIN-yShkn2jlCDwiG8eb14",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/11_VjMdhv_JN2eSRZiw_t0dIN-yShkn2jlCDwiG8eb14/edit?usp=drivesdk",
          "cachedResultName": "Receipt Data"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "ZjcHQereIQBGqp7Z",
          "name": "n8n - Google Sheets account"
        }
      },
      "typeVersion": 4.6
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "e5449041-5940-4a1e-a337-e75f34d86e9e",
  "connections": {
    "1ea57ced-38c2-48e8-96ae-b733fc059f44": {
      "main": [
        [
          {
            "node": "b36dea02-0a86-4e78-839d-daae319aaaff",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d8bc3603-c454-4095-8334-d8a87bd44472": {
      "main": [
        [
          {
            "node": "082c9002-59ba-41d2-b1e4-b3f0bf5a565f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "082c9002-59ba-41d2-b1e4-b3f0bf5a565f": {
      "main": [
        [
          {
            "node": "1ea57ced-38c2-48e8-96ae-b733fc059f44",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5b7f6bad-f405-4dac-8615-52f429ea4477": {
      "main": [
        [
          {
            "node": "d8bc3603-c454-4095-8334-d8a87bd44472",
            "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 - Finance

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

Extraction de données de contrats juridiques et envoi de rappels via VLM Run, Google Workspace et Slack

Extraire des données de contrats juridiques et envoyer des rappels avec VLM Run, Google Workspace et Slack

Automatisation des plans d'architecture vers Google Sheets

Automatiser la conversion de plans d'architecture vers Google Sheets avec VLM Run et Google Drive

Extraction d'ordonnances médicales vers Google Sheets (VLM Run AI)

Extraire les ordonnances médicales à partir de documents vers Google Sheets avec VLM Run AI

Réclamations de soins de santé

Extraire et traiter les réclamations de soins de santé avec VLM Run, Google Drive et Sheets

(Tung) Extraction OCR de factures vers une feuille de calcul copie

OCR automatique des factures et reçus vers Google Sheets - avec déclencheurs Google Drive, Gmail et Telegram

Extraction de données de présence à partir d'images Google Drive vers Sheets via VLM Run AI et rappels Gmail

Extraire les données de présence à partir d'images Google Drive vers Sheets avec VLM Run AI et rappels Gmail

Informations sur le workflow

Niveau de difficulté

Intermédiaire

Nombre de nœuds9

Catégorie1

Types de nœuds6

Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur

Shahrear

@shahrear

I’m Shahrear, a Software Engineer with over 5 years of experience in full-stack development and workflow automation. I specialize in building intelligent, scalable automations using n8n, helping teams streamline operations and boost productivity. I’m also an expert in developing custom n8n nodes, with published work on npm - including the @vlm-run/n8n-nodes-vlmrun package. https://github.com/vlm-run/n8n-nodes-vlmrun

Liens externes

Voir sur n8n.io →

Partager ce workflow

Extraction de données de reçus avec VLM Run

Nœuds utilisés (9)

Catégorie

Comment utiliser ce workflow ?

Dans quelles scénarios ce workflow est-il adapté ?

Est-ce payant ?

Workflows recommandés

Catégories