Google Maps Email Lead Scraper Automation

Project Type: Personal project
Tools Used: n8n, Google Sheets, HTTP Request, JavaScript

Project Overview

I built an n8n workflow that automates the collection, processing, cleaning, and storage of business email leads. The workflow reduces repetitive research and data-entry work by sending qualified email records directly to Google Sheets.

The Problem

Manually searching for business contact information, checking email records, removing duplicates, and transferring results into a spreadsheet can take a significant amount of time.

My Solution

I created an automated workflow that:

• Processes multiple search inputs
• Sends HTTP requests to collect business data
• Uses JavaScript to extract and clean information
• Adds wait steps to control request timing
• Filters unusual or unusable email records
• Splits and processes collected results
• Removes duplicate email addresses
• Adds the final records to Google Sheets

Workflow Process

Search input → HTTP request → JavaScript processing → Email filtering → Duplicate removal → Google Sheets

Result

The workflow successfully produced a structured list of business email addresses in Google Sheets. It demonstrates my ability to build multi-step n8n workflows, process web data, apply filtering rules, remove duplicate records, and connect automation results to a spreadsheet.

Skills Demonstrated

• n8n workflow development
• Lead-generation automation
• HTTP requests
• Basic JavaScript
• Data extraction and cleaning
• Email filtering
• Duplicate removal
• Google Sheets integration
• Workflow testing and troubleshooting