AI CRM Lead Engine: Google Maps → Sheets → Auto-Email
Built a fully automated B2B lead engine: scraped Google Maps + websites + Instagram, enriched each lead with AI-written hooks, stored in Google Sheets CRM, and sent personalised emails with 3-step follow-ups. Generated 2,400 fresh leads & 47 booked demos in the first 30 days.
The Challenge
The client — a B2B SaaS company — was spending 40+ hours per week manually searching Google Maps, copying contact details into spreadsheets, and sending generic cold emails. Their sales team was burning time on data entry instead of closing deals, and their response rates were under 1%.
What We Built
We built an end-to-end automated lead engine using n8n. The workflow scrapes Google Maps for targeted business categories in specific cities, extracts websites and Instagram profiles, enriches each lead with OpenAI-generated personalised hooks based on their business profile, pushes structured data into a Google Sheets CRM, and triggers a 3-step personalised email sequence via Gmail API — automatically.
How It Works
The client's sales team was stuck in a painful loop: spend hours finding leads on Google Maps, manually copy contact info, write personalised emails one by one, then follow up manually days later. At best, this generated 200–300 leads a month — not nearly enough to fill the pipeline.
We redesigned the entire process as an n8n workflow. It starts by querying the Google Maps API for businesses matching specific criteria — industry type, location, minimum rating, and review count as a proxy for legitimacy. For each business, it extracts the website URL and Instagram handle from the Maps listing and then scrapes the site to pull a one-line business description.
This data feeds into OpenAI GPT-4, which writes a personalised first-line hook for each lead — referencing something specific about their business. The enriched data (company name, contact, personalised hook, website, Instagram) lands in a structured Google Sheets CRM where the sales team has full visibility.
The Gmail API then triggers the email sequence: personalised email Day 1, value-add follow-up Day 3, light bump Day 7. Every reply automatically pauses the sequence for that lead. The result: 2,400 leads scraped, enriched, and emailed in the first 30 days — 47 of which booked discovery calls.
