n8n Google Maps Automation - Extraction, Email & WhatsApp

Full Google Maps Scraper → Google Sheets (name, phone, emails, WhatsApp, website, address) + Automatic Email Sending + Optional WhatsApp Scheduling

Project Overview
We are looking for a developer to create a long-term, stealthy and robust automation system that can:

Read search keywords from a Google Sheet

Search each keyword on Google Maps

Extract full contact details from each business

Save the results into another Google Sheet

Automatically send a commercial email via Gmail

Optionally schedule a WhatsApp message

Update the contact status in the spreadsheet

This automation must not use any third-party tools like Zapier, Apify, Phantombuster, etc.
It must be built to avoid bans, blocks or detection from Google systems. Stability and sustainability are critical.

Input
Source: Google Sheets file (1 search keyword per row)

Google Maps Scraping (no official API)
For each keyword, the script must perform a Google Maps search and extract the following mandatory fields from each business listing:

Required Data to Extract per Business:
Business Name

Phone Number

WhatsApp Number (if listed or can be inferred from mobile format)

Address

Website

Primary Email

All other visible emails (from business site, description, public sources)

If any data is missing, it should be marked as not available.

Output
All results must be saved in a Google Sheet with the following columns:

| Keyword | Business Name | Phone | WhatsApp | Address | Website | Primary Email | Other Emails | Status | Contacted Date | Notes | country | city

Commercial Email Automation
If an email is available, the system should send a commercial proposal automatically.

Email body will use a customizable template.

Emails must be sent from Gmail (via Google Apps Script or API).

After sending, the Status field in the Google Sheet must update to contacted by email.

WhatsApp Message (Optional & Scheduled)
Include columns like Send WhatsApp (Yes/No) and Schedule Time

If WhatsApp is marked “Yes”:

The script should open WhatsApp Web (via Selenium)

Send a customizable message using fields like business name, location, etc.

If “No”, skip sending.

Anti-Detection Requirements
This system must run stealthily and without triggering Google bans. It should include:

Randomized user agents

Human-like delays and navigation

Scroll simulation

CAPTCHA detection handling

Proxy usage (if needed)

Configurable scraping rate

Deliverables
Python scripts for scraping and sending to Google Sheets

Google Apps Script for Gmail automation

Selenium script for WhatsApp Web messaging (optional)

Sample run with 3 keywords

All documentation and credentials setup

Required Skills
Python (Selenium or Playwright + stealth scraping techniques)

Deep web scraping experience (Google Maps + external business websites)

Google Sheets API

Google Apps Script (for Gmail)

WhatsApp Web automation (bonus)

What to include in your proposal:
Your proposed technical solution (especially how you will prevent detection)

Portfolio of similar scraping or automation projects

Estimated time to deliver the full system

Fixed budget or milestone proposal