Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Daily Fleet Scan at 7 AM
  2. Read Fleet Register
  3. Read Alert Log
  4. Evaluate Document Expiry & Dedupe
  5. Check Pending e-Challans
  6. Score Risk & Dispatch Gate
  7. Needs Driver Action?
  8. Dispatch Status Changed?
  9. AI Compose Driver Alerts
  10. Update Dispatch Status in Register
  11. New Renewal Task Needed?
  12. Build Manager Digests
  13. Alert Ops on Dispatch Change
  14. Create ClickUp Renewal Task

28 steps in total.

Similar automations