{"product_id":"automate-supplier-sla-breaches-google-sheets-gemini-gmail","title":"Automate Supplier SLA Breaches: Google Sheets, Gemini \u0026 Gmail","description":"\u003ch3\u003eAutomate Supplier SLA Breach Detection, Recommendations \u0026amp; Email Alerts with Google Sheets, Gemini \u0026amp; Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors supplier SLA performance on an hourly basis by comparing targets from Google Sheets against actuals, logs any SLA breaches for audit tracking, and uses Google Gemini to generate corrective action recommendations—then sends a single consolidated HTML email alert via Gmail.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on an hourly schedule\u003c\/b\u003e to keep SLA monitoring current without manual checks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads SLA rules and supplier performance\u003c\/b\u003e from Google Sheets, then merges the data by \u003cb\u003esupplier_id\u003c\/b\u003e and \u003cb\u003emetric_type\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCompares each metric’s SLA target vs. actual value\u003c\/b\u003e, calculates deviation, and classifies breach severity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRoutes compliant records\u003c\/b\u003e to a \u003cb\u003eno-op\u003c\/b\u003e path, while \u003cb\u003enon-compliant records\u003c\/b\u003e are enriched with summaries, urgency flags, and contract-end timing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAppends detected breaches\u003c\/b\u003e to an \u003cb\u003eSLA breach log\u003c\/b\u003e in Google Sheets for audit visibility.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAggregates all breaches into one report\u003c\/b\u003e and sends the report to \u003cb\u003eGoogle Gemini\u003c\/b\u003e for recommended actions and escalation guidance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFormats a styled HTML email\u003c\/b\u003e and sends it via \u003cb\u003eGmail\u003c\/b\u003e to the configured supplier manager.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDetect SLA risks for multiple suppliers and metrics without spreadsheets-only workflows.\u003c\/li\u003e\n  \u003cli\u003eCentralize breach history in a dedicated Google Sheets log for compliance and reporting.\u003c\/li\u003e\n  \u003cli\u003eGet AI-assisted escalation guidance from Google Gemini to standardize corrective action responses.\u003c\/li\u003e\n  \u003cli\u003eReduce alert fatigue by consolidating all breaches into a single HTML email per run.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e: SLA rules tab, supplier performance tab, and an SLA breach log (merged by \u003cb\u003esupplier_id\u003c\/b\u003e + \u003cb\u003emetric_type\u003c\/b\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Gemini (PaLM)\u003c\/b\u003e: configured via an API credential and a selected Gemini model in the Google Gemini chat model step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e: OAuth2 authentication to send the consolidated HTML email alert.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes\u003c\/b\u003e include: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003eno op\u003c\/b\u003e, \u003cb\u003emerge\u003c\/b\u003e, and \u003cb\u003egmail\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46029624672435,"sku":"N8N-19561","price":25.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ME1MKDyNpwtW9QZ6PmJE4_oODCF12D.png?v=1789464446","url":"https:\/\/buyflowscripts.com\/products\/automate-supplier-sla-breaches-google-sheets-gemini-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}