AutomationMart
Home/Browse/Generate and enrich Google Maps B2B leads with SDR-ready data in Google Sheets
n8n

Generate and enrich Google Maps B2B leads with SDR-ready data in Google Sheets

n8nn8n10 modulesv1.0
Google Sheets

Overview This workflow is a powerful B2B Lead Generation engine designed specifically for SDRs (Sales Development Representatives). It automates the entire process of finding, enriching, and qualifying prospects directly from Google Maps based on any industry and location. Instead of manual searching, this pipeline uses a "Search & Enrich" strategy to extract high-value data that isn't available in standard search results, such as direct phone numbers and websites. --- ✨ Key Features User-Frien

At a glance

Generate and enrich Google Maps B2B leads with SDR-ready data in Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets
Modules
10
Price
Free
Version
v1.0
Generate and enrich Google Maps B2B leads with SDR-ready data in Google Sheets workflow diagram

About this workflow

Overview This workflow is a powerful B2B Lead Generation engine designed specifically for SDRs (Sales Development Representatives). It automates the entire process of finding, enriching, and qualifying prospects directly from Google Maps based on any industry and location. Instead of manual searching, this pipeline uses a "Search & Enrich" strategy to extract high-value data that isn't available in standard search results, such as direct phone numbers and websites. --- ✨ Key Features User-Friendly Input: Triggered via an n8n Form, making it easy for non-technical team members to start a search. Deep Enrichment: Uses the Google Places API (Text Search & Details) to get granular information. Smart Pagination: Built-in logic to handle nextpagetoken, ensuring you fetch all available leads (e.g., up to 60+ per run). Data Intelligence: A custom JavaScript node normalizes data, removes special characters, and handles duplicates using a composite key (Name + Address). Quality Gate: Includes a validation step to ensure only leads with a valid phone number reach your database. --- 🛠️ How it Works 1. Form Trigger: Enter the "Business Type" and "City". 2. API Discovery: The workflow queries Google Maps and handles pagination automatically. 3. Item Splitting: Each result is isolated to fetch specific Place Details. 4. Merge & Clean: Data from both API calls are merged and sanitized via code. 5. Validation: The workflow filters out incomplete leads. 6. Sheet Logging: Validated leads are appended to a Google Sheets spreadsheet in real-time. --- 📋 Requirements Google Maps API Key (with Places API enabled). Google Sheets credentials. An active n8n instance. ---

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

Insert new rows with data from Google Sheets to the end of document in Google Docs

When new rows are added to Google Sheets spreadsheet, the corresponding data are sent as new rows to Google Docs document. The paragraph style is copied from the previous index, the lists are supported.

Free

Save new Tradegecko orders to a Google Sheets spreadsheet

Every time a new order is created on Tradegecka, Make will automatically add that order's info to a new row in your Google Sheets spreadsheet. This template uses this [example spreadsheet](https://goo.gl/ynKo2r).

Free

Create a Taxpayer's Signature Code (PKP) from new Google Sheets rows and post it to Slack

Every time you add a new row to your Google Sheets spreadsheet, Make will automatically generate a Taxpayer's Signature Code (PKP) using the EET module and post it to Slack. The template uses this [example spreadsheet](https://goo.gl/qm1mgb).

Free

Automate job posting across multiple boards with Google Sheets and BrowserAct

Post Jobs to Multiple Boards from Google Sheets using BrowerAct This powerful n8n template turns a Google Sheet into a control panel for automating job postings across multiple job boards. This workflow is perfect for HR teams, recruiters, and hiring managers who want to streamline their hiring process by posting jobs to multiple boards from a single source of truth. --- Self-Hosted Only This Workflow uses a community contribution and is designed and tested for self-hosted n8n instances only. -

Free

Generate AI newsletter drafts from Google Sheets to Notion with GPT-5-mini

How it works: This template turns rows in a Google Sheet into polished newsletter drafts in Notion using an AI writing agent. You click Execute workflow in n8n. It fetches all rows marked N8n Status = Pending, generates a draft from Newsletter Title and About the Newsletter, creates a Notion page, writes the full draft, then flips the sheet row to Done before moving to the next one. Before you start (use your own credentials): Create and select your credentials in n8n: Google Sheets (OAuth2 or

Free

Create new notes in Productboard from new rows in a Google Sheets spreadsheet

This templates periodically retrieves new rows from a Google Sheets spreadsheet and uses the information to create new notes in Productboard. The template is using [this sample](https://docs.google.com/spreadsheets/d/1ZbveKRVt-KocnP744uJ_7h6DJkU1K5Kp0b4Onf9XwB4/edit?usp=sharing) Google Sheets spreadsheet as a data source. You should make a copy of it before configuring the template. The template is scheduled to run every 15 minutes. You can change this after you set up the template.

Free

Discover HIDDEN Youtube trends / outlier videos in your niche (Apify + Airtable)

For Who? - Content Creators - Youtube Automation - Marketing Team --- How it works? 1 - Every week, retrieve the keywords you want to track 2 - Thanks to Apify, scrape videos from YouTube Search related to these keywords, filtered by relevance 3 - Wait until the dataset is completed 4 - Get the information contained in the dataset 5 - For each video, clean and summarize the script 6 - Upload everything to your Airtable database 📺 YouTube Video Tutorial: []( --- Setup (5min) Scheduled Trigger:

Free

Schedule appointments via Telegram with GPT-4o & Google Calendar

How It Works Telegram Trigger – Listens for incoming messages from users via your Telegram bot. Watch Full Step-by-step Guide Video here: AI Agent – Processes the message to determine the user's intent (booking or canceling) and extracts necessary details like date, time, and participant names. Google Calendar Node – Depending on the intent: Booking: Creates a new event in Google Calendar with the extracted details. Canceling: Searches for the specified event and deletes it from the calendar. Te

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