{"product_id":"cold-chain-lot-release-automation-with-openai-gmail-telegram","title":"Cold-Chain Lot Release Automation with OpenAI, Gmail \u0026 Telegram","description":"\u003ch3\u003eAutomate cold-chain decisions end-to-end—webhook intake to release\/disposition routing with OpenAI, Gmail, and Telegram.\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives cold-chain excursion telemetry, enriches it with an external stability API, uses OpenAI to extract evidence-backed findings, then routes lots for release, QA review, quarantine, or disposal—while archiving proof to Google Drive, logging to Google Sheets, and alerting stakeholders via Telegram and Gmail.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIngests excursion data:\u003c\/b\u003e Receives a \u003ci\u003ePOST webhook\u003c\/i\u003e containing lot details and temperature\/time-series sensor readings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEnriches with stability context:\u003c\/b\u003e Sends the payload to an external \u003cb\u003estability-envelope API\u003c\/b\u003e to retrieve validated handling limits and supporting context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts excursion facts with OpenAI:\u003c\/b\u003e Uses OpenAI to identify evidence-backed excursion windows and handling anomalies from the combined record.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eComputes risk and assigns a route:\u003c\/b\u003e Calculates a \u003cb\u003ethermal-debt-based risk score\u003c\/b\u003e, then assigns disposition (conditional release, QA review, or quarantine) based on configured thresholds.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCreates or waits for QA evidence:\u003c\/b\u003e If at or above the \u003cb\u003equarantine threshold\u003c\/b\u003e, creates a deviation\/quality case in an external \u003cb\u003eQMS API\u003c\/b\u003e; otherwise waits \u003cb\u003e30 minutes\u003c\/b\u003e for additional QA evidence.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDrafts rationale and flags destroy-level lots:\u003c\/b\u003e Uses OpenAI to draft a disposition rationale; lots at or above the \u003cb\u003edestroy threshold\u003c\/b\u003e trigger leadership attention via \u003cb\u003eTelegram\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eArchives and logs audit evidence:\u003c\/b\u003e Saves the final evidence JSON to \u003cb\u003eGoogle Drive\u003c\/b\u003e, appends an audit row to \u003cb\u003eGoogle Sheets\u003c\/b\u003e, and emails the full disposition package via \u003cb\u003eGmail\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCold-room or last-mile delivery monitoring where excursion telemetry must be rapidly assessed and dispositioned.\u003c\/li\u003e\n  \u003cli\u003eRegulated operations needing auditable evidence trails for release, review, quarantine, or disposal.\u003c\/li\u003e\n  \u003cli\u003eTeams integrating IoT events with QMS workflows to reduce manual QA triage time.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n workflow components:\u003c\/b\u003e if, set, code, wait, webhook, gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExternal integrations:\u003c\/b\u003e stability-envelope API, external QMS API, OpenAI, Google Drive, Google Sheets, Telegram, Gmail\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123138515123,"sku":"N8N-20117","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/N2QHYZxrLsrCo9OMyDqQr_U6WJ0m8G.png?v=1790672980","url":"https:\/\/buyflowscripts.com\/products\/cold-chain-lot-release-automation-with-openai-gmail-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}