{"product_id":"e-way-bill-expiry-alerts-telegram-whatsapp-gmail-via-google-sheets","title":"E-Way Bill Expiry Alerts (Telegram, WhatsApp, Gmail) via Google Sheets","description":"\u003ch3\u003eE-Way Bill expiry tracking that alerts the right people at the right time—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors India \u003cstrong\u003eE-Way Bills\u003c\/strong\u003e in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, calculates \u003cstrong\u003eValid Upto\u003c\/strong\u003e when missing, and sends staged expiry alerts to your \u003cstrong\u003eops Telegram group\u003c\/strong\u003e, \u003cstrong\u003edrivers via WhatsApp Cloud API\u003c\/strong\u003e, and \u003cstrong\u003edispatchers via Gmail\u003c\/strong\u003e. It updates status in your tracker so every alert stage fires only once.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests new E-Way Bill details\u003c\/strong\u003e from an \u003cstrong\u003en8n Form trigger\u003c\/strong\u003e or a \u003cstrong\u003ePOST webhook\u003c\/strong\u003e from your ERP\/GSP.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and deduplicates\u003c\/strong\u003e incoming records against your Google Sheets tracker.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates “Valid Upto”\u003c\/strong\u003e from distance when that field is missing.\u003c\/li\u003e\n  \u003cli\u003eAppends new bills to the tracker and sends a \u003cstrong\u003eTelegram confirmation\u003c\/strong\u003e to the ops group, logging a “tracking started” entry.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every 30 minutes\u003c\/strong\u003e to detect newly reached expiry stages: \u003cstrong\u003e12\/6\/2\/0\/-6\/-8 hours\u003c\/strong\u003e (and also respects delivery-risk conditions).\u003c\/li\u003e\n  \u003cli\u003eFor each newly triggered stage:\n    \u003cul\u003e\n      \u003cli\u003ePosts the alert to \u003cstrong\u003eTelegram\u003c\/strong\u003e,\u003c\/li\u003e\n      \u003cli\u003eSends a \u003cstrong\u003eWhatsApp template message\u003c\/strong\u003e to the driver,\u003c\/li\u003e\n      \u003cli\u003eSends an \u003cstrong\u003eemail via Gmail\u003c\/strong\u003e to the dispatcher for the configured urgent stages.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates last-alert markers\/status\u003c\/strong\u003e in Google Sheets and records every alert event in an alert log (prevents repeat alerts).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles updates\u003c\/strong\u003e (extension, delivery, vehicle change, cancellation) via a second form\/webhook: validates against the tracker, updates the record, and confirms\/rejects the change in Telegram while logging the outcome.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOps teams want \u003cstrong\u003eE-Way Bill expiry reminders\u003c\/strong\u003e before compliance becomes critical.\u003c\/li\u003e\n  \u003cli\u003eDispatchers need \u003cstrong\u003eemail alerts via Gmail\u003c\/strong\u003e only for urgent stages.\u003c\/li\u003e\n  \u003cli\u003eDriver notifications must be reliable using \u003cstrong\u003eWhatsApp Cloud API\u003c\/strong\u003e templates.\u003c\/li\u003e\n  \u003cli\u003eTrack real-time changes like \u003cstrong\u003evehicle change or cancellation\u003c\/strong\u003e with automatic validation and logging.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: tracker + alert log (two-tab setup)\u003c\/li\u003e\n  \u003cli\u003en8n nodes mentioned in workflow: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling\u003c\/strong\u003e: runs every 30 minutes for staged expiry detection\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMessaging\u003c\/strong\u003e: Telegram for ops + WhatsApp Cloud API template messages to drivers + Gmail for dispatchers\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164148453555,"sku":"N8N-20519","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0W5XSqxfEXb8Co1SrlDZE_j2rCQlaW.png?v=1791277384","url":"https:\/\/buyflowscripts.com\/products\/e-way-bill-expiry-alerts-telegram-whatsapp-gmail-via-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}