{"product_id":"extract-po-pdfs-to-google-sheets-edi-850-with-n8n","title":"Extract PO PDFs to Google Sheets + EDI 850 with n8n","description":"\u003ch3\u003eTurn PO PDFs into structured Google Sheets—and optionally EDI 850—automatically with n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow collects one or more purchase order (PO) PDFs from an n8n Form, extracts PO header + line-item data with \u003cstrong\u003eeasybits Extractor\u003c\/strong\u003e, appends clean results into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with duplicate detection, and can generate an \u003cstrong\u003eEDI 850\u003c\/strong\u003e file per new PO (saved to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives PO PDFs via n8n Form\u003c\/strong\u003e, including a toggle to enable\/disable EDI 850 generation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads existing Google Sheets rows\u003c\/strong\u003e to build a list of already-processed PO numbers for deduplication.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits and processes uploads sequentially\u003c\/strong\u003e into one PDF per item for reliable extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts PO data using easybits Extractor\u003c\/strong\u003e, including PO header fields and the full articles table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips duplicates\u003c\/strong\u003e: if the extracted PO number already exists in Google Sheets, those documents are not re-added (duplicates are tracked for the summary).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlattens line items for reporting\u003c\/strong\u003e: writes one row per article line item to Google Sheets, calculating totals and flagging missing fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptionally generates EDI 850\u003c\/strong\u003e: reshapes extracted PO data into a canonical object, runs a sub-workflow to create an \u003ccode\u003e.edi\u003c\/code\u003e file, and uploads it to Google Drive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eShows a completion summary\u003c\/strong\u003e with clean extractions, duplicates skipped, and any missing fields detected per document.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCentralize PO intake: upload supplier PO PDFs and keep procurement data synchronized in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003ePrevent duplicate processing across team submissions using PO-number deduplication.\u003c\/li\u003e\n  \u003cli\u003eGenerate EDI 850 documents only for newly received POs and store them in Google Drive.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations\/logic: \u003cstrong\u003eeasybits Extractor\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (append + dedupe), \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e (upload \u003ccode\u003e.edi\u003c\/code\u003e files)\u003c\/li\u003e\n  \u003cli\u003en8n nodes mentioned: \u003cstrong\u003eform\u003c\/strong\u003e, \u003cstrong\u003eform trigger\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003egoogle drive\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e Create and connect an easybits Extractor API credential at \u003ca href=\"https:\/\/easybits.tech\/\" target=\"_blank\" rel=\"noopener\"\u003ehttps:\/\/easybits.tech\/\u003c\/a\u003e and configure the extractor fields to return PO header values and the articles array.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45895367688371,"sku":"N8N-18674","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/pNVkE9aPl-KUCV4o8naai_GNcDrjaX.png?v=1787648592","url":"https:\/\/buyflowscripts.com\/products\/extract-po-pdfs-to-google-sheets-edi-850-with-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}