Extract purchase orders from PDFs with easybits, Google Sheets, and Google Drive
UnknownWhat this workflow does
This workflow has 15 nodes and runs when someone submits an n8n form (“Purchase Order Intake”). Along the way it connects Google Sheets, Google Drive and Extractor (community).
How it runs
Trigger: When someone submits an n8n form (“Purchase Order Intake”).
- Read: Existing POs (Google Sheets): uses Google Sheets
- Prepare: Split PDFs (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Build: Flag Summary (Code): runs custom JavaScript code
- Extract: PO Data (Easybits Extractor): uses Easybits Extractor
- Form: Completion (n8n Form): shows the next form page
- Check: Duplicate PO (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- Build: PO Object (Code): runs custom JavaScript code
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @easybits/n8n-nodes-extractor is verified or supports 3.0 (used in Extract: PO Data).
Nodes used (9)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Easybits Extractor
@easybits/n8n-nodes-extractor.easybitsExtractor - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - n8n Form
n8n-nodes-base.form - If
n8n-nodes-base.if - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - Google Drive
n8n-nodes-base.googleDrive
From the author
Quick overview This workflow collects purchase order PDFs via an n8n Form, extracts header and line-item data using easybits Extractor, appends the results to Google Sheets with duplicate detection, and optionally generates an EDI 850 file per new PO and…