CASE STUDY · AI AUTOMATION

Roofing Lead Generation & Outreach System

A two-workflow n8n system designed to find roofing businesses without websites, maintain a clean lead list, research competitors, generate tailored call openers, place AI calls and update outcomes.

System at a glance

The uploaded workflow files show the exact structure below.

2n8n workflows
5+external services connected
1structured lead database
Workflow 01

Google Maps Lead Scraper

The scraper runs separately in batches to top up the lead list. It searches target cities through Apify, filters for businesses without websites, drops rows without phone numbers, checks existing Google Sheets records and appends only new leads.

  • Target cities are configurable
  • Apify Google Places scraper
  • Filters businesses with no website
  • Requires a usable phone number
  • De-duplicates on Business Name + Phone
  • Writes new leads to a Google Sheet
Target CitiesColumbus · Tulsa · Greenville (editable)
↓
Apify Google PlacesCollect local roofing businesses
↓
Filter + Phone CheckNo website + usable phone
↓
De-duplicateBusiness Name + Phone
↓
Google SheetsAppend new leads
Pick eligible leadFollow-ups first, then fresh leads
↓
Local-time guardOnly calls during 9AM–9PM in the lead's state
↓
Competitor researchSerpAPI → local search context
↓
Tailored openerOpenAI generates a single opening line
↓
Vapi callOutbound AI call + polling
↓
Outcome classificationBooked / Not Interested / Follow-Up / No Answer / Do Not Call
Workflow 02

Master Outreach Orchestrator

The master workflow reads the lead sheet, selects an eligible lead, respects the lead's own local calling hours, researches a competitor, creates a tailored opener, places the Vapi call, polls for completion, classifies the outcome and updates the lead record.

  • Priority to due follow-ups
  • Local state time-zone handling
  • 30-minute wait when outside calling hours
  • 15-minute gap between completed calls
  • Transcript and outcome stored
  • Meeting-booked and attempt-count fields maintained
The source workflow also includes an import note to configure API keys, Sheet ID, search engine settings and Vapi IDs before production use. The case study describes the architecture, not a claim that those credentials are currently configured.

This is the kind of workflow Akin Stack can build around your business.

Bring the current manual process, the tools involved and the result you want.

Discuss an automation on Fiverr ↗