Monitor Lead Response Time SLA Breaches with Google Sheets & Telegram Alerts

Description

Description

Never miss a lead again with this SLA Breach Alert automation powered by n8n! This workflow continuously monitors your Google Sheets for un-replied leads and automatically triggers instant Telegram alerts, ensuring your team takes immediate action.

By running frequent SLA checks, enriching alerts with direct Google Sheet links, and sending real-time notifications, this automation helps prevent unattended leads, reduce response delays, and boost customer engagement.

What This Template Does

📅 Runs every 5 minutes to monitor SLA breaches
📋 Fetches lead data (status, contact, timestamps) from Google Sheets
🕒 Identifies leads marked “Un-replied” beyond the 15-minute SLA
🔗 Enriches alerts with direct Google Sheet row links for quick action
📲 Sends Telegram alerts with lead details for immediate response

Step-by-Step Setup
Prepare Your Google Sheet
Create a sheet with the following columns (minimum required):
Lead Name
Email
Phone
Status (values: Replied, Un-replied)
Timestamp (time of last update/reply)
Set Up Google Sheets in n8n
Connect your Google account in n8n.
Point the workflow to your sheet (remove any hardcoded document IDs before sharing).
Configure SLA Check
Use the IF node to filter leads where:
Status = Un-replied
Time since timestamp > 15 minutes
Enrich Alerts with Links
Add a Code node to generate direct row links to the sheet.
Set Up Telegram Bot
Create a Telegram bot via @BotFather.
Add the bot to your team chat.
Store the botToken securely (remove chatId before sharing templates).
Send Alerts
Configure the Telegram node in n8n to send lead details + direct Google Sheet link.

Customization Guidance
Adjust the SLA window (e.g., 30 minutes or 1 hour) by modifying the IF node condition.
Add more fields from Google Sheets (e.g., Company, Owner) to enrich the alert.
Replace Telegram with Slack or Email if your team prefers a different channel.
Extend the workflow to auto-assign leads in your CRM once alerted.

Perfect For
Sales teams that need to respond to leads within strict SLAs
Support teams ensuring no customer request is ignored
Businesses aiming to keep lead response times sharp and consistent