Google Maps Lead Scraper to Airtable with GPT Impressum Extraction

This workflow automates lead generation by querying Google Maps for businesses in specified cities (e.g., SEO agencies in Berlin), fetching detailed place data, and checking Airtable for duplicates to avoid redundant scraping. It then constructs Impressum URLs, scrapes website HTML, cleans it, and uses OpenAI GPT to extract key contacts like decision maker names/positions, valid emails, and phone numbers, filtering out incomplete results.

Benefits include massive time savings on manual lead research, high accuracy via AI extraction from legal Impressum pages (common in German/EU sites), and safe restarts with city status tracking. Ideal for sales teams building targeted outreach lists without hiring scrapers.

Use cases: Generate leads for agencies targeting local businesses, populate CRMs with verified contacts, or scale prospecting across cities/countries. Integrates Google Maps APIs, Airtable for storage/tracking, and GPT for intelligent parsing, making it robust for production use.