🎣 Extract local business contacts with Google Sheets, SerpAPI, Apify & GPT-4o

⚡ 1,973 views · 🎣 Lead Generation & Enrichment

💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.

View All Scrapers

Description

Extract Local Business Contacts with Google Sheets, SerpAPI & GPT‑4o

Status: Ready for Use ✅
Disclaimer: This workflow relies on community nodes that are not part of n8n’s core package.
Install the following from n8n → Community Nodes before running:

📝 Description

This n8n workflow automates discovery of local‑business contact details by search term and location, then enriches the results with publicly listed email addresses using GPT‑4o AI.

🔑 Key Features

🔗 Google Sheets Integration

🗺️ Google Maps Search via SerpAPI

🧠 Website Scraping & Email Extraction

  1. Scrapes the business homepage content with Apify’s Fast Website Content Crawler.
  2. Sends the scraped HTML to a GPT‑4o AI Agent.
  3. Extracts any publicly listed email address.
  4. Returns a clean, structured JSON object for downstream use.

💾 Data Storage & Tracking

🧱 Extensible Design

The workflow uses modular sub‑workflows and AI agents.
You can easily extend it to add:

📄 Google Sheet Setup

Create a Searches tab with these exact columns (one header row):

Search | Area | Area Name | Complete

Create a results tab with these columns

title | website | address | phone | Search | Search Name | Area | email (Manual Entry)

⚙️ Prerequisites

  1. Google Cloud Project with Google Sheets API and Google Drive API enabled
  2. SerpAPI account (free trial or paid) – obtain an API key
  3. Apify account (free trial or paid) with the Fast Website Content Crawler actor installed
  4. OpenAI account with an API key that can access GPT‑4o models

🚀 Setup Instructions

  1. Copy the Google Sheet

  2. Configure Google Sheets nodes in n8n

    • Open the workflow.
    • Update the nodes Extract Search Terms and Save Emails to Sheet to point at your copied sheet.
    • Authenticate using Google OAuth2 credentials that have access to the sheet.

  3. Add SerpAPI credentials

    • Sign in at <https://serpapi.com>.
    • Copy your API key.
    • In the Search Google Maps node, create a new credential and paste the key.

  4. Set up Apify

    • Sign up at <https://apify.com>.
    • Add the Fast Website Content Crawler actor to your account.
    • In the Scrape Web Page HTTP node, append ?token=YOUR_API_KEY to the actor URL.

  5. Add your OpenAI API key

✅ Running the Workflow

  1. Click Execute Workflow in n8n.
  2. For each unprocessed row in the Searches tab, the automation will:
    1. Retrieve business information from Google Maps via SerpAPI.
    2. Scrape the business website using Apify.
    3. Use GPT‑4o to extract a public email address.
    4. Write all collected data to the Results tab.
    5. Mark the original row as Complete.

🧩 Example Use Cases

🤝 Connect with Me

Description

I’m Robert Breen, founder of Ynteractive — a consulting firm that helps businesses automate operations using n8n, AI agents, and custom workflows. I’ve helped clients build everything from intelligent chatbots to complex sales automations, and I’m always excited to collaborate or support new projects.

If you found this workflow helpful or want to talk through an idea, I’d love to hear from you.

🌐 Website: https://www.ynteractive.com
📺 YouTube: @ynteractivetraining
💼 LinkedIn: https://www.linkedin.com/in/robert-breen
📬 Email: rbreen@ynteractive.com

🔗 Nodes Used

Google Sheets, HTTP Request, Execute Sub-workflow, Filter, AI Agent, OpenAI Chat Model

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup