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!