How I Automated Lead Follow-Up for Local Businesses with n8n + AI (Full Workflow)

A local party rental company told me they were losing 40% of their leads because they took too long to reply. Turns out, if you don't respond within 5 minutes, you're 21x less likely to qualify that lead (MIT/InsideSales study).

So I built an n8n workflow that handles the entire client pipeline — from first contact to Google review — with zero manual work.

The Problem

Most local businesses have this exact flow:

1. Lead fills out contact form
2. Email sits in inbox for hours (or days)
3. Owner finally replies with a generic "thanks for reaching out"
4. No follow-up
5. No review request after service
6. Repeat, lose money

The business thinks they need more leads. What they actually need is to stop losing the leads they already have.

What the Workflow Does

Three automated flows, one n8n template:

FLOW 1: Lead → AI Qualify → Instant Reply + CRM + Team Alert
FLOW 2: Daily Check → Overdue Leads → AI Follow-Up Email
FLOW 3: Weekly Check → Completed Clients → Review Request

Flow 1: Lead Capture + AI-Powered Instant Response

When someone submits a contact form (via webhook), the workflow:

1. Normalizes the data — handles any form format (Typeform, Calendly, Jotform, custom HTML)
2. Sends to GPT-4o-mini with a qualification prompt
3. Gets back structured data:

{
  "score": 8,
  "intent": "booking",
  "urgency": "high",
  "suggested_reply": "Thanks for reaching out about your daughter's birthday party! We have great options for groups of 20 kids, and April 15th looks open...",
  "follow_up_delay_hours": 24
}

1. Sends a personalized reply — not a generic "we'll get back to you", but an AI-crafted response that directly addresses what they asked about
2. Saves to Google Sheets — instant CRM with score, intent, urgency, and status tracking
3. Alerts the team on Slack with full lead details and score

Total time from form submission to reply in their inbox: under 10 seconds.

Flow 2: Smart Follow-Up Sequences

Every morning at 10 AM, the workflow:

1. Reads all leads from Google Sheets
2. Filters for leads that haven't responded after the AI-recommended delay
3. GPT-4o-mini writes a warm, personalized follow-up that references their original inquiry
4. Sends the email automatically

The follow-up isn't pushy. It's not "JUST CHECKING IN!!!". It sounds like this:

Hi Sarah, I wanted to circle back about the birthday party setup you asked about for April 15th. We still have that date available if you're interested. Happy to answer any questions about our packages.

Flow 3: Automated Review Collection

Every Monday:

1. Checks for clients who completed service 3-30 days ago
2. Sends a clean review request email with a direct link to their Google Business page
3. Marks the client as "review requested" to prevent duplicates

This alone can transform a local business's online presence. Most happy customers want to leave a review — they just need to be asked.

The AI Qualification Prompt

This is the core of the system. Here's the actual prompt:

You are a lead qualification assistant for a local service business.

Lead info:
Name: {{ name }}
Message: {{ message }}
Source: {{ source }}

Respond with ONLY a JSON object:
{
  "score": <1-10>,
  "intent": "<booking|question|price_check|spam>",
  "urgency": "<high|medium|low>",
  "suggested_reply": "<personalized 2-3 sentence reply>",
  "follow_up_delay_hours": <24|48|72>
}

Score guide: 8-10 = ready to buy, 5-7 = interested, 1-4 = cold/spam.

The key is the suggested_reply field. Instead of a template, every lead gets a response that feels human and specific to their inquiry.

Why Google Sheets as a CRM?

For most local businesses, a full CRM is overkill. Google Sheets gives you:

• Free
• Shareable with the team
• Easy to filter and sort
• Works on mobile
• No learning curve

The workflow auto-populates columns: name, email, phone, message, source, score, intent, urgency, status, received_at. You can filter by score to focus on hot leads first.

Cost Breakdown

Component	Cost
AI qualification	~$0.002/lead
AI follow-up	~$0.001/email
n8n (self-hosted)	Free
Google Sheets	Free
Gmail	Free
100 leads/month	~$0.30/month

For thirty cents a month, you get instant response, smart follow-up, and review automation. Compare that to the $200-500/month most businesses pay for CRM tools that still require manual work.

Setup: 5 Minutes

1. Import the JSON into n8n
2. Add credentials: OpenAI, Gmail, Google Sheets, Slack (optional)
3. Set environment variables: business email, sheet ID, review link
4. Connect your form's webhook to the n8n URL
5. Activate

Real Results

The party rental company I mentioned at the start? After implementing this:

• Response time went from 4 hours average to under 10 seconds
• Lead-to-booking rate increased 35%
• Google reviews went from 12 to 47 in two months
• Owner saved ~8 hours/week on email

Who Should Use This

• Local service businesses: contractors, cleaners, salons, event companies, photographers
• Agencies: managing lead response for multiple clients
• Anyone where speed of response directly impacts revenue

If you're manually replying to leads, you're leaving money on the table. Every minute of delay costs you conversions.

---

I packaged this workflow as a ready-to-import n8n template. You can grab it here: AI Client Pipeline on Gumroad (€39 — one-time, includes the full workflow JSON + setup guide).

If you want to build something similar yourself, the architecture above should give you everything you need. The AI qualification prompt is the secret sauce — experiment with it for your specific industry.

Questions? Drop them in the comments or hit me up at [e-mail].