Zapier Lead Nurturing Gmail Google Sheets Telegram

Business Hours Lead Response System

Automate lead follow-ups with instant email replies, Google Sheets logging, and Telegram alerts. Never miss an inquiry, day or night.

Download Template JSON · n8n compatible · Free
Visual diagram of the business hours lead response automation workflow connecting Google Sheets, Gmail, and Telegram

What This Workflow Does

Missed leads mean missed revenue. When potential customers reach out via your website form, contact page, or any other channel, they expect a prompt response. This free n8n workflow template solves that problem by creating a fully automated lead response system that works 24/7.

It monitors a Google Sheet for new form submissions, checks if the inquiry arrived during your defined business hours, and sends an appropriate, professional email reply. During business hours, leads receive an immediate acknowledgment that your team is on it. After hours, they get a polite message setting expectations for a follow-up the next business day. Simultaneously, your sales or support team receives instant Telegram notifications with all lead details, enabling rapid follow-up.

This automation eliminates manual monitoring, ensures consistency, and dramatically improves your lead response time—a key factor in increasing conversion rates and customer satisfaction.

How It Works

The workflow is built on a logical sequence that ensures reliability and appropriate messaging.

Step 1: Trigger on New Sheet Entry

The automation starts when a new row is added to your designated Google Sheet, which acts as your central lead log. This could be from a Typeform, Google Form, Webhook, or any other source that writes to Sheets.

Step 2: Data Validation & Brief Delay

A short wait node (typically 2-5 minutes) ensures the incoming data is complete and avoids processing partial form submissions. This step catches multi-page forms or slow connections.

Step 3: Business Hours Logic Check

A Function or IF node evaluates the submission timestamp against your configured business hours (e.g., 9 AM–6 PM, Monday–Friday). This determines which email template and notification path to use.

Step 4: Send Tailored Email Response

Based on the time check, the workflow uses the Gmail node to send a personalized reply. Business-hour leads get a "we've received your inquiry" message, while after-hours leads get a "we'll contact you tomorrow" acknowledgment.

Step 5: Instant Team Alert via Telegram

Regardless of the time, a formatted message containing the lead's name, contact info, message, and submission time is sent to a designated Telegram group or channel. This puts the information directly in your team's pocket for immediate action.

Pro tip: Use the "Edit Fields" (Set) node to clean and format the lead data before sending the Telegram alert. This ensures the notification is concise and actionable for your team.

Who This Is For

This template is ideal for small to medium businesses, freelancers, and agencies that receive inbound leads but lack a 24/7 sales team. It's perfect for:

  • Service-based businesses (consultants, agencies, coaches) who need to project professionalism and responsiveness.
  • E-commerce stores handling pre-sale product inquiries or wholesale requests.
  • Startups and SaaS companies managing demo requests and trial sign-ups.
  • Operations teams tired of manually forwarding form submissions to sales reps.
  • Any team using Google Sheets as a simple, free CRM and wanting to add automation layers.

What You'll Need

  1. A Google Sheet with columns for: Name, Email, Phone, Message, and Timestamp.
  2. A Gmail account (or Google Workspace) with API access enabled to send automated emails.
  3. A Telegram account and a bot token created via @BotFather. You'll also need the Chat ID of the group or channel where alerts should be sent.
  4. An n8n instance, either self-hosted or using n8n.cloud.
  5. Basic understanding of how to create credentials in n8n for Google and Telegram services.

Quick Setup Guide

Get this automation running in your environment in under 15 minutes.

  1. Download & Import: Click the "Download Template" button above and save the JSON file. In your n8n instance, go to Workflows > Import from File and select the downloaded file.
  2. Configure Credentials: Create and connect n8n credentials for Google Sheets (to trigger and read), Gmail (to send), and Telegram Bot (to notify).
  3. Update Resource IDs: In the Google Sheets trigger node, paste the ID of your lead tracking Sheet and specify the worksheet name.
  4. Customize Messages: Edit the two Gmail nodes to reflect your company's voice, sender name, and specific business hours.
  5. Set Telegram Chat ID: In the Telegram node, paste the Chat ID of your team's group or channel.
  6. Activate & Test: Turn the workflow ON and submit a test entry to your Google Sheet. Verify you receive the correct email and Telegram alert.

Key Benefits

Improve Lead Conversion Rates: Responding within minutes, not hours, significantly increases your chances of closing a deal. Automated acknowledgment keeps your business top-of-mind.

Operate 24/7 Professionalism: Even when your team is asleep or offline, leads receive an immediate, professional response that manages expectations and builds trust from the first interaction.

Eliminate Manual Work & Human Error: No more copying data from sheets to emails or forgetting to notify the team. The entire process is hands-off, consistent, and reliable.

Centralize Lead Data: All inquiries are automatically logged in Google Sheets, creating a searchable, historical record for analysis and reporting without any extra effort.

Empower Your Team with Mobile Alerts: Instant Telegram notifications mean your sales reps can act on hot leads immediately, from anywhere, using their phones.

Frequently Asked Questions

Common questions about lead response automation and integration

Automating lead response is critical because speed directly impacts conversion rates. Studies show responding within 5 minutes makes you 21x more likely to qualify a lead. Manual follow-ups are slow, inconsistent, and prone to human error, especially outside business hours.

Automation ensures every inquiry gets an immediate, professional acknowledgment, keeping your business top-of-mind and building trust from the first touchpoint. It turns a potential customer's moment of interest into a structured, trackable opportunity without delay.

Connecting these tools creates a seamless lead management system. Gmail provides professional email communication, Google Sheets acts as a simple, accessible CRM for logging all interactions, and Telegram delivers instant mobile alerts to your team.

This combination eliminates manual data entry, reduces response time from hours to seconds, and ensures your sales team can act on hot leads immediately, even when away from their desks. It's a cost-effective way to build a powerful sales pipeline without expensive software.

Business hours detection uses time-based logic to determine if a lead arrives during your defined working hours (e.g., 9 AM–6 PM, Monday–Friday). The automation checks the submission timestamp against these parameters and routes the lead accordingly.

It sends an immediate "we're on it" response during business hours or a polite "we'll get back to you tomorrow" acknowledgment after hours. This maintains professionalism while setting clear expectations. You can easily adjust the time window and days to match your operational schedule.

Yes, you can fully customize email templates based on inquiry type, source, or lead quality. Beyond business/after-hours templates, you can create variations for different services, product inquiries, or support requests.

You can personalize messages with the lead's name, company, and specific details from their submission. Advanced setups can even use AI to analyze the inquiry and generate tailored responses, making each interaction feel handcrafted while maintaining automation efficiency.

Telegram alerts should include essential lead details for quick assessment: name, email, phone, submission time, the core message, and a lead score if calculated. Include a direct link to the Google Sheets row for context.

For high-priority leads (based on keywords or form fields), add urgency indicators. Keep messages concise but actionable—your team should understand the lead's value and next steps at a glance without opening multiple apps. A well-structured alert enables faster, more informed responses.

Balance automation with personalization. Use merge tags to include the lead's name and specific details from their inquiry. Segment responses based on the inquiry type or source. Follow up the auto-reply with a personalized email from a team member within 24 hours.

Consider adding a human touch point, like a quick personal video message for high-value leads. The automation handles the immediate acknowledgment, freeing your team to focus on meaningful, personalized follow-up. This hybrid approach combines speed with genuine connection.

Common pitfalls include not testing timezone settings (causing replies at wrong times), using overly generic templates that feel robotic, failing to handle weekends/holidays in business logic, not setting up proper error handling for failed emails, and creating alert fatigue with too many Telegram notifications.

Always test with various scenarios, implement logging to track failures, and regularly review response quality to refine templates and logic. Start simple, ensure it works reliably, then gradually add complexity like lead scoring or multi-step follow-ups.

Yes, GrowwStacks specializes in building custom lead response automations tailored to your specific business processes, CRM, and communication tools. We can integrate with your existing sales pipeline, add lead scoring, implement multi-channel follow-up sequences, and create dashboards to track performance.

Our team handles the technical implementation so you can focus on converting leads. Book a free consultation to discuss your requirements and get a custom solution that fits your workflow perfectly, saving you time and increasing your conversion rates from day one.

Need a Custom Lead Response Automation?

This free template is a starting point. Our team builds fully tailored automation systems for your specific business needs.

Get Free Consultation → Browse More Workflows