# Manage fleet compliance and driver renewals with Sheets, OpenAI and Telegram

> Quick overview This workflow runs a daily compliance scan from Google Sheets, checks each vehicle’s document expiries and pending e-challans via an HTTP API, then uses OpenAI to message drivers on Telegram, create renewal tasks in ClickUp, notify ops in Slack, and email Gmail digests to fleet managers. How it works 1. Runs every day at 7 AM on a schedule trigger. 2. Reads the FleetRegister and AlertLog tabs in Google Sheets to evaluate RC/insurance/PUC/fitness/permit expiries and dedupe alert stages per vehicle. 3. Calls your e-challan provider over HTTP to fetch pending challans, calculates a 0–100 risk score, and sets the vehicle dispatch status to BLOCKED if any document is expired. 4. When dispatch status changes, updates the vehicle’s status in Google Sheets and posts a dispatch gate alert to an ops Slack channel. 5. For vehicles needing action, uses OpenAI (gpt-4o-mini) to generate a driver Telegram message plus manager summary, creates a ClickUp renewal task when needed, sends t

- **Domain**: `n8n-workflow-20787.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20787
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20787.n8n.io
- Documentation: https://n8n.io/workflows/20787