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!. An n8n automation workflow template by Shreya Bhingarkar.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• google-sheets
• http-request
• code

Capabilities

• 3 nodes
• 2 views

Information