Documentation

How to Use Lead Generator

A comprehensive guide to collecting business data, extracting contacts, and managing leads with Google Sheets

Quick Start
Get started in 3 simple steps
1

Configure API Keys

Go to Settings and add your Google Places API key (required for Google searches) and Google Cloud Service Account credentials.

2

Collect Source Data

Use Google Places or Overpass API to find businesses and their websites.

3

Extract & Enrich

Use the Contact Extractor to find emails or enrich your existing Google Sheets data automatically.

Google Places Search
Official Google data for high-quality business leads

Search Modes

  • Single: Quick lookups for specific keywords + locations.
  • Bulk: Upload CSV/JSON to process multiple queries.
  • Save to Drive: Manually export results to specific sheets.

Key Features

  • Ratings, review counts, and price levels
  • Opening hours and business status
  • Direct links to Google Maps
  • Automatic CSV export for every search
Overpass API (OSM)
Worldwide open data for maximum coverage

Why use Overpass?

  • Free to use (no Google billing required)
  • Excellent coverage in Europe and open regions
  • Filter by deep OSM tags (amenity, shop, tourism)
  • Get precise coordinates only found in OSM

Best Practices

  • Use specific categories and values (e.g., shop=bakery)
  • Limit search area to cities or districts to avoid timeouts
  • Respect the 2 concurrent requests/minute limit
Contact Extractor (NEW)
Deep website scanning for emails and socials

How it works

Our crawler analyzes websites recursively to find:

  • Emails (including anti-spam obfuscation)
  • Phone numbers & WhatsApp links
  • Social media profiles (FB, IG, LinkedIn, etc.)
  • Prioritized scan of 'Contact' and 'About' pages

Dynamic Enrichment

Select a Google Sheet, and the tool will automatically read URLs, find contacts, and update the sheet rows in real-time.

Bulk Query Generator
Mass lead generation for entire regions

Smart Generation

  • Pair multiple cities with multiple industries
  • Persistent query lists (saves in your browser)
  • Google Places API types integration
  • Export for Google or Overpass search tools

Scaling Up

Generate thousands of queries for a whole country and use the Bulk Search feature to process them automatically.

Settings & Integration
Customize your workflow

Google Drive & Sheets

  • Configure specific folder for exported files
  • Manual Save to Drive for better organization
  • Master Schema ensures consistent data structure
  • Real-time sheet updates during Enrichment

Personalization

  • Customize visible columns per tool
  • Dark Mode and UI scale preferences
  • Multi-language support (EN, DE, HU, TH)
  • Secure browser-side storage for API keys
Tips & Best Practices

🎯 Be Specific

Use specific keywords and locations for better results. "Italian restaurant in Budapest V. kerület" is better than just "restaurant".

âš¡ Workflow Strategy

1. Use **Bulk Generator** to create queries. 2. Use **Google Search** to find businesses. 3. Use **Contact Extractor** (Enrichment) to find their personal contact info directly in your Google Sheet.

📅 Regular Exports

While data persists during your session, use the **Save to Drive** feature or download CSVs to ensure your leads are stored permanently in your cloud storage.

Need help? Check the Settings page or review your tool options.