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 „Gefällt mir“
3

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

1 „Gefällt mir“
4

Ein praktischer n8n-Workflow ist: PDF herunterladen → extrahieren/OCR → Zeilenelemente normalisieren → an CSV oder Sheets anhängen. Der Schlüssel ist, Kopfzeilenfelder von Tabellenzeilen zu trennen und einen manuellen Überprüfungszweig für Dateien mit niedriger Konfidenz zu behalten, da Rechnungstabellen der Ort sind, an dem Automatisierungen normalerweise scheitern.