n8n Webhook Lead Enrichment to Google Sheets & Attorney Briefings

Turn new legal leads into enriched intelligence—automatically

This n8n Webhook Lead Enrichment to Google Sheets & Attorney Briefings workflow receives leads via a webhook, enriches business-domain emails, assigns a matter value tier, logs everything to Google Sheets, and emails a formatted attorney briefing—plus a weekly summary of lead value tiers and top companies.

What this workflow does

• Receives leads via webhook: A POST request is sent to the workflow’s “lead-enrichment” endpoint, and key fields are normalized (name, email, phone, practice area, and case description).
• Detects and enriches business domains: The workflow extracts the email domain, determines whether it’s a business domain, and—when applicable—calls a configurable external enrichment API to fetch company details.
• Handles “no company signal” leads: If no company signal is available, it records that state rather than forcing enrichment.
• Computes a matter value tier: Using keyword and dollar-amount signals found in the case description—and whether company enrichment exists—the workflow assigns a value tier.
• Logs to Google Sheets: It appends lead details, enrichment fields, and the computed value tier to a Google Sheet named “Enrichment Log”.
• Sends attorney briefing: It generates an HTML/text briefing and uses Execute Workflow to log the briefing to a guardrail/compliance workflow, then emails it to the configured attorney email address.
• Runs weekly for quality reporting: 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.

Use cases

• Legal intake teams that need fast, consistent lead enrichment before attorney review.
• SaaS operators managing lead pipelines who want Google Sheets tracking and value-tier reporting.
• Automation engineers deploying a webhook-to-briefing flow with scheduled performance summaries.

Technical details

• n8n nodes: webhook, if, code, http request, email send, sticky note, Execute Workflow.
• Config: Set ENRICHMENT_API_URL (and optional CONSUMER_EMAIL_DOMAINS and HIGH_VALUE_KEYWORDS).
• Authentication: Provide an HTTP header auth credential for the enrichment API.