Help me to build a invoice extractor

Help me Build my Workflow
1

Hello everybody,

I wanted to create a invoice processing tool through n8n. My process will be

  1. Upload invoice from google drive
  2. File Conversion from Excel
  3. Invoice process as my desired data like Purchase Order, Price, product name, model, Manufacturer etc.
  4. Output the information in google sheet.

But I am not allowed to use any LLM model.

How could I build this properly?

TIA.

2

Google Drive node: Download the invoice file.

Extract from file node: Read and parse the Excel file.

Set/Function node: Map and process the required fields.

Google Sheets node: Append the processed data to your sheet.

This I think will go with CSV or excel… but for advanced parsing like PDF, nothing on my mind yet…

1 « J'aime »
3

Adding to what Parintele_Damaskin said, for PDF parsing and stuff, you can try CustomJS PDF generator node

1 « J'aime »
4

Un cas d’usage n8n pratique est : télécharger un PDF → extraire/OCR → normaliser les éléments de ligne → ajouter à un CSV ou Sheets. La clé est de séparer les champs d’en-tête des lignes du tableau et de conserver une branche d’examen manuel pour les fichiers à faible confiance, car les tableaux de factures sont généralement là où les automatisations échouent.