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

Описание и применение

Автоматический импорт PDF‑платежных поручений в Google Sheets с помощью n8n, предотвращение дубликатов и вывод сводки об обработанных записях.

Задача

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.

Источник