AutomationMart
Home/Browse/Google Maps to Airtable lead scraper with GPT contact extraction from impressum
n8n

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

n8nn8n27 modulesv1.0
NotionAirtableGoogle SheetsOpenAI

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 Te

At a glance

Google Maps to Airtable lead scraper with GPT contact extraction from impressum is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Notion, Airtable, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Notion, Airtable, Google Sheets, OpenAI
Modules
27
Price
Free
Version
v1.0
Google Maps to Airtable lead scraper with GPT contact extraction from impressum workflow diagram

About this workflow

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 1. Prerequisites - Google Maps API Key with access to: - Places API → Text Search + Place Details - Airtable base with at least two tables: - Cities (with columns: ID, City, Country, Status) - Companies (for scraped results) - OpenAI API key (for decision maker + contact extraction). 2. Authentication - Configure your Airtable API credentials in n8n. - Set up HTTP Query Auth with your Google Maps API key. - Add your OpenAI API key in the OpenAI Chat node. 3. Configuration - In the Airtable “Cities” table, list all cities you want to scrape. - Define your search term in the “Execute Workflow” node (e.g., SEO Agency). - Adjust the batch sizes and wait intervals if you want faster/slower scraping (Google API has strict rate limits). 4. Execution - Start manually or from another workflow. - The workflow will scrape all companies in each city step by step. - It can be safely stopped and resumed — cities already marked as processed will be skipped. 5. Results - Enriched company dataset stored in Airtable, ready for CRM import, lead generation, or further automation. --- Tips & Notes - Always respect GDPR and local laws when handling scraped data. - The workflow is modular → you can swap Airtable with Google Sheets, Notion, or a database of your choice. - Add custom filters to limit results (e.g., only companies with websites). - Use sticky notes inside the workflow to understand each step (mandatory for template publishing). - Keep an eye on Google Places API costs — queries are billed after the free quota. If you are still within the first 2 months of the Google Cloud Developer free trial, you can benefit from free credits.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Publish WordPress posts to social media X, Facebook, LinkedIn, Instagram with AI

Workflow Description for n8n: Social Media Post from Ideas Copy This workflow automates the process of creating and publishing social media posts across multiple platforms (Twitter/X, Facebook, LinkedIn, and Instagram) based on content from a WordPress post. It uses AI models to generate platform-specific captions and images, and integrates with Google Sheets, WordPress, and various social media APIs. Is a powerful tool for automating social media post creation and publish

Free

Create a task in HubSpot CRM after a new click is received in Rebrandly

When a new click is received in Rebrandly and meets specified criteria, a new engagement in HubSpot CRM is created and associated with a specified record. This scenario was created to cooperate with [this](https://www.integromat.com/en/integration/2965-make-a-prefilled-airtable-link-for-a-new-record-in-hubspot-crm-and-shorten-it-by-rebrandly) and [this](https://www.integromat.com/en/integration/2966-update-a-record-in-hubspot-crm-by-records-from-airtable-form) scenario.

Free

Generate Docupilot documents from Airtable records

This template helps you create a Personalized document for each record matching a specific keyword in Airtable. This template requires to make a copy of this [airtable model](https://airtable.com/templates/entrepreneurship/expQrNqXl4bUBrb8B/fundraising-crm).

Free

Scan your books with Android barcodes and save them in a Google Sheet spreadsheet

Every time a book's barcode is scanned via the Make Android app, Make will automatically search for the book's metadata and save it to the Google Sheets spreadsheet of your choice. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1UoE4k1jJpqRFNjUVMbwkJBUpsoUkzaaQ4RNMKlOsoac/edit?usp=sharing).

Free

Automated Revolut payment drafts from Google Sheets

Retrieve payment transfer information from Google Sheets and create Revolut draft payments. Your Google Sheets sheet has to include the following columns: Name of the recipient (First name and Last name if it's an individual), Amount, Payment date, Payment reference and payment details. To see which details are required to create a Revolut draft payment depending on the country, click [here](https://developer.revolut.com/docs/build-banking-apps/#tutorials-tutorials-work-with-draft-payments-int

Free

Iterative content refinement with GPT-4 multi-agent feedback system

Who's it for This workflow is designed for users who want to implement iterative AI-powered content improvement processes. It's ideal for content creators, marketers, product managers, and anyone who needs to refine ideas through multiple rounds of critique and enhancement until they meet quality standards. How it works The workflow creates a sophisticated feedback loop using three specialized AI agents that work together to continuously improve content. Starting with an initial i

Free

Avoid Asking Redundant Questions with Dynamically Generated Forms using OpenAI

Avoid Asking Redundant Questions with Dynamically Generated Forms using OpenAI Target Audience This workflow has been built for those who require a form to capture as much data as possible as well as the answers to predefined questions, whilst optimising the user experience by avoiding asking redundant questions. Use Case When creating a form to capture information, it can be useful to give the user an opportunity to input a long answer to a large, open-ended question. We then want to drill dow

Free

Track marketing channel performance with HighLevel, Google Sheets, and Slack

Description: Discover which marketing channels actually convert with this n8n automation template. The workflow fetches all opportunities from HighLevel (GHL), filters for “Closed Won” deals, computes lead-to-sale conversion metrics per source, and sends a summary report to Slack while logging raw data into Google Sheets for ongoing analysis. Perfect for marketing teams, growth analysts, and sales managers who want to reduce wasted ad spend and double down on sources that deliver real ROI.

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free