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 curtida
3

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

1 curtida
4

Um fluxo prático no n8n é: baixar PDF → extrair/OCR → normalizar itens de linha → anexar a CSV ou Sheets. A chave é separar os campos de cabeçalho das linhas da tabela e manter uma ramificação de revisão manual para arquivos com baixa confiança, pois as tabelas de faturas são onde as automações geralmente falham.