{"product_id":"n8n-webhook-lead-enrichment-to-google-sheets-attorney-briefings","title":"n8n Webhook Lead Enrichment to Google Sheets \u0026 Attorney Briefings","description":"\u003ch3\u003eTurn new legal leads into enriched intelligence—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Webhook Lead Enrichment to Google Sheets \u0026amp; Attorney Briefings\u003c\/strong\u003e workflow receives leads via a webhook, enriches business-domain emails, assigns a \u003cstrong\u003ematter value tier\u003c\/strong\u003e, logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and emails a formatted \u003cstrong\u003eattorney briefing\u003c\/strong\u003e—plus a weekly summary of lead value tiers and top companies.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives leads via webhook:\u003c\/strong\u003e A POST request is sent to the workflow’s \u003cstrong\u003e“lead-enrichment”\u003c\/strong\u003e endpoint, and key fields are normalized (name, email, phone, practice area, and case description).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects and enriches business domains:\u003c\/strong\u003e The workflow extracts the email domain, determines whether it’s a business domain, and—when applicable—calls a configurable external \u003cstrong\u003eenrichment API\u003c\/strong\u003e to fetch company details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles “no company signal” leads:\u003c\/strong\u003e If no company signal is available, it records that state rather than forcing enrichment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes a matter value tier:\u003c\/strong\u003e Using \u003cstrong\u003ekeyword and dollar-amount signals\u003c\/strong\u003e found in the case description—and whether company enrichment exists—the workflow assigns a value tier.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets:\u003c\/strong\u003e It appends lead details, enrichment fields, and the computed value tier to a Google Sheet named \u003cstrong\u003e“Enrichment Log”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends attorney briefing:\u003c\/strong\u003e It generates an HTML\/text briefing and uses \u003cstrong\u003eExecute Workflow\u003c\/strong\u003e to log the briefing to a guardrail\/compliance workflow, then emails it to the configured attorney email address.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly for quality reporting:\u003c\/strong\u003e On schedule, it aggregates the last N days from the Google Sheets enrichment log (tier counts and top companies) and emails a weekly lead quality summary.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLegal intake teams that need \u003cstrong\u003efast, consistent lead enrichment\u003c\/strong\u003e before attorney review.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing lead pipelines who want \u003cstrong\u003eGoogle Sheets tracking\u003c\/strong\u003e and \u003cstrong\u003evalue-tier reporting\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying a \u003cstrong\u003ewebhook-to-briefing\u003c\/strong\u003e flow with scheduled performance summaries.\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 webhook, if, code, http request, email send, sticky note, Execute Workflow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfig:\u003c\/strong\u003e Set \u003cstrong\u003eENRICHMENT_API_URL\u003c\/strong\u003e (and optional \u003cstrong\u003eCONSUMER_EMAIL_DOMAINS\u003c\/strong\u003e and \u003cstrong\u003eHIGH_VALUE_KEYWORDS\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuthentication:\u003c\/strong\u003e Provide an HTTP header auth credential for the enrichment API.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978862354611,"sku":"N8N-19377","price":67.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5hQmHzqNmaa9kG7ie9CCQ_O4fj0YqY.png?v=1788858159","url":"https:\/\/buyflowscripts.com\/products\/n8n-webhook-lead-enrichment-to-google-sheets-attorney-briefings","provider":"N8N Commerce","version":"1.0","type":"link"}