Content: 00902.zip (23.48 KB)
Uploaded: 22.12.2025

Positive responses: 0
Negative responses: 0

Sold: 0
Refunds: 0

$7.55
This automation finds local businesses via Google Maps, scrapes their websites, extracts email addresses using AI, and stores all data in Google Sheets. Designed for marketers, agencies, and startups looking to scale lead generation without manual research.

## Who it´s for
- Marketers collecting contacts for B2B outreach
- Agencies automating lead generation
- Freelancers sourcing clients by location
- Startups scaling outbound campaigns

## What the automation does
- Triggered manually via n8n interface
- Reads search queries and locations from Google Sheets
- Queries Google Maps through SerpAPI to extract company websites, phones, and addresses
- Scrapes website content using Apify
- Uses OpenAI-powered LangChain agent to identify and extract business emails
- Saves structured data back to Google Sheets and marks row as processed

## What´s included
- Ready-to-use n8n workflow
- Manual trigger logic with batch processing
- Integrations with Google Sheets, SerpAPI, Apify, and OpenAI
- Basic text guide for setup and adaptation

## Requirements for setup
- n8n instance with access to HTTP API and Google Sheets API
- API keys: SerpAPI, Apify, OpenAI
- Edit access to target Google Sheet

## Benefits and outcomes
- Saves hours of manual prospecting per week
- Enables scalable, repeatable lead sourcing
- Increases outreach campaign coverage with verified emails
- Centralizes results in an organized, reusable format
- Easy to adapt for new niches or geographies

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.
extract business emails
scrape company websites
Google Maps scraping
find business contacts
lead generation automation
AI email extraction
Google Sheets automation
n8n workflow
LangChain agent
manual workflow trigger
web data extraction
B2B lead collection
automated Google Maps search
process search results
outreach email list
no-code lead scraping
No feedback yet