Automation: Build an AI-Powered Lead Follow-Up System

What This Builds

An automated system that fires within 5 minutes of a new lead coming in. generating a personalized, AI-written follow-up email and sending it via Gmail. Instead of new leads sitting in your inbox for hours while you're on a job site, they get a professional response immediately. You only see the conversation when they reply.

Prerequisites

• Comfortable using ChatGPT for writing tasks (Level 3)
• A Gmail or Google Workspace account for business email
• A Zapier account (free tier works for basic automation; paid from $20/mo for more steps)
• An OpenAI account with API access (separate from ChatGPT, sign up at platform.openai.com)
• A lead source: either a website contact form (Google Forms, Gravity Forms, Jotform) or a lead aggregator that supports webhooks (some Angi/HomeAdvisor integrations exist)
• Time to build: 1-2 hours
• Cost: Zapier free (or $20+/mo), OpenAI API ($5-15/mo depending on volume)

The Concept

Think of this like having a receptionist who works 24 hours a day and never misses a lead. When someone fills out your contact form at 9pm on a Sunday, this system sends them a personalized email within 5 minutes, while your competitor responds Monday morning. Research shows the contractor who responds within 5 minutes is 9x more likely to win the job than one who responds after an hour. This builds that advantage automatically.

Build It Step by Step

Part 1: Set Up Your Lead Capture Form

If you already have a website contact form that sends data somewhere, skip to Part 2.

Option A. Google Form (free, easiest):

1. Go to forms.google.com → create a new form
2. Add fields: Name, Email, Phone, Project Type (dropdown: Kitchen / Bathroom / Addition / Deck / Other), Brief Description, Timeline (dropdown: ASAP / 1-3 months / 3-6 months / Just planning)
3. Go to form Settings → Responses → make sure responses go to a Google Sheet
4. Share the form URL on your website's "Get a Free Estimate" page

Option B. Your existing website form: If your form already emails you or stores in a database, note the format, you'll use it in Step 2.

Part 2: Connect Your Form to Zapier

1. Go to zapier.com → click Create Zap
2. Trigger step: Search for Google Forms (or your form provider)
3. Choose trigger event: New Form Response
4. Connect your Google account and select your estimate request form
5. Click Test trigger. Zapier will pull in a sample response so you can see the field names

What you should see: A sample response appears with all your form fields: name, email, project type, description, timeline.

Part 3: Add the OpenAI / ChatGPT Step

This step uses OpenAI's API to generate the personalized email. You'll need an API key:

1. Go to platform.openai.com → sign up → click your profile → API Keys → Create new secret key
2. Copy the key (you'll only see it once)

Back in Zapier:

1. Click the + to add a step → search OpenAI (ChatGPT)
2. Choose action: Send prompt
3. Connect your OpenAI account (paste the API key)
4. In the Prompt field, write:

You are an assistant for [Company Name], a residential remodeling company in [City, State].

A new lead just came in. Write a brief, professional email responding to their inquiry.
Be warm and local — not corporate. Keep it under 150 words.

Lead details:
- Name: {{Name}}
- Project type: {{Project Type}}
- Description: {{Brief Description}}
- Timeline: {{Timeline}}

Email should:
1. Thank them for reaching out
2. Confirm we received their request for a [project type]
3. Tell them we'll call within [24 hours / same business day] to schedule a free site visit
4. Give them our phone number: [your number]
5. Sign off with our name and company

Do not mention pricing. Focus on making them feel heard and excited to work with us.

Replace the {{fields}} with Zapier's actual field references by clicking inside the field and using the Insert Data option to select the form fields.

1. Set Model: GPT-4o-mini (cheaper, fast, plenty capable for emails)

What you should see: A preview of the AI-generated email text using your sample lead data.

Part 4: Send the Email via Gmail

Add another step:

1. Click + → search Gmail
2. Action: Send Email
3. Connect your Gmail account
4. Fill in:

• To: {{Email}} (the lead's email from the form)
• Subject: "Re: Your remodeling inquiry: [Company Name]"
• Body: {{OpenAI response text}} (the output from Step 3)
• From name: Your name or company name

Part 5: Test the Full Automation

1. Submit a test entry in your Google Form using your own email
2. Go to Zapier → Run Zap to trigger manually
3. Check your inbox. the AI-generated email should arrive within 1-2 minutes

What you should see: A personalized email that reads naturally and references the specific project type they mentioned.

Troubleshooting:

• Email didn't send → check Gmail connection in Zapier (may need to re-authorize)
• Email feels generic → edit the prompt in Step 3 to add more personality or specificity
• API key error → regenerate at platform.openai.com

Real Example: Residential Addition Lead

Setup: Google Form connected to Zapier → OpenAI → Gmail. Form has fields for name, email, project type, description, timeline.

Input (form submission):

• Name: Jennifer Walsh
• Project type: Addition
• Description: "Looking to add a 400 sq ft family room off the back of our house"
• Timeline: 3-6 months

Output (automated email, sent 3 minutes later):

Time saved: You were on a job site when this came in. Jennifer got a response in 3 minutes. Your competitor responded at 7am the next morning.

What to Do When It Breaks

• Form submission not triggering Zapier → Log into Zapier → check the Zap history for error messages; re-connect the Google Forms integration
• OpenAI returning an error → Check your API key is active at platform.openai.com; check your account has billing set up (the API is not free, but costs pennies per email)
• Email going to spam → Use a business domain email address, not a personal Gmail; add SPF/DKIM records if you have a custom domain
• Email sounds wrong → Edit the prompt in the OpenAI step; test by manually running the Zap with sample data

Variations

• Simpler version: Skip OpenAI entirely. Use Gmail's Zapier step to send a fixed template email to every lead. Less personalized, but zero AI setup required.
• Extended version: Add a 4th step. log every lead into a Google Sheet (Name, Email, Project Type, Date Received, Status) for tracking. Add a 5th step to text yourself via Twilio when a high-value project type (addition, full kitchen) comes in.

What to Do Next

• This week: Submit 5 test leads and review the AI-generated emails for quality
• This month: Track your response-time-to-first-contact before and after the automation. most contractors see a 2-3x improvement in lead response speed
• Advanced: Add a follow-up step, if the lead hasn't responded in 3 days, Zapier sends a second AI-generated follow-up automatically

Advanced guide for remodeling estimator professionals. These techniques use AI API access and automation tools that require paid subscriptions.