# Prep court hearing briefs and clash alerts with Google Sheets, OpenAI, WhatsApp and Telegram

> Quick overview This workflow schedules daily court-hearing preparation by pulling active cases from Google Sheets, downloading court cause lists via HTTP, extracting PDF/HTML text, matching listings, detecting advocate clashes, and using OpenAI to generate hearing briefs that are sent over WhatsApp or Telegram, with outcomes logged back to Google Sheets. How it works 1. Runs every evening at 7:00 PM IST to compute the next working hearing date and load active cases and court cause-list sources from Google Sheets. 2. Builds one download job per relevant court, fetches each cause list over HTTP, and alerts an admin on Telegram if any download fails. 3. Extracts text from the downloaded PDF or HTML cause lists and matches each active case against the normalized text to determine whether it is listed and capture item number, court hall, bench, and stage. 4. Checks the existing Hearing Log in Google Sheets to skip cases already reminded, estimates call times from item numbers, and flags pot

- **Domain**: `n8n-workflow-20608.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/20608
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20608.n8n.io
- Documentation: https://n8n.io/workflows/20608