{"product_id":"n8n-fleet-compliance-automation-sheets-openai-alerts","title":"n8n Fleet Compliance Automation: Sheets + OpenAI Alerts","description":"\u003ch3\u003eDaily fleet compliance scans with Google Sheets + OpenAI alerts (Telegram, Slack, ClickUp, Gmail)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your fleet’s vehicle document expiries and pending e-challans every day, then sends the right alerts to \u003cstrongdrivers via telegram\u003e, creates \u003cstrong\u003eClickUp renewal tasks\u003c\/strong\u003e when needed, notifies \u003cstrong\u003eops on Slack\u003c\/strong\u003e, and delivers a \u003cstrong\u003edaily email digest\u003c\/strong\u003e to fleet managers using Gmail.\u003c\/strongdrivers\u003e\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 7 AM\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads Google Sheets\u003c\/strong\u003e tabs \u003cem\u003eFleet_Register\u003c\/em\u003e and \u003cem\u003eAlert_Log\u003c\/em\u003e to evaluate RC, insurance, PUC, fitness, and permit expiry dates and deduplicate alert stages per vehicle.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches pending e-challans\u003c\/strong\u003e via an HTTP API, calculates a `0–100` risk score, and sets \u003cstrong\u003edispatch status to BLOCKED\u003c\/strong\u003e if any required document is expired.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates dispatch gate status\u003c\/strong\u003e in Google Sheets and posts an ops alert to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel when dispatch status changes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFor vehicles needing action\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to generate:\n    \u003cul\u003e\n      \u003cli\u003ea driver Telegram message\u003c\/li\u003e\n      \u003cli\u003ea manager summary\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates renewal tasks in ClickUp\u003c\/strong\u003e when needed, sends the driver alert on \u003cstrong\u003eTelegram\u003c\/strong\u003e, and appends alert\/task keys to \u003cem\u003eAlert_Log\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends daily HTML digest emails\u003c\/strong\u003e grouped by manager email to fleet managers via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eWhen a driver sends a document photo to the Telegram bot, the workflow downloads the image, uses \u003cstrong\u003eOpenAI (gpt-4o)\u003c\/strong\u003e to extract document type, vehicle number, and valid-until, validates it against the register, updates Google Sheets if valid, and notifies ops in Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFleet ops teams automatically block vehicles with expired documents and coordinate renewals.\u003c\/li\u003e\n  \u003cli\u003eManagers receive a single daily compliance digest instead of manual status checks.\u003c\/li\u003e\n  \u003cli\u003eDrivers submit proofs via Telegram; ops get Slack updates after verification with OpenAI.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e if, code, gmail, slack, click up, telegram\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData source:\u003c\/strong\u003e Google Sheets (Fleet_Register, Alert_Log)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExternal dependency:\u003c\/strong\u003e e-challan provider via HTTP API\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI models:\u003c\/strong\u003e gpt-4o-mini for messaging, gpt-4o for document extraction\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46206037196979,"sku":"N8N-20787","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/q3BfbDiyrBLszMPbRcC5W_0nAcv1r1.png?v=1791795988","url":"https:\/\/buyflowscripts.com\/products\/n8n-fleet-compliance-automation-sheets-openai-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}