Lead form → Google Sheet → welcome email → Slack alert
For consultants, agencies, and high-intent service businesses
Problem
Inbound leads vanish when form notifications sit in an inbox, manual spreadsheet updates lag, and sales only finds out hours later.
Workflow summary
- 1Catch every submitted lead through an n8n webhook.
- 2Normalize name, email, company, source, budget, and urgency fields.
- 3Append the clean lead row to Google Sheets for tracking.
- 4Send a branded welcome email with next steps and booking link.
- 5Post a Slack alert with qualification context for fast follow-up.
Output
n8n JSON preview
Trigger
POST /webhook/new-lead
{
"name": "Lead Capture Revenue Desk",
"nodes": [
{ "name": "New Lead Webhook", "type": "n8n-nodes-base.webhook" },
{ "name": "Normalize Lead Fields", "type": "n8n-nodes-base.set" },
{ "name": "Append Lead to Sheet", "type": "n8n-nodes-base.googleSheets" },
{ "name": "Send Welcome Email", "type": "n8n-nodes-base.gmail" },
{ "name": "Alert Sales in Slack", "type": "n8n-nodes-base.slack" }
],
"connections": {
"New Lead Webhook": ["Normalize Lead Fields"],
"Normalize Lead Fields": ["Append Lead to Sheet", "Send Welcome Email"],
"Append Lead to Sheet": ["Alert Sales in Slack"]
}
}