Business hours lead response system with Gmail, Google Sheets & Telegram alerts
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs on Google Sheets events (row update). Along the way it connects Gmail, Telegram and Google Sheets.
How it runs
Trigger: On Google Sheets events (row update).
- Wait: waits 5 minutes
- Check Business Hours (Function): runs custom JavaScript (legacy Function node)
- If: checks a condition and branches into true / false
- Send Gmail (Business Hours) (Gmail): work with message
- Edit Fields (Edit Fields (Set)): sets 3 fields: First name, Last name, Email address
- Notify Telegram (Telegram): uses Telegram
- Send Gmail (After Hours) (Gmail): work with message
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Check Business Hours: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Check Business Hours | Code node, mode 'Run Once for All Items' |
Nodes used (7)
- Wait
n8n-nodes-base.wait - Function
n8n-nodes-base.function - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Telegram
n8n-nodes-base.telegram - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set
From the author
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,…