AutomationMart
Home/Browse/Automate lead generation from Google Search & Maps to Google Sheets
n8n

Automate lead generation from Google Search & Maps to Google Sheets

n8nn8n36 modulesv1.0
Google SheetsLinkedIn

This n8n template from Intuz provides a complete solution to automate on-demand lead generation. It acts as a powerful scraping agent that takes a simple chat query, scours both Google Search and Google Maps for relevant businesses, scrapes their websites for contact details, and compiles an enriched lead list directly in Google Sheets. Who's this workflow for? - Sales Development Representatives (SDRs) - Local Marketing Agencies - Business Development Teams - Freelancers & Consultants - Market

At a glance

Automate lead generation from Google Search & Maps to Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, LinkedIn
Modules
36
Price
Free
Version
v1.0
Automate lead generation from Google Search & Maps to Google Sheets workflow diagram

About this workflow

This n8n template from Intuz provides a complete solution to automate on-demand lead generation. It acts as a powerful scraping agent that takes a simple chat query, scours both Google Search and Google Maps for relevant businesses, scrapes their websites for contact details, and compiles an enriched lead list directly in Google Sheets. Who's this workflow for? - Sales Development Representatives (SDRs) - Local Marketing Agencies - Business Development Teams - Freelancers & Consultants - Market Researchers How it works 1. Start with a Chat Query: The user initiates the workflow by typing a search query (e.g., "dentists in New York") into a chat interface. 2. Multi-Source Search: The workflow queries both the Google Custom Search API (for web results across multiple pages) and scrapes Google Maps (for local businesses) to gather a broad list of potential leads. 3. Deep Dive Website Scraping: For each unique business website found, the workflow visits the URL to scrape the raw HTML content of the page. 4. Intelligent Contact Extraction: Using custom code, it then parses the scraped website content to find and extract valuable contact information like email addresses, phone numbers, and social media links. 5. Deduplicate and Log to Sheets: Before saving, the workflow checks your Google Sheet to ensure the lead doesn't already exist. All unique, newly enriched leads are then appended as clean rows to your sheet, along with the original search query for tracking. Key Requirements to Use This Template 1. n8n Instance & Required Nodes: - An active n8n account (Cloud or self-hosted). - This workflow uses the official n8n LangChain integration (@n8n/n8n-nodes-langchain) for the chat trigger. If you are using a self-hosted version of n8n, please ensure this package is installed. 2. Google Custom Search API: - A Google Cloud Project with the "Custom Search API" enabled. - You will need an API Key for this service. - You must also create a Programmable Search Engine and get its Search engine ID (cx). This tells Google what to search (e.g., the whole web). 3. Google Sheets Account: - A Google account and a pre-made Google Sheet with columns for Business Name, Primary Email, Contact Number, URL, Description, Socials, and Search Query. Setup Instructions 1. Configure the Chat Trigger: - In the "When chat message received" node, you can find the Direct URL or Embed code to use the chat interface. Set Up Google Custom Search API (Crucial Step): - Go to the "Custom Google Search API" (HTTP Request) node. - Under "Query Parameters", you must replace the placeholder values for key (with your API Key) and cx (with your Search Engine ID). 3. Configure Google Sheets: - In all Google Sheets nodes (Append row in sheet, Get row(s) in sheet, etc.), connect your Google Sheets credentials. - Select your target spreadsheet (Document ID) and the specific sheet (Sheet Name) where you want to store the leads. 4. Activate the Workflow: - Save the workflow and toggle the "Active" switch to ON. - Open the chat URL and enter a search query to start generating leads. Connect with us - Website: - Email: getstarted@intuz.com - LinkedIn: - - Get Started: For Custom Workflow Automation Click here- Get Started

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

Automate vendor contract renewals & reminders with GPT-4.1 mini, Slack & Gmail

Smart Vendor Contract Renewal & Reminder Workflow With GPT 4.1 mini Watch the demo video below: []( Never miss a vendor renewal again! This smart workflow automatically tracks expiring contracts, reminds your finance team via Slack, and helps initiate renewal with vendors through email — all with built-in approval and logging. Perfect for managing both auto-renew and manual contracts. 📌 Who’s it for This workflow is designed for Finance and Procurement teams responsible for managing vendor/servi

Free

Add new Elastic Email contacts to a Google Spreadsheets

Every time a new contact is added to Elastic Email list, Make will automatically add contact to a new row in a Google Sheets spreadsheet. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/150MxvpoTzxtuFOiGBaZwAVYOkbLZSt8Gt81E4k_hZQA/edit?usp=sharing).

Free

Automate Gmail email categorization with GPT-4o AI and reasoning

An AI inbox labelling manager that has reasoning attached to the ChatGPT inbox manager within n8n. Super simple yet highly effective automation. How it works: • Monitors Gmail inbox → triggers workflow when a new unread email is received. • Fetches email details including subject, body, and sender information. • Sends email content to OpenAI → uses AI to determine the most relevant label based on predefined rules. • AI uses a think tool → justifies why it selected that specific label. • Retriev

Free

Indeed data scraper & summarization with Airtable, Bright Data & Google Gemini

Who this is for? Indeed Data Scraper & Summarization with Airtable, Bright Data and Google Gemini is an automated workflow that extracts company profile information from Indeed using Bright Data Web Unlocker, transforms the data using Google Gemini's LLM, and forward the transformed response with the summary to a specified webhook for downstream use. This workflow is tailored for: - Recruiters and HR teams who want quick summaries of companies listed on Indeed. - Market researchers and analysts

Free

Create an Archive in CloudConvert using both upload & import URL methods

Create an Archive in CloudConvert with files imported from Google Drive and URLs stored in Google Sheets. Upload the output archive to Google Drive.

Free

Create new players in Pointagram from new rows in a Google Sheets spreadsheet

This template periodically checks for new rows in a source Google Sheets spreadsheet and uses the retrieved information to create new players in Pointagram. The template uses this [example spreadsheet.](https://docs.google.com/spreadsheets/d/1zl2IG094Ql9mDZX2kMTtYwcdJUA25Q0MPWYhJeHAFaY/edit?usp=sharing) You should make a copy of it before configuring the template. The template is scheduled to run every 15 minutes. You can change the schedule after you set up the template.

Free

Make every product photo look like a luxury ad fully automated AI + google drive

Watch the video to better understand this workflow : ARRE-automation Good to know: This workflow automatically processes product images from Google Drive, generates AI-powered background prompts using multiple AI models (ChatGPT, Claude, or Groq), creates professional background scenes using Pixelcut.ai, and saves enhanced images back to your Google Drive. Perfect for e-commerce businesses and product photography workflows. Who is this for? ➖E-commerce store owners who need professional product

Free

Create eBay listing drafts with AI agents via MCP server

Complete MCP server exposing 1 Listing API operations to AI agents. ⚡ Quick Setup Need help? Want access to more workflows and even live Q&A sessions with a top verified n8n creator.. All 100% free? Join the community 1. Import this workflow into your n8n instance 2. Credentials Add Listing API credentials 3. Activate the workflow to start your MCP server 4. Copy the webhook URL from the MCP trigger node 5. Connect AI agents using the MCP URL 🔧 How it Works This workflow converts the Listing API

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