{"product_id":"n8n-workflow-scale-calibration-outcomes-router-webhook-openai","title":"n8n Workflow: Scale Calibration Outcomes Router (Webhook + OpenAI)","description":"\u003ch3\u003eAutomatically route scale calibration results with NIST 44 tolerance logic + OpenAI classification\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives scale calibration outcomes through a Webhook, calculates NIST Handbook 44-style tolerance deviations per device, uses OpenAI to classify each result (compliant, out-of-tolerance fail, or condemned), and then routes submissions to the right destination—Google Drive, Gmail, HTTP state registry endpoints, and Google Sheets—with a consolidated audit log per visit.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives calibration data via POST Webhook\u003c\/strong\u003e including a visit ID, technician details, and an array of device calibration readings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits the payload per device\u003c\/strong\u003e and computes deviation percent, a tolerance band by device class, and a numeric status hint.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required fields\u003c\/strong\u003e; malformed readings are appended to an \u003cem\u003e“Invalid Submissions”\u003c\/em\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies each valid device outcome with OpenAI\u003c\/strong\u003e to select one of: compliant, out_of_tolerance_fail, or condemned.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompliant routing\u003c\/strong\u003e: stores the certificate file in \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e and sends a certification update to the \u003cstrong\u003estate registry\u003c\/strong\u003e via \u003cstrong\u003eHTTP\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOut-of-tolerance routing\u003c\/strong\u003e: sends an urgent \u003cstrong\u003eGmail\u003c\/strong\u003e alert to the owner and opens a compliance case in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCondemned routing\u003c\/strong\u003e: submits a decommission notice to the \u003cstrong\u003estate registry\u003c\/strong\u003e via \u003cstrong\u003eHTTP\u003c\/strong\u003e, logs the decommission record in Google Sheets, then merges all outcomes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConsolidated audit log\u003c\/strong\u003e: appends one audit-log row per visit in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCalibration labs automating end-to-end reporting after technician field visits.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators standardizing compliance workflows that must follow tolerance rules and recordkeeping.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building reliable routing for certification, compliance cases, and decommission actions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow components\u003c\/strong\u003e: if, set, code, gmail, merge, switch\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Webhook, Google Sheets, Google Drive, Gmail, OpenAI, and HTTP state registry endpoints (including an HTTP header configuration step).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081426063539,"sku":"N8N-19870","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/CFvNLwVrpcTF_lJTOgs_9_d8htSVz8.png?v=1790241122","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-scale-calibration-outcomes-router-webhook-openai","provider":"N8N Commerce","version":"1.0","type":"link"}