Automating Lead Capture with n8n — Zegzouti Abdessalam

The Problem

A digital marketing agency was manually copying leads from Facebook Ads, Google Ads, and their website contact form into a Google Sheet. Then they'd manually send a welcome email, assign a sales rep, and follow up 3 days later.

This process took 20+ hours per week and had a 15% error rate — leads were falling through the cracks.

The Solution: n8n Workflow Automation

I built a multi-step automation using n8n (an open-source alternative to Zapier/Make) that handles the entire lead lifecycle.

Workflow 1: Lead Ingestion

Facebook Lead Ad ─┐
                  ├─→ Google Sheets (log) ─→ Gmail (welcome email)
Google Ads Lead ──┤                           ─→ Slack (notification)
                  │                           ─→ CRM (create contact)
Website Form ────┘

Triggers:

Facebook Lead Ads webhook
Google Ads API (polling every 5 minutes)
Website form submission (HTTP webhook)

Actions:

Log to Google Sheet with timestamp + source
Send personalized welcome email (with source-specific template)
Notify sales team in Slack with lead details
Create contact in CRM with lead score

Workflow 2: Follow-up Automation

Wait 3 days ─→ Check if lead replied ─→ No: Send follow-up email
                                     ─→ Yes: Notify sales to close

Logic:

Wait exactly 3 business days
Check CRM for any activity from the lead
If no response: Send a personalized follow-up
If response detected: Alert the assigned sales rep

Workflow 3: Lead Scoring

Each lead gets scored based on:

Source (website form = +10, Facebook = +5, Google Ads = +8)
Budget mentioned (over $5k = +15)
Timeline (urgent = +10)
Company size (50+ employees = +10)

Leads scoring 30+ go directly to the senior sales team.

The Tech Stack

n8n — Workflow automation (self-hosted on a $5/mo VPS)
Google Sheets — Lead database
Gmail API — Email sending
Slack — Team notifications
CRM API — Contact management
Webhooks — Real-time trigger connections

Results

Cost Savings

Labor: Saved ~$2,400/month (20 hours × $30/hr equivalent)
Tool costs: $5/month (VPS for n8n) vs $49/month (Zapier equivalent)
Lost leads recovered: ~$8,000/month in potential revenue

Key Lessons

1. Start with the manual pain points — The biggest ROI comes from automating the most tedious tasks first.

2. Self-host when possible — n8n self-hosted costs $5/month vs $50-200/month for SaaS alternatives.

3. Add error handling — Every workflow needs fallback paths for API failures.

4. Log everything — You can't optimize what you can't measure. Log every step.

"The automation paid for itself in the first week. We stopped losing leads and the team can focus on closing deals instead of data entry." — Agency Owner