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

Description

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!