{"product_id":"n8n-reefer-demurrage-dispute-packet-automation-ai-dropbox-airtable","title":"n8n Reefer Demurrage Dispute Packet Automation (AI, Dropbox, Airtable)","description":"\u003ch3\u003eAutomatically generate an n8n Reefer Demurrage Dispute Packet from webhook evidence\u003c\/h3\u003e\n\u003cp\u003eStop chasing reefer incident paperwork. This \u003cstrong\u003en8n Reefer Demurrage Dispute Packet Automation\u003c\/strong\u003e receives a reefer-incident webhook, analyzes terminal power events and (when available) reefer telemetry with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, then creates a dispute packet that’s archived in \u003cstrong\u003eDropbox\u003c\/strong\u003e, tracked in \u003cstrong\u003eAirtable\u003c\/strong\u003e, submitted via a carrier API, and escalated to \u003cstrong\u003eMicrosoft Teams\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 a POST webhook\u003c\/strong\u003e with a claim ID and one or more reefer container IDs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the payload\u003c\/strong\u003e, then calls a terminal \u003cstrong\u003epower-events API\u003c\/strong\u003e to fetch plug\/unplug event data for the provided containers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits results per container\u003c\/strong\u003e and uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a \u003cem\u003estrict-JSON\u003c\/em\u003e evidence narrative (event type, missing fields, and causation notes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates unplug duration\u003c\/strong\u003e from terminal timestamps, flags whether the event is complete, and marks events as \u003cstrong\u003edisputable\u003c\/strong\u003e when unplug minutes exceed a configured free-time threshold.\u003c\/li\u003e\n  \u003cli\u003eIf evidence is complete, it \u003cstrong\u003efetches reefer telemetry\u003c\/strong\u003e from a telemetry API; otherwise, it \u003cstrong\u003eemails a request for missing terminal evidence\u003c\/strong\u003e via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates everything\u003c\/strong\u003e into a single JSON dispute artifact with per-container details and totals.\u003c\/li\u003e\n  \u003cli\u003eIf at least one disputable event exists, it \u003cstrong\u003euploads the packet to Dropbox\u003c\/strong\u003e, \u003cstrong\u003ecreates a claim in Airtable\u003c\/strong\u003e, \u003cstrong\u003esubmits to a carrier API\u003c\/strong\u003e, and \u003cstrong\u003enotifies via Microsoft Teams\u003c\/strong\u003e. Otherwise, it logs the non-material incident.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate reefer demurrage disputes for logistics teams using n8n.\u003c\/li\u003e\n  \u003cli\u003eStandardize evidence classification for plug\/unplug events across multiple containers.\u003c\/li\u003e\n  \u003cli\u003eReduce manual steps: archive dispute packets, log claims, and notify stakeholders.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow runtime (n8n)\u003c\/strong\u003e using nodes like if, set, code, merge, and Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e terminal power-events API, reefer telemetry API, \u003cstrong\u003eOpenAI\u003c\/strong\u003e (strict-JSON evidence classification), \u003cstrong\u003eDropbox\u003c\/strong\u003e, \u003cstrong\u003eAirtable\u003c\/strong\u003e, carrier API submission, and \u003cstrong\u003eMicrosoft Teams\u003c\/strong\u003e notification.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45967485337779,"sku":"N8N-19275","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/lVzIsmdpIM4RJDUpiYrcv_tFwsgwSv.png?v=1788685445","url":"https:\/\/buyflowscripts.com\/products\/n8n-reefer-demurrage-dispute-packet-automation-ai-dropbox-airtable","provider":"N8N Commerce","version":"1.0","type":"link"}