Quick Overview
Quick Overview This workflow receives new leads via webhook, enriches business-domain emails using a configurable enrichment API, logs results to Google Sheets, and emails an internal briefing to an attorney, plus a weekly scheduled email summary of lead value tiers and top companies. How it works Receives a new lead via a webhook and normalizes key fields like name, email, phone, practice area, and case description. Extracts the email domain, determines whether it is a business domain, and either calls an external enrichment API for company details or records that no company signal is available. Computes a “matter value tier” using keyword and dollar-amount signals from the case description and the presence of company enrichment data. Appends the lead, enrichment fields, and value tier to a Google Sheets “Enrichment Log” for tracking. Builds an HTML/text briefing, logs the briefing to a separate guardrail/compliance workflow via Execute Workflow, and sends the briefing to the configured attorney email address. Runs weekly on a schedule, reads the Google Sheets enrichment log, aggregates the last N days into tier counts and top companies, and emails a weekly lead quality summary. Setup Configure your lead source to POST to the workflow’s webhook URL for the “lead-enrichment” endpoint. Set n8n variables for ENRICHMENT_API_URL (and optional CONSUMER_EMAIL_DOMAINS and HIGH_VALUE_KEYWORDS) and provide an HTTP Header Auth credential for your enrichment provider. Connect Google Sheets credentials and set ENRICHMENT_LOG_SHEET_ID, ensuring the “Enrichment Log” sheet has columns matching the fields being appended. Connect an SMTP email credential and set FIRM_FROM_EMAIL plus the recipient variables (INTAKE_ATTORNEY_EMAIL and/or FIRM_EMAIL) used for the briefing and weekly summary. Set GUARDRAIL_WORKFLOW_ID to the internal audit workflow (or update/remove the Execute Workflow step) and adjust the weekly cron schedule and LEAD_SUMMARY_LOOKBACK_DAYS as needed. An n8n automation workflow template by Dele Tosh @ Protomated.
Dele Tosh @ Protomated
web
free
Others in the same category, ranked by how often they are opened.
