Google Maps to Airtable lead scraper with GPT contact extraction from impressum

How it Works This workflow automates the process of discovering companies in different cities, extracting their contact data, and storing it in Airtable.

1. City Loop (Airtable → Google Maps API) - Reads a list of cities from Airtable. - Uses each city combined with a search term (e.g., SEO Agency, Berlin) to query Google Maps. - Marks processed cities as “checked” to allow safe restarts if interrupted.

2. Business Discovery & Deduplication - Searches for businesses via Google Maps Text Search. - Checks Airtable to avoid scraping the same company multiple times. - Fetches detailed info for each business via Google Maps Place Details API.

3. Impressum Extraction (Website → HTML Parsing) - Builds an Impressum page URL for each business. - Requests the HTML and cleans out ads, headers, footers, etc. - Extracts relevant contact info using an AI extractor (OpenAI node).

4. Contact Information Extraction - Pulls out: - Decision Maker (Name + Position in one string, if available). - Email address (must be valid, containing @). - Phone number (international format if possible). - Filters out incomplete results (e.g., empty email).

5. Database Storage - Writes company data back into Airtable: - Company name - Address - Website - Email - Phone number - Decision Maker (Name + Position) - Search term & city used

---

Setup Steps