WorkflowPatchShipping notification gate proof.
A first slice for a Google Sheet ready row plus tracking number. The proof checks carrier status and ETA evidence, decides notify or hold, creates customer email drafts for approval, and routes delayed or missing tracking to ops alerts. No live customer email, Supermail, Gmail, weather claim, or ETA promise is sent.
Notification Queue CSV
Ops Alerts CSV
Error Log CSV
Orders CSV
Carrier Status CSV
Runbook
Source Script
First Slice
Google Sheet ready row -> carrier status and ETA evidence -> customer draft or ops alert.
Useful Sample
One ready order, one not-live tracking case, required customer fields, and the duplicate rule.
Boundary
Customer-facing updates stay draft-only until the notify/no-notify rule is accepted in writing.
| Order | Status | Issue | Evidence | Reviewer Action |
|---|---|---|---|---|
| ORD-9001 | draft ready | live UPS tracking | ETA 2026-05-13 with weather note from the carrier-status row. | Approve or edit the customer update before sending. |
| ORD-9002 | ops alert | tracking not live | Carrier status is label_created and ETA is missing. | Recheck in 12 hours before any customer notification. |
| ORD-9004 | blocked | order not ready | ready_flag is not yes. | Confirm production state before customer copy exists. |
| ORD-9005 | error | missing customer email | Required email field is blank. | Reject the row until a usable destination is present. |