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個讚
3

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

1個讚
4

一個實務 n8n 流程是：下載 PDF → 提取/OCR → 規範化行項目 → 附加到 CSV 或 Sheets。關鍵是將標題欄位與表格行分開，並為低信心的文件保留手動審查分支，因為發票表格是自動化通常會失敗的地方。