Business hours lead response system with Gmail, Google Sheets & Telegram alerts

Description:

Never leave your leads waiting! This n8n workflow template ensures every inquiry gets a timely and professional response—whether it’s business hours or after hours. By checking submission times, the automation sends tailored email replies, updates your team instantly, and ensures no lead goes unnoticed.

This workflow monitors a Google Sheet for new form responses, waits briefly to capture complete data, checks if the submission falls within business hours, and then sends either a standard business reply or a polite after-hours acknowledgment. Additionally, it alerts your team via Telegram with lead details for quick follow-up. Perfect for sales, support, and operations teams managing inbound leads.

Features

🕒 Monitors Google Sheets for new or updated lead form responses ⌛ Adds a short delay to ensure clean, complete data capture ⏰ Detects whether submissions fall within business hours (9 AM–6 PM, Mon–Fri) 📧 Sends automated Gmail replies (business hours vs. after-hours messaging) 📲 Notifies your team instantly on Telegram with lead details 🌟 Fully automated: hands-free lead acknowledgment + team alerts

How It Works

- Google Sheets Trigger – Watches for new form submissions in your lead sheet. - Data Validation – Waits 5 minutes to ensure complete entry. - Business Hours Check – Determines if the inquiry is within working hours. - Email Response – Sends tailored Gmail reply (business hours or after-hours). - Telegram Notification – Instantly notifies your team with lead details.

Setup Instructions