# Analyze machine downtime and OEE with Google Sheets, OpenAI and WhatsApp

> Quick overview This workflow captures per-shift machine production and downtime data via an n8n Form or an authenticated webhook, calculates OEE and TPM Six Big Losses from Google Sheets data, uses OpenAI for structured root-cause analysis, then sends a WhatsApp report with a Pareto chart and updates maintenance work orders. How it works 1. Accepts shift production and downtime entries from an n8n Form and/or an authenticated webhook from an IoT/PLC gateway, normalizes and validates the payload, and upserts it into a Google Sheets “Shift Log” tab. 2. Runs on a schedule 15 minutes after each shift end to identify the completed shift and load the “Machine Master” and “Shift Log” data from Google Sheets. 3. Calculates plant and per-machine Availability, Performance, Quality, and OEE, breaks downtime into the TPM Six Big Losses, and flags critical machines and anomalies against a rolling 7-day baseline. 4. If no shift data is found, sends a WhatsApp alert to the plant head listing missing 

- **Domain**: `n8n-workflow-20607.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20607
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20607.n8n.io
- Documentation: https://n8n.io/workflows/20607