Send e-way bill expiry alerts via Google Sheets, Telegram, WhatsApp and Gmail

by Rahul Joshi ✓ · 6 views · created 2026-10-06 · Document Extraction

What this workflow does

This workflow has 32 nodes and runs when someone submits an n8n form (“Track an E-Way Bill”) (plus 4 other triggers). Along the way it connects Telegram, Google Sheets and Gmail.

How it runs

Trigger: When someone submits an n8n form (“Track an E-Way Bill”) (plus 4 other triggers).

1. Set Intake Config (Edit Fields (Set)): sets 13 fields: company_name, ops_telegram_chat_id, ops_email…
2. Set Monitor Config (Edit Fields (Set)): sets 13 fields: company_name, ops_telegram_chat_id, ops_email…
3. Set Update Config (Edit Fields (Set)): sets 13 fields: company_name, ops_telegram_chat_id, ops_email…
4. Normalize EWB & Calculate Validity (Code): runs custom JavaScript code
5. Get Active EWBs (Google Sheets): uses Google Sheets
6. Get EWB Records (Google Sheets): uses Google Sheets
7. Get Tracked EWBs (Google Sheets): uses Google Sheets
8. Plan Expiry Alerts (Code): runs custom JavaScript code
9. Apply Status Update (Code): runs custom JavaScript code
10. Skip Already Tracked (Code): runs custom JavaScript code

…plus 17 more steps. See the full node list below.

Services it uses

TelegramGoogle SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (10)

• n8n Form Triggern8n-nodes-base.formTrigger
• Telegramn8n-nodes-base.telegram
• Webhookn8n-nodes-base.webhook
• Edit Fields (Set)n8n-nodes-base.set
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Gmailn8n-nodes-base.gmail

From the author

Quick overview This workflow tracks India E-Way Bills in Google Sheets from a form or webhook, calculates validity when missing, and sends staged expiry alerts to an ops Telegram group, drivers via WhatsApp Cloud API, and dispatchers via Gmail, while logging…

View the original on n8n.io → Check your own copy