{"product_id":"n8n-workflow-verify-shipment-docs-in-onedrive-vs-sharepoint","title":"n8n Workflow: Verify Shipment Docs in OneDrive vs SharePoint","description":"\u003ch3\u003eVerify shipment document packs in OneDrive against SharePoint instructions—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks each shipment’s OneDrive document pack (including bill of lading, phytosanitary, and origin certificates) against the required shipping instructions stored in a SharePoint “Shipments” list. It verifies presence using fixed rules, extracts specified field values from documents with Anthropic (Messages API), and flags discrepancies for a named approver—then triggers Outlook chasing for missing originals.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule and on file creation:\u003c\/strong\u003e it executes every morning and also re-checks a specific shipment when a new file is created in a OneDrive shipment subfolder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches OneDrive shipments to SharePoint data:\u003c\/strong\u003e lists shipment folders in OneDrive, matches each folder to a row in the SharePoint “Shipments” list, and loads the required document requirement rows from the SharePoint “Document requirements” list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates draft\/original presence and overdue originals:\u003c\/strong\u003e scans OneDrive \u003cem\u003edrafts\/\u003c\/em\u003e and \u003cem\u003eoriginals\/\u003c\/em\u003e subfolders, classifies documents by filename, checks required drafts\/originals, and determines whether originals are overdue for chasing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts and compares field values:\u003c\/strong\u003e for required draft documents with fields to verify, the workflow downloads the file and sends it to \u003cstrong\u003eAnthropic (Messages API)\u003c\/strong\u003e to extract the specified fields, then compares extracted values against the SharePoint instruction fields using fixed rules and tolerances.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a per-shipment work status:\u003c\/strong\u003e calculates a status and next step (e.g., ready for approval, discrepancy, awaiting originals, or complete) and writes results back to the SharePoint “Shipments” list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs and pursues originals:\u003c\/strong\u003e appends status-change and chase events to a SharePoint “Document log” list and emails the document control desk and\/or the counterpar via Outlook.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate document control for sea freight shipments by ensuring OneDrive packs match SharePoint requirements.\u003c\/li\u003e\n  \u003cli\u003eDetect discrepancies early by extracting key fields from draft documents and comparing to shipment instructions.\u003c\/li\u003e\n  \u003cli\u003eReduce manual follow-ups by tracking overdue originals and initiating Outlook email chasing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow category:\u003c\/strong\u003e n8n automation workflow\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore integrations:\u003c\/strong\u003e OneDrive, SharePoint lists (“Shipments”, “Document requirements”, “Document log”), Anthropic (Messages API), Outlook\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used (per design):\u003c\/strong\u003e if, set, code, form, sticky note, form trigger\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962329522355,"sku":"N8N-18911","price":7.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/4aA0JDHZCtKqPiolbFUdC_GYR8hup9.png?v=1788600467","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-verify-shipment-docs-in-onedrive-vs-sharepoint","provider":"N8N Commerce","version":"1.0","type":"link"}