{"product_id":"legal-intake-lead-qualifier-in-n8n-google-sheets-email","title":"Legal Intake Lead Qualifier in n8n: Google Sheets + Email","description":"\u003ch3\u003eInstantly Qualify Legal Intake Leads in n8n—Log, Score, Route, and Email Automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives legal intake form submissions via a webhook, scores and routes each lead using configurable keyword rules, records every submission in Google Sheets, and sends a compliance-checked auto-reply email. Hot leads can also trigger an attorney alert—and you’ll get a weekly intake quality summary based on the logged data.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives intake submissions\u003c\/b\u003e via a webhook POST from your intake form.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNormalizes and scores the lead\u003c\/b\u003e by matching the submitted \u003ci\u003epractice area\u003c\/i\u003e against a configurable list and scanning the description for \u003ci\u003eurgent\u003c\/i\u003e and \u003ci\u003edisqualifying\u003c\/i\u003e keywords.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs every submission\u003c\/b\u003e to Google Sheets by appending lead details (including \u003ci\u003efit_score\u003c\/i\u003e, \u003ci\u003erouting_tier\u003c\/i\u003e, and \u003ci\u003esubmitted_at\u003c\/i\u003e) into the \u003cb\u003e“Intake Log”\u003c\/b\u003e worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates a tier-appropriate auto-reply\u003c\/b\u003e, routes it through a separate \u003ci\u003ecompliance guardrail\u003c\/i\u003e workflow, and \u003cb\u003esends the email only when approved\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEscalates hot leads\u003c\/b\u003e: for leads scored as hot, the workflow builds an internal alert email, runs it through the compliance\/audit workflow for logging, and emails the \u003cb\u003eintake attorney\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends a weekly summary\u003c\/b\u003e: on a schedule, it reads the intake log, computes summary statistics for the lookback window, and emails a \u003cb\u003eweekly intake quality summary\u003c\/b\u003e to stakeholders.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate lead triage for a law firm intake pipeline (practice-area matching + keyword-based urgency\/disqualification).\u003c\/li\u003e\n  \u003cli\u003eMaintain an audit-ready record of every legal intake submission in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eImprove response consistency by sending tiered, compliance-approved email confirmations.\u003c\/li\u003e\n  \u003cli\u003eEnsure fast escalation for high-priority (“hot”) leads to the intake attorney.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations\/nodes\u003c\/b\u003e: webhook, if, code, no op, email send.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eData storage\u003c\/b\u003e: Google Sheets (configure \u003cb\u003eINTAKE_LOG_SHEET_ID\u003c\/b\u003e; ensure an \u003cb\u003e“Intake Log”\u003c\/b\u003e tab with matching columns like name, email, phone, fit_score, routing_tier, submitted_at, practice_area).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCompliance\u003c\/b\u003e: auto-reply and hot-lead alerts are approved\/logged via separate compliance\/audit guardrail workflows before sending.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSEO-ready keywords\u003c\/b\u003e: legal intake automation, n8n lead qualification, webhook scoring, Google Sheets intake log, compliance-checked auto-reply.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978863534259,"sku":"N8N-19376","price":10.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kKOR2dCIMfrrW5WgTtOjN_uhT8a5iR.png?v=1788858184","url":"https:\/\/buyflowscripts.com\/products\/legal-intake-lead-qualifier-in-n8n-google-sheets-email","provider":"N8N Commerce","version":"1.0","type":"link"}