π€ AI-Powered Lead Generation System
n8n + Google Maps + Gemini AI Agent + Gmail Automation
(End-to-End, Private Client)
Built a complete AI-powered lead generation system for a private
client β from a single form submission to qualified prospects,
personalized outreach, and automated reporting. No manual steps.
β‘ THE PIPELINE (10 STEPS):
1οΈβ£ π Web form submission triggers the entire workflow
2οΈβ£ πΊοΈ Google Maps API discovers relevant businesses automatically
3οΈβ£ π Website scraper extracts live company information
4οΈβ£ π« Duplicate detection removes repeated or known prospects
5οΈβ£ βοΈ Business logic qualifies and scores each lead before
any AI call is made
6οΈβ£ πΎ Qualified leads stored in Google Sheets with full
state tracking
7οΈβ£ π Website research fetches real company context
for enrichment
8οΈβ£ β¨ Google Gemini AI Agent generates context-aware,
personalized outreach emails
9οΈβ£ βοΈ Gmail sends each email automatically after
content validation
π π Completion report is built and emailed to the
client after every run
π‘ DESIGN DECISIONS WORTH NOTING:
π§ AI runs after business logic, not before it (fewer API calls, lower cost, more predictable output)
π Every lead state is recorded in Sheets β nothing is silently dropped
π Fallback branches handle missing websites and emails
This is the kind of AI workflow that gets me excited as an independent developer.
Faster ideation, faster prototyping, and more room to focus on turning ideas into real products. π
For this one, I focused on local restaurants in New York and automated the process of collecting their business information from Google Maps.
The workflow pulls things like:
Restaurant name
Website
Business category
Instead of manually searching Google Maps, opening businesses one by one, and copying their details into a spreadsheet, the workflow handles the repetitive part automatically and saves the leads directly into Google Sheets.
This is just one use case. The same setup can be adapted for different locations, industries, and lead-generation needs.
AI-powered financial analytics platform built with FastAPI, Pandas, DuckDB, and Gemini API for data analysis, REST APIs, natural-language-to-SQL queries, and automated business insights.