Track supplier SLA breaches and corrective actions with Google Sheets, Gemini, and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 31 nodes and runs on a schedule (every hour). Along the way it connects Google Sheets, Google Gemini Chat Model and Gmail.
How it runs
Trigger: On a schedule (every hour).
- Configure SLA Monitoring (Edit Fields (Set)): sets 11 fields: cfg_run_id, cfg_checked_at, cfg_repeat_breach_lookback_days…
- Fetch SLA Rules (Google Sheets): uses Google Sheets
- Fetch Supplier Performance (Google Sheets): uses Google Sheets
- Fetch SLA Breach History (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Merge: merges the data from its input branches
- Build SLA Monitoring Dataset (Code): runs custom JavaScript code
- Compare SLA vs Actuals (Code): runs custom JavaScript code
- Build SLA Run Summary (Code): runs custom JavaScript code
- Violation Detected? (If): checks a condition and branches into true / false
…plus 16 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This scheduled workflow pulls SLA targets and supplier performance from Google Sheets, compares actuals to targets, logs any breaches back to Google Sheets, uses Google Gemini to generate corrective action recommendations, and sends a…