
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.  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  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.  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 ........ ## Step 2 – Clean and structure the data  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  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
n8n instance (self-hosted or cloud). credentials.
1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation
Included in Builder Pro — $19/mo, 4,177 premium workflows
Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.
100% Secure Checkout
Refund requests within 7 days of a new subscription
⚠️ 2 services require credentials. Make sure you have accounts set up before importing.
0 reviews
No reviews yet.
Log in to ask a question.
No questions yet. Be the first to ask!