Library / Monitoring, Ops & Incidents
Monitoring, Ops & Incidents
Track fleet document renewals with Google Sheets, OpenAI, Telegram and ClickUp
Runs daily to check RC, insurance, PUC and permit dates and e-challans, blocks vehicles with expired documents from dispatch, and sends AI-written Telegram reminders and ClickUp renewal tasks.
What it does
## 🚛 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.
The steps
- 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
28 steps in total.
Similar automations
RAG & Knowledge BasesReport Fleet Fuel Efficiency with Claude RAG and Weaviate10 stepsDocuments, PDF & OCRTrack contract renewals from Drive PDFs with Gemini, Sheets, Gmail and Slack43 stepsTasks & Project ManagementScore contract renewal risk and route approvals from webhook intake14 stepsTasks & Project ManagementReceive ClickUp Event Updates1 steps