Kütüphane / İzleme, Operasyon ve Olaylar
İzleme, Operasyon ve Olaylar
Google Sheets, OpenAI, Telegram ve ClickUp ile filo belge yenilemelerini takip edin
Her gün RC, sigorta, PUC ve izin tarihlerini ile e-challan kayıtlarını kontrol eder, süresi dolmuş belgesi olan araçların sevkiyatını engeller ve yapay zekâ tarafından yazılmış Telegram hatırlatmaları ile ClickUp yenileme görevleri gönderir.
Ne yapar
## 🚛 Fleet Compliance OS For Indian fleet owners and transport managers who track RC, insurance, PUC, fitness and permit dates in a spreadsheet, and find out a document lapsed when a truck is stopped or a challan arrives. ### How it works Every morning each vehicle's document dates are checked, and pending e-challans are pulled from your challan provider. Each vehicle gets a risk score, and any vehicle with an expired document is blocked from dispatch, with ops told in Slack. Drivers get an AI-written Telegram reminder at 30, 15, 7, 3 and 0 days, a ClickUp renewal task is opened, and fleet managers get a daily email digest. The loop closes on Telegram. A driver sends a photo of the renewed document to the bot, GPT-4o reads it, and if the vehicle number and new expiry check out, the register is updated and the driver gets a confirmation. ### Setup steps 1. Create a Google Sheet with Fleet_Register and Alert_Log tabs. The register needs one row per vehicle, with expiry columns and the driver's Telegram chat ID. 2. Connect Google Sheets, OpenAI, Telegram (bot), Slack, ClickUp and Gmail. 3. Add your e-challan API as Header Auth and set its URL in Check Pending e-Challans. 4. Replace YOUR_GOOGLE_SHEET_ID, the Slack channel and the ClickUp list, then run the daily scan once manually.
Adımlar
- Daily Fleet Scan at 7 AM
- Read Fleet Register
- Read Alert Log
- Evaluate Document Expiry & Dedupe
- Check Pending e-Challans
- Score Risk & Dispatch Gate
- Needs Driver Action?
- Dispatch Status Changed?
- AI Compose Driver Alerts
- Update Dispatch Status in Register
- New Renewal Task Needed?
- Build Manager Digests
- Alert Ops on Dispatch Change
- Create ClickUp Renewal Task
Toplam 28 adım.
Benzer otomasyonlar