Scrape Google Maps Leads (Email, Phone, Website) using Apify + GPT + Airtable
    100%
    Automation
    0(0 reviews)
    540 downloads

    Scrape Google Maps Leads (Email, Phone, Website) using Apify + GPT + Airtable

    NM

    Curated by n8n Markets team

    Last updated: September 7, 2026

    ### Who is it for? This workflow is for marketers, sales teams, and local businesses who want to quickly collect leads (business name, phone, website, and email) from Google Maps and store them in Airtable. You can use it for real estate agents, restaurants, therapists, or any local niche. If you need a professional automation agency to build advanced lead generation systems like this, check out [Vision IA's n8n automation services](https://visionia.io/agence-n8n). --- ## How it works 1. Scrape Google Maps with [Apify Google Maps Extractor](https://apify.com/compass/google-maps-extractor). 2. Clean and structure the data (name, address, phone, website). 3. Visit each website and retrieve the raw HTML. 4. Use GPT to extract the most relevant email from the site content. 5. Save everything to Airtable for easy filtering and future outreach. It works for any location or keyword – just adapt the input in Apify. --- ## Requirements Before running this workflow, you’ll need: - ✅ Apify account (to use the Google Maps Extractor) - ✅ OpenAI API key (for GPT email extraction) - ✅ Airtable account & base with the following fields: - `Business Name` - `Address` - `Website` - `Phone Number` - `Email` - `Google Maps URL` --- ## Airtable Structure Your Airtable base should contain these columns: ## Airtable Structure | Title | Street | Website | Phone Number | Email | URL | |-------------------------|-------------------------|--------------------|-----------------|------------------------|----------------------| | Paris Real Estate Agency| 10 Rue de Rivoli, Paris | https://agency.fr | +33 1 23 45 67 | contact@agency.fr | maps.google.com/... | | Example Business 2 | 25 Avenue de l’Opéra | https://example.fr | +33 1 98 76 54 | info@example.fr | maps.google.com/... | | Example Business 3 | 8 Boulevard Haussmann | https://demo.fr | +33 1 11 22 33 | contact@demo.fr | maps.google.com/... | --- ## Error Handling - Missing websites: If a business has no website, the flow skips the scraping step. - No email found: GPT returns `Null` if no email is detected. - API rate limits: Add a `Wait` node between requests to avoid Apify/OpenAI throttling. ![baptistefortleadslocalgooglemapsn8n.png](fileId:1692) Now let’s take a detailed look at how to set up this automation, using real estate agencies in Paris as an example. ## 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 ![baptistefortrecupererleadsn8ngooglemaps.png](fileId:1695) On the page: [https://apify.com/compass/google-maps-extractor](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. ![baptistefortscrapergooglemapsn8nleads.png](fileId:1701) 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. ![baptistefortn8nemailtelephonegooglemaps.png](fileId:1694) 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 ........ ## Step 2 – Clean and structure the data ![baptistefortworkflowleadsn8n.png](fileId:1698) Once the raw data is fetched from Apify, we clean it up using the Edit Fields node. In this step, we manually select and rename the fields we want to keep: Title → {{ $json.title }} Address → {{ $json.address }} Website → {{ $json.website }} Phone → {{ $json.phone }} URL → {{ $json.url }}* This node lets us keep only the essentials in a clean format, ready for the next steps. On the right: a clear and usable table, easy to work with. ## Step 3 – Loop Over Items ![baptistefortleadsgooglemapsn8n.png](fileId:1702) Now that our data is clean (see step 2), we’ll go through it item by item to handle each contact individually. The Loop Over Items node does exactly that: it takes each row from the table (each contact pulled from Apify) and runs the next steps on them, one by one. 👉 Just set a Batch Size of 20 (or more, depending on your needs). Nothing tricky here, but this step is essentia

    What's Included

    • Complete n8n workflow template with 0 nodes. Ready to import and customize.

    Requirements

    n8n instance (self-hosted or cloud). credentials.

    How to Use

    1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation

    How to import this template into n8n

    1. Download the workflow JSON file from this page.
    2. In n8n, open Workflows, create a new workflow and choose Import from File.
    3. Open each node that shows a warning and connect your own credentials.
    4. Run the workflow once manually to check the output before you activate it.
    Included in Pro
    • Importable n8n workflow JSON file
    • Download with Builder Pro or Agency Unlimited
    • Built for n8n v1.0++
    • Setup time: 5-15 min

    Included in Builder Pro — $19/mo, 4,177 premium workflows

    Before you activate

    Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.

    Updated Sep 2026
    v1.0
    SSL
    Secure
    GDPR

    100% Secure Checkout

    Refund requests within 7 days of a new subscription

    Dependencies & Requirements

    Airtable
    Data
    HTTP Request
    Integration

    ⚠️ 2 services require credentials. Make sure you have accounts set up before importing.

    Reviews

    0

    No reviews yet

    See all 0 reviews ↓
    —

    0 reviews

    5★
    0
    4★
    0
    3★
    0
    2★
    0
    1★
    0

    No reviews yet.

    Questions & Answers

    0

    Log in to ask a question.

    No questions yet. Be the first to ask!

    People Also Bought