Enrich legal leads and send attorney briefings with webhooks and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 17 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Parse Incoming Lead Data (Code): runs custom JavaScript code
- Read Weekly Enrichment Sheet (Google Sheets): read
- Extract Company Domain From Email (Code): runs custom JavaScript code
- Compute Weekly Lead Summary (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Build Weekly Summary Email (Code): runs custom JavaScript code
- Fetch Company Enrichment Info (HTTP Request): calls an HTTP API (GET)
- Note Missing Company Signal (Code): runs custom JavaScript code
- Send Weekly Summary Email (Send Email): sends an email over SMTP
- Parse Company Enrichment Data (Code): runs custom JavaScript code
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - Send Email
n8n-nodes-base.emailSend - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
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…