Automated lead extraction and AI enrichment from Google

This workflow automatically collects business data from Google Maps based on custom search queries, enriches it using AI, and stores structured results in Google Sheets. Ideal for building lead databases, market research, and personalized B2B outreach campaigns.

## Who it´s for
- Lead generation agencies needing automated business data collection
- Marketers focused on local SEO and competitor analysis
- B2B outreach specialists building targeted lead lists
- Market researchers exploring regional niches
- Freelancers and automation consultants offering data scraping services

## What the automation does
- Runs on a scheduled trigger (cron)
- Fetches search queries from Google Sheets
- Searches Google Maps and extracts company website URLs
- Filters irrelevant domains and removes duplicates
- Checks URLs against existing entries to avoid redundancy
- Uses APIFY and an AI agent (Gemini via OpenRouter) to extract structured business data
- Saves enriched data — including contacts, descriptions, categories, and AI insights — to Google Sheets

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on cron_schedule
- Integrations with Google Sheets, Google Maps (via HTML scraping), APIFY, and OpenRouter (Gemini)
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Google Sheets access with edit permissions
- APIFY account with active credit balance
- OpenRouter API key for Gemini access
- Basic understanding of JavaScript and API usage

## Benefits and outcomes
- Saves time on manual data collection
- Enables scalable lead database creation with AI-powered insights
- Supports recurring data updates via scheduler
- Enhances personalization in outreach through deep website analysis
- Flexible targeting by location and niche
- Simplifies competitor benchmarking and market opportunity mapping

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.