Generate Google Maps leads with AI enrichment, social discovery and Google Sheets

What it does

This workflow finds local businesses from Google Maps and automatically enriches them with emails, social profiles, AI summaries, and personalized outreach messages — all saved to Google Sheets.

How it works

Searches Google Maps using your custom queries Scrapes each business website for emails and contact info Finds missing social profiles (Instagram, Facebook, LinkedIn, Twitter, TikTok, YouTube) Validates emails and removes invalid ones Uses AI to generate a business summary and services list Writes a personalized outreach message for each lead Scores each lead from 0 to 10 based on digital presence Exports everything clean and organized to Google Sheets

Who it is for

Lead generation agencies Freelancers offering outreach as a service B2B sales and marketing teams Automation consultants

Requirements

Serper API key Google Sheets OAuth Email validation API Ollama or any LLM endpoint

How to set up

Connect your credentials in n8n Add your Google Sheet ID to the Sheets node Add your search queries like "bakery in Ohio" or "gyms in Delhi" Hit run and leads start filling your sheet automatically!