{"product_id":"approve-carrier-detention-disputes-n8n-gmail-google-sheets","title":"Approve Carrier Detention Disputes: n8n, Gmail \u0026 Google Sheets","description":"\u003ch3\u003eApprove Carrier Detention Disputes automatically—built with n8n, Gmail, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eTurn carrier detention and accessorial disputes into a streamlined approval workflow. This n8n automation collects claims from an n8n form, calculates billable detention with tier-based caps, drafts settlement offers with OpenAI, routes larger claims for manager approval in Gmail, and then posts approved charges to your TMS API while logging outcomes to Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests detention\/accessorial claims\u003c\/strong\u003e submitted via an n8n form (load details, timestamps, carrier tier, and contracted detention rate).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes fields\u003c\/strong\u003e and calculates billable detention hours \u003cem\u003eafter 2 hours free time\u003c\/em\u003e, then computes the detention amount.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies daily caps by carrier tier\u003c\/strong\u003e to ensure detention charges are controlled according to your contract rules.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomatically approves smaller claims\u003c\/strong\u003e (below $150) and flags larger claims for review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts settlement offer content\u003c\/strong\u003e for claims needing review using \u003cstrong\u003eOpenAI\u003c\/strong\u003e, including an HTTP \u003cstrong\u003ecarrier-performance lookup\u003c\/strong\u003e tool.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequests approval in Gmail\u003c\/strong\u003e using send-and-wait behavior to a broker manager, then detects whether the manager approved or rejected.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCommits approved charges\u003c\/strong\u003e to your \u003cstrong\u003eTMS accessorial-charge API\u003c\/strong\u003e and emails the carrier a confirmation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles rejections\u003c\/strong\u003e by appending details to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, emailing a denial to the carrier, and logging final decisions for auditing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBroker teams processing frequent detention disputes and needing consistent, contract-based calculations.\u003c\/li\u003e\n  \u003cli\u003eOperators who want manager approval only when claims exceed $150, reducing manual review.\u003c\/li\u003e\n  \u003cli\u003eTeams that must maintain an audit trail of approvals\/rejections in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n stack\/nodes:\u003c\/strong\u003e if, set, code, gmail, merge, and sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eOpenAI\u003c\/strong\u003e for settlement drafting, \u003cstrong\u003eGmail\u003c\/strong\u003e for manager approval, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for logging, and HTTP authentication for a \u003cstrong\u003eCarrier Perf\u003c\/strong\u003e lookup.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPI actions:\u003c\/strong\u003e posts approved detention\/accessorial charges to a \u003cstrong\u003eTMS API\u003c\/strong\u003e and sends carrier emails with the final decision.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978918486195,"sku":"N8N-19357","price":18.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/yfYkuRCniT4PnsRRtAxSB_jNeXXmHr.png?v=1788858691","url":"https:\/\/buyflowscripts.com\/products\/approve-carrier-detention-disputes-n8n-gmail-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}