Purchase Order Extraction with n8n: Free PDF to Google Sheets Automation [Workflow Included]

说明与用途

使用 n8n 将 PDF 采购订单自动导入 Google 表格，防止重复并提供处理记录摘要。

问题

Manual processing of purchase order PDFs was time‑consuming and error‑prone.

结果

The workflow processes batches of PO PDFs, prevents duplicate entries, and provides a clear summary of processed records, enabling reliable automation without manual review.

工作流

• Upload one or many PO PDFs through a form
• Extract each PDF into structured data
• Check each PO number against the Google Sheet to avoid duplicates
• Write new line items to the Google Sheet
• Display a completion screen summarizing added, skipped, and failed records

证据

you upload one or many PO PDFs through a form, and it extracts each into a Google Sheet, one row per line item, with the source document name on every row.

来源

before writing it checks each PO number against the sheet so nothing gets entered twice.

来源

The completion screen then tells you what was added, what it skipped as already processed (with the PO number), and whether any extraction looked off.

来源