Monitor lead response time SLA breaches with Google Sheets & Telegram alerts

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