Step 2: Connect Google Sheets Data Mapping

Map lead fields for the after-hours branch so email personalization works correctly.

1. Open Map Lead Fields.
2. Set First name to ={{ $('Sheet Update Trigger').item.json['First name'] }}.
3. Set Last name to ={{ $('Sheet Update Trigger').item.json['Last name'] }}.
4. Set Email address to ={{ $('Sheet Update Trigger').item.json['Email address'] }}.

Execution Flow: The Business Hours Gate false path routes to Map Lead Fields → Dispatch Email (After Hours).

Step 3: Set Up Office Hours Evaluation & Routing

Configure the timing pause, office-hours logic, and the decision gate that splits in-hours vs after-hours responses.

1. Open Pause Five Minutes and set Unit to minutes with Amount 5.
2. Open Evaluate Office Hours and paste the provided Function Code that converts the Excel timestamp, computes isBusinessHours, and sets exactDateTime and onlyTime.
3. Open Business Hours Gate and set the date/time condition with Value 1 ={{ $json.exactDateTime }}, Operation before, and Value 2 2025-09-02T18:00:00.

Execution Flow: Evaluate Office Hours → Business Hours Gate. True path → Dispatch Email (In Hours); False path → Map Lead Fields.

Step 4: Configure Email & Telegram Notifications

Set up the in-hours and after-hours email responses and send a Telegram alert for every lead.

1. Open Dispatch Email (In Hours) and set To to ={{ $json["Email Address"] }}.
2. Set Subject to Thanks for reaching out! and Message to =Hii {{ $json["First Name"] }}{{ $json["Last name"] }} Thanks for connecting, Our team will get back to you soon.
3. Credential Required: Connect your gmailOAuth2 credentials for Dispatch Email (In Hours).
4. Open Dispatch Email (After Hours) and set To to ={{ $json["Email address"] }}.
5. Set Subject to Thanks for contacting us (After Hours) and Message to =Hii {{ $json["First name"] }}{{ $json["Last name"] }} Thanks for connecting in after hours Our team will get back to you tomorrow.
6. Credential Required: Connect your gmailOAuth2 credentials for Dispatch Email (After Hours).
7. Open Post Telegram Alert and set Chat ID to your Telegram ID (currently [YOUR_ID]).
8. Set Text to =📩 New lead received! Name:{{ $('Sheet Update Trigger').item.json['First Name'] }} {{ $('Sheet Update Trigger').item.json['Last name'] }} Email: {{ $('Sheet Update Trigger').item.json['Email Address'] }} Connect with the lead tomorrow.
9. Credential Required: Connect your telegramApi credentials.

Execution Flow: Dispatch Email (In Hours) → Post Telegram Alert and Dispatch Email (After Hours) → Post Telegram Alert.

Step 5: Test and Activate Your Workflow

Run a manual test to verify lead timing logic, email routing, and Telegram notification delivery before activating.

1. Click Execute Workflow and update a row in your Google Sheet to trigger Sheet Update Trigger.
2. Verify Pause Five Minutes waits for 5 minutes, then Evaluate Office Hours sets isBusinessHours and exactDateTime.
3. Confirm Business Hours Gate routes in-hours to Dispatch Email (In Hours) and after-hours to Map Lead Fields → Dispatch Email (After Hours).
4. Check that Post Telegram Alert posts the formatted message to your specified chat.
5. When everything works, toggle the workflow Active to enable continuous monitoring.