{"product_id":"telegram-legal-intake-automation-openai-google-sheets-calendar","title":"Telegram Legal Intake Automation (OpenAI + Google Sheets\/Calendar)","description":"\u003ch3\u003eAutomate Telegram legal client intake end-to-end with OpenAI + Google Sheets\/Calendar\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow turns inbound Telegram messages into a structured legal intake process: it classifies the case with \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e, sends the right document checklist back to the client, logs everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, schedules a consultation in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, and keeps you informed via \u003cstrong\u003eSlack\u003c\/strong\u003e when anything fails.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives legal inquiries in Telegram\u003c\/strong\u003e: when a client sends a message to your bot, the workflow extracts the chat ID, client name, and message text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies the case using OpenAI\u003c\/strong\u003e: sends the message to \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to classify it into \u003cem\u003eproperty\u003c\/em\u003e, \u003cem\u003efamily\u003c\/em\u003e, \u003cem\u003ecriminal\u003c\/em\u003e, or \u003cem\u003eother\u003c\/em\u003e—including confidence and a one-line summary parsed from JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes to the correct checklist\u003c\/strong\u003e: based on the classification, it selects the matching pre-written document checklist and sends it back to the client via Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs cases for tracking\u003c\/strong\u003e: appends case details to a Google Sheets \u003cstrong\u003e“Cases”\u003c\/strong\u003e tab with default fields (including \u003cstrong\u003efee_status\u003c\/strong\u003e and \u003cstrong\u003efollow_up_sent\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules next-day consultation\u003c\/strong\u003e: creates a next-day event in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e and sends booking details to both the lawyer and the client through Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns automated follow-ups\u003c\/strong\u003e: daily at \u003cstrong\u003e10:00\u003c\/strong\u003e sends payment reminders for cases where \u003cstrong\u003efee_status = Pending\u003c\/strong\u003e; daily at \u003cstrong\u003e15:00\u003c\/strong\u003e sends follow-up messages where \u003cstrong\u003efollow_up_sent = No\u003c\/strong\u003e, then updates Google Sheets to prevent duplicates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts on workflow\/AI errors\u003c\/strong\u003e: posts to \u003cstrong\u003eSlack\u003c\/strong\u003e if the workflow fails, and separately alerts when the OpenAI classification step errors.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLaw firms using a Telegram bot to screen clients and instantly provide the correct document checklist.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying a repeatable legal intake workflow with Sheets-based case tracking and Calendar scheduling.\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, set, code, slack, switch, telegram\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Telegram (intake + confirmations), OpenAI (gpt-4o-mini classification), Google Sheets (“Cases” tab), Google Calendar (next-day consultation), Slack (failure + classification error alerts)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45748947222707,"sku":"N8N-17679","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/P6SQlomwEkTqG0Ju41Ch5_bf3mNYvM.png?v=1785575677","url":"https:\/\/buyflowscripts.com\/products\/telegram-legal-intake-automation-openai-google-sheets-calendar","provider":"N8N Commerce","version":"1.0","type":"link"}