Workflow Link - https://drive.google.com/drive/folders/1DRJLZ1YcqxV620cuEiM102gbdPL-uVQU?usp=drive_link

🚀 AI Lead Generation + Website Audit + Email Automation Bot

Complete Setup Guide

Turn prospects into clients automatically while they sleep!

System Overview: Find businesses → Audit their websites → Send personalized outreach emails → All 100% automated

🔧 What This System Does

This powerful automation:

  • Finds potential clients using Google search + SerpAPI
  • Audits their websites automatically (performance, SEO, security)
  • Finds email addresses using Hunter.io
  • Generates personalized emails with AI based on specific website issues
  • Sends targeted outreach automatically via MailerSend
  • Tracks everything in Google Sheets CRM

Result: Wake up to qualified leads with personalized outreach already sent!

📊 System Flow Overview

Node #

Node Name

What It Does

1️⃣

Daily Trigger

Starts automation every day at 9 AM

2️⃣

Initialize CRM Entry

Creates new tracking entry in Google Sheets

3️⃣

SerpAPI Lead Scraper

Searches Google for target businesses (dentists, lawyers, etc.)

4️⃣

Extract Business Leads

Filters and formats business information

5️⃣

Save Leads to CRM

Stores leads in Google Sheets database

6️⃣

Check If New Lead

Prevents duplicate processing

7️⃣

Mark Processing

Updates status to "Processing"

8️⃣

Wait 3s

Rate limiting for APIs

9️⃣

Hunter Email Finder

Finds email addresses for decision makers

🔟

Clearbit Company Data

Enriches lead data with company info

1️⃣1️⃣

Website Availability Check

Tests if website is accessible

1️⃣2️⃣

Google PageSpeed Audit

Analyzes website performance & SEO

1️⃣3️⃣

Extract Website Data

Scrapes contact info, title tags, etc.

1️⃣4️⃣

Analyze Lead Quality

AI scoring system for lead prioritization

1️⃣5️⃣

Check If Worth Outreach

Filters high-quality leads only

1️⃣6️⃣

Generate Personalized Email

Creates custom email using ChatGPT

1️⃣7️⃣

Send Email via MailerSend

Automatically sends personalized outreach

1️⃣8️⃣

Update CRM with Results

Records all data & results

1️⃣9️⃣

Mark as Analyzed Only

Updates low-quality leads

🛠️ What You Need

Tool

Purpose

Required?

n8n

Automation platform

Yes

Google Sheets

CRM database

Yes

SerpAPI

Google search scraping

Yes

Hunter.io

Email finding

Yes

Clearbit

Company data enrichment

Optional

Google PageSpeed API

Website auditing

Yes

OpenAI API

Email generation

Yes

MailerSend

Email delivery

Yes

🧑‍💻 Step-by-Step Setup Guide

Step 1: Set Up Your n8n Account

  1. Go to n8n.io
  2. Sign up for free account
  3. Choose Cloud or self-hosted option
  4. Access your workflow editor

Step 2: Download & Import Workflow

  1. Download the JSON file from this guide
  2. Open your n8n editor
  3. Click "Import" → "Import from file"
  4. Upload the downloaded JSON file
  5. Click "Save" to import the workflow

Step 3: Set Up Google Sheets CRM

  1. Create new Google Sheets document
  2. Name it "Lead Generation CRM"
  3. Create sheet called "Leads"

Add these column headers:
Timestamp | Name | Website | Status | Source | Found_Date | Description | Email_Address | Performance_Score | SEO_Score | Lead_Score | Critical_Issues | Overall_Grade | Email_Sent_Date | Next_Follow_Up

  2. Get Sheet ID from URL (long string between /d/ and /edit)
  3. Enable Google Sheets API in Google Cloud Console
  4. Create service account and download credentials

Step 4: Get Required API Keys

SerpAPI (Google Search)

  1. Go to serpapi.com
  2. Sign up for account
  3. Get your API key from dashboard
  4. Choose plan based on searches needed

Hunter.io (Email Finding)

  1. Visit hunter.io
  2. Create account
  3. Go to API section
  4. Copy your API key

OpenAI API (Email Generation)

  1. Go to platform.openai.com
  2. Create account and add billing
  3. Generate API key
  4. Keep GPT-3.5 or upgrade to GPT-4

Google PageSpeed API

  1. Go to Google Cloud Console
  2. Enable PageSpeed Insights API
  3. Create API key
  4. No cost for reasonable usage

MailerSend (Email Delivery)

  1. Sign up at mailersend.com
  2. Verify your domain
  3. Get API key from integrations
  4. Free tier: 12,000 emails/month

Clearbit (Optional - Company Data)

  1. Visit clearbit.com
  2. Sign up for account
  3. Get API key from dashboard

Step 5: Configure Workflow Nodes

Update API Keys in Workflow

Replace these placeholders in the JSON:

  • YOUR_GOOGLE_SHEET_ID → Your Google Sheets ID
  • YOUR_SERPAPI_KEY → Your SerpAPI key
  • YOUR_HUNTER_API_KEY → Your Hunter.io key
  • YOUR_CLEARBIT_API_KEY → Your Clearbit key
  • YOUR_GOOGLE_PAGESPEED_API_KEY → Your Google API key
  • YOUR_MAILERSEND_API_KEY → Your MailerSend key

Customize Search Terms

In the SerpAPI Lead Scraper node, modify the search query:

"dentist in delhi site:yelp.com OR site:justdial.com OR site:sulekha.com"

Change to your target:

  • "restaurant in mumbai"
  • "lawyer in bangalore"
  • "gym in pune"
  • etc.

Set Your Email Details

In the Send Email via MailerSend node, update:

  • your-email@yourdomain.com → Your verified sending email
  • Your Name - Web Expert → Your name/company

Step 6: Test Your System

Manual Test Run

  1. Click "Execute Workflow" button
  2. Monitor each node execution
  3. Check for any errors
  4. Verify data appears in Google Sheets
  5. Confirm test email was sent

⚙️ Advanced Configuration

Lead Scoring Algorithm

The system scores leads based on:

  • Performance issues (slow website = +25 points)
  • SEO problems (poor SEO = +25 points)
  • Security issues (no SSL = +30 points)
  • Mobile issues (not mobile-friendly = +20 points)

Leads scoring 50+ points get automatic outreach

Email Personalization

The AI generates emails mentioning:

  • Specific website issues found
  • Business impact of these problems
  • Free audit offer
  • Clear next steps

CRM Tracking

Every lead gets tracked with:

  • Contact information
  • Website audit scores
  • Issues identified
  • Email sent status
  • Follow-up dates

🔧 Troubleshooting Guide

Common Issues

"API Rate Limit Exceeded"

  • Add more wait times between API calls
  • Upgrade API plans for higher limits
  • Process fewer leads per run

"No Email Found"

  • Try alternative email finder tools
  • Manually research high-value prospects
  • Use LinkedIn for contact info

"Emails Going to Spam"

  • Warm up your sending domain
  • Improve email content and formatting
  • Use authenticated sending domain

"Low Response Rates"

  • Improve email personalization
  • Target better quality leads
  • A/B test different email templates

Need Help?

  • Technical Issues: Check n8n community forums
  • API Problems: Contact respective API support
  • Strategy Questions: Join automation communities

Pro Tips

  • Start with one target industry and perfect the system
  • Always provide genuine value in outreach
  • Track metrics and continuously optimize
  • Build relationships, not just send emails

🙏 Thank you for checking out the setup! We’re here to provide you real value with every workflow we share. If you face any issue or have questions, feel free to message us anytime — we’re happy to help! 💬💡 — Team @fullstackrahulji