{"product_id":"n8n-workflow-oee-downtime-analysis-with-sheets-ai-whatsapp","title":"n8n Workflow: OEE \u0026 Downtime Analysis with Sheets, AI, WhatsApp","description":"\u003ch3\u003eGet OEE, downtime insights, and WhatsApp RCA—automatically—using n8n + Google Sheets + AI\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow collects per-shift machine production and downtime (via n8n Form or authenticated webhook), calculates OEE and Six Big Losses from Google Sheets, generates an OpenAI-powered root-cause analysis (RCA), and delivers a WhatsApp report with a Pareto chart—plus maintenance updates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIngests shift data\u003c\/b\u003e from an \u003cb\u003en8n Form\u003c\/b\u003e and\/or an \u003cb\u003eauthenticated webhook\u003c\/b\u003e (e.g., an IoT\/PLC gateway), then normalizes and validates the payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpserts into Google Sheets\u003c\/b\u003e by writing shift production and downtime entries to the \u003cb\u003eShift Log\u003c\/b\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns after each shift\u003c\/b\u003e (scheduled \u003ci\u003e15 minutes after shift end\u003c\/i\u003e) to load the completed shift and pull data from \u003cb\u003eMachine Master\u003c\/b\u003e and \u003cb\u003eShift Log\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCalculates KPIs\u003c\/b\u003e: Availability, Performance, Quality, and \u003cb\u003eOEE\u003c\/b\u003e; then breaks downtime into \u003cb\u003eTPM Six Big Losses\u003c\/b\u003e. Critical machines and anomalies are flagged against a \u003cb\u003erolling 7-day baseline\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eHandles missing logs\u003c\/b\u003e: if no shift data is found, it sends a \u003cb\u003eWhatsApp alert\u003c\/b\u003e to the plant head listing missing machine logs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates structured RCA with OpenAI\u003c\/b\u003e: if shift data exists, an OpenAI-powered agent queries \u003cb\u003eGoogle Sheets\u003c\/b\u003e tabs like \u003cb\u003eOEE History\u003c\/b\u003e and \u003cb\u003eMaintenance Tickets\u003c\/b\u003e to produce an actionable, structured RCA.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends a WhatsApp report\u003c\/b\u003e including a \u003cb\u003ePareto chart\u003c\/b\u003e (via a QuickChart image URL) and appends per-machine KPI rows to \u003cb\u003eOEE History\u003c\/b\u003e. For each critical machine, it also looks up open tickets in Google Sheets and updates maintenance work orders.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eManufacturing teams wanting \u003cb\u003eautomated OEE \u0026amp; downtime analysis\u003c\/b\u003e per shift.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers integrating PLC\/IoT gateway events via an \u003cb\u003eauthenticated webhook\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators packaging KPI reporting with \u003cb\u003eWhatsApp visibility\u003c\/b\u003e and AI-driven RCA.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/workflow logic: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003ewebhook\u003c\/b\u003e, \u003cb\u003ewhats app\u003c\/b\u003e, \u003cb\u003esticky note\u003c\/b\u003e, \u003cb\u003eform trigger\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cb\u003eGoogle Sheets\u003c\/b\u003e (Shift Log, Machine Master, OEE History, Maintenance Tickets) and \u003cb\u003eOpenAI\u003c\/b\u003e for structured RCA.\u003c\/li\u003e\n  \u003cli\u003eReporting: \u003cb\u003eWhatsApp\u003c\/b\u003e + \u003cb\u003eQuickChart Pareto\u003c\/b\u003e image URL.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172919169203,"sku":"N8N-20607","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7exIfRx0WXf6h4nHXES_d_SmjIH4g5.png?v=1791363779","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-oee-downtime-analysis-with-sheets-ai-whatsapp","provider":"N8N Commerce","version":"1.0","type":"link"}