Skip to content
NEWError doctor and Watchtower: failed n8n runs explained in plain words, and emailed to you. See what is new

Library / Lead Generation & Enrichment

Lead Generation & Enrichment

Extract Google Maps Business Contacts with Apify and GPT

When you run it, Apify scrapes Google Maps businesses, OpenAI extracts emails, phones and websites from their pages and the contacts are saved to Airtable.

What it does

What if you could extract every email, phone number, and website from a specific area in just a few clicks? In this workflow, we’ll scrape Google Maps and automatically organize the data into an Airtable base. We’ll use real estate in Paris as an example, but it works for any business — from local therapists to inflatable pool dealers. ## Step 1 – Launch the Google Maps Scraper Start with a When clicking Execute workflow trigger to launch the flow manually. Then, add an HTTP Request node with the method set to POST. 👉 Head over to Apify: Google Maps Extractor On the page: https://apify.com/compass/google-maps-extractor Enter your business keyword (e.g., real estate agency, hairdresser, restaurant) Set the location you want to target (e.g., Paris, France) Choose how many results to fetch (e.g., 50) Optionally, use filters (only places with a website, by category, etc.) ⚠️ No matter your industry, this works — just adapt the keyword and location. Once everything is filled in: Click Run to test. Then, go to the top right → click on API. Select the API endpoints tab. Choose Run Actor synchronously and get dataset items. Copy the URL and paste it into your HTTP Request (in the URL field). Then enable: ✅ Body Content Type → JSON ✅ Specify Body Using JSON Go back to Apify, click on the JSON tab, copy the entire code, and paste it into the JSON body field of your HTTP Request. At this point, if you run your workflow, you should see a structured output similar to this: title subTitle price categoryName address neighborhood street city postalCode ........

The steps

  1. Fetch Business Data from Google Maps (Apify)
  2. Clean Google Maps Data
  3. Manual Workflow Execution
  4. Iterate Through Each Business Contact
  5. Extract Only Website URLs
  6. Fetch Raw HTML Content from Business Website
  7. Extract Business Email from Website HTML (GPT-4)
  8. Save Cleaned Lead Data into Airtable

Similar automations