Communitygithub.com

aiagentwithdhruv/skills

從 Google Maps 抓取 B2B 潛在客戶,並進行深度網站豐富化與聯絡資訊提取。當使用者要求尋找本地商家、抓取 Google Maps、產生承包商清單或建立本地服務業資料庫時使用。

skills 是什麼?

此技能主要用於從 Google Maps 自動化生成高品質的 B2B 潛在客戶名單。它會先透過 Apify 的 Google Places 爬蟲抓取商家列表,接著對每個商家的網站進行深度爬取(包含多個聯絡頁面),並利用 DuckDuckGo 搜尋補充擁有者資訊。最後,使用 Claude 3.5 Haiku 模型從抓取的內容中提取結構化的聯絡資料,包含電子郵件、社群媒體、團隊成員等 36 個欄位,並將結果同步至 Google Sheets 以去重累積。此工具支援平行處理、自訂搜尋限制,且每個潛在客戶的成本極低(約 $0.012-0.022 美元),非常適合需要大量本地商家資料的行銷、業務開發或研究用途。

相容平台✓Claude Code~Codex CLI~Cursor
npx skills add https://github.com/aiagentwithdhruv/skills/tree/HEAD/gmaps-leads

在你喜歡的 AI 中提問

開啟一個已預先載入此 Agent Skill 的新對話。

說明文件

Google Maps 潛在客戶生成

目標

從 Google Maps 產生高品質 B2B 潛在客戶,並透過爬取網站及使用 Claude 提取結構化聯絡資料,進行深度聯絡資訊豐富化。

輸入參數

參數必填說明
--search是搜尋查詢(例如 "台北市水電師傅")
--limit否最大結果數(預設:10)
--sheet-url否要附加的現有試算表網址
--workers否平行工作數(預設:3)

腳本

  • ./scripts/gmaps_lead_pipeline.py - 主要協調腳本
  • ./scripts/gmaps_parallel_pipeline.py - 平行版本
  • ./scripts/scrape_google_maps.py - Google Maps 爬蟲
  • ./scripts/extract_website_contacts.py - 網站聯絡資訊提取
  • ./scripts/update_sheet.py - Google Sheets 同步

流程

基本使用

# 建立包含 10 個潛在客戶的新試算表
python3 ./scripts/gmaps_lead_pipeline.py --search "台北市水電師傅" --limit 10

# 附加到現有試算表(建議用於建立資料庫)
python3 ./scripts/gmaps_lead_pipeline.py --search "台中牙醫" --limit 25 \
  --sheet-url "https://docs.google.com/spreadsheets/d/..."

# 更高數量
python3 ./scripts/gmaps_lead_pipeline.py --search "新北市屋頂承包商" \
  --limit 50 --workers 5

管線步驟

  1. Google Maps 爬取 - Apify compass/crawler-google-places 回傳商家列表
  2. 網站爬取 - 抓取主要頁面及最多 5 個聯絡頁面
  3. 網頁搜尋豐富化 - DuckDuckGo 搜尋擁有者聯絡資訊
  4. Claude 提取 - Claude 3.5 Haiku 提取結構化聯絡資料
  5. Google Sheets 同步 - 附加新潛在客戶,並以 lead_id 進行去重

輸出結構(36 個欄位)

商家基本資訊: business_name, category, address, city, state, zip_code, phone, website, rating, review_count

提取的聯絡資料: emails, additional_phones, business_hours

社群媒體: facebook, twitter, linkedin, instagram, youtube, tiktok

擁有者資訊: owner_name, owner_title, owner_email, owner_phone, owner_linkedin

團隊聯絡人: JSON 陣列 of 團隊成員

中繼資料: lead_id, scraped_at, search_query, pages_scraped, enrichment_status

成本

元件每個潛在客戶
Apify Google Maps~$0.01-0.02
Claude Haiku~$0.002
DuckDuckGo/HTTP免費
總計~$0.012-0.022

100 個潛在客戶總計:約 $1.50-2.50

疑難排解

  • 「查無商家」:請在查詢中包含地點
  • 403 禁止存取:約 10-15% 的網站會封鎖爬蟲(程式會優雅處理)
  • 驗證問題:刪除 token.json 並重新驗證
  • 重複資料:使用 lead_id(對 名稱|地址 進行 MD5 編碼)進行去重

環境變數

APIFY_API_TOKEN=your_token
ANTHROPIC_API_KEY=your_key

結構定義

輸入參數

名稱類型必填說明
search字串是搜尋查詢(例如 '台北市水電師傅')
limit整數否最大結果數(預設:10)
sheet_url字串否要附加的現有試算表網址
workers整數否平行工作數(預設:3)

輸出值

名稱類型說明
sheet_url字串包含 36 欄位潛在客戶資料的 Google 試算表網址
lead_count整數已抓取的潛在客戶數量

憑證

名稱來源
APIFY_API_TOKEN.env
ANTHROPIC_API_KEY.env

可組合的技能

與此技能良好銜接的技能:classify-leads, casualize-names, instantly-campaigns, onboarding-kickoff

成本

每個潛在客戶 $0.012-0.022

Individual skills in this repo

This repo contains 10 individual skills — each has its own dedicated page.

aiagentwithdhruv/skills

Add new Modal webhooks for event-driven execution. Use when user asks to create a webhook, add an endpoint, or set up event triggers.

aiagentwithdhruv/skills

Answer Euron Gen AI Bootcamp doubts instantly. Covers Euri API setup across all frameworks (Python, LangChain, OpenAI SDK, TypeScript, n8n, curl), MCP server setup, common errors, model recommendations, and token limits. Use when someone in the bootcamp asks a question.

aiagentwithdhruv/skills

Manage emails across multiple Gmail accounts with unified tooling. Use when user asks to check email, read inbox, label emails, archive messages, or manage Gmail across accounts.

aiagentwithdhruv/skills

Auto-label Gmail emails into Action Required, Waiting On, and Reference categories. Use when user asks to label emails, triage inbox, categorize emails, or organize Gmail.

aiagentwithdhruv/skills

Run Claude orchestrator locally with Cloudflare tunneling. Use when user asks to run locally, start local server, or test webhooks locally.

aiagentwithdhruv/skills

MCP server for AI-powered macOS control — apps, display, audio, files, screenshots, clipboard

aiagentwithdhruv/skills

Deploy execution scripts to Modal cloud. Use when user asks to deploy to Modal, push code to cloud, or update Modal functions.

aiagentwithdhruv/skills

Scrape and verify business leads using Apify, classify with LLM, enrich emails, and save to Google Sheets. Use when user asks to find leads, scrape businesses, generate prospect lists, or build lead databases for any industry or location.

aiagentwithdhruv/skills

Query Skool community content using RAG pipeline with vector search. Use when user asks to search Skool knowledge, find community answers, or query Skool content.

aiagentwithdhruv/skills

Scrape Upwork jobs and generate personalized proposals with cover letters. Use when user asks to find Upwork jobs, create Upwork proposals, or apply to Upwork listings.

相關技能