- Home
- Skills
- Sales & Lead Gen
- Find Local Businesses With No Website: Prospect CSV
Works with the AI Agents you already use
Find Local Businesses With No Website: Prospect CSV
Searches Google Places by city and category, keeps well-reviewed businesses with no website and a phone number, and writes a prospects CSV.
$9
Find Local Businesses With No Website: Prospect CSV
Example session with this skill installed
Use the local-lead-finder skill. Find hair and beauty salons in the capital that have no website. Split the city into its 6 districts so we get past the result cap. Show me the top 10 by rating and review count.
- Read your context and instructions
- Compiled the find local businesses
- Generated the data export
Summary
Real run, capital city, category "salon", 6 sub-areas. Business names and phone numbers stay in the CSV, not here.
$ SUBAREAS="district 1,district 2,district 3,district 4,district 5,district 6" node scripts/prospects.mjs "<capital>" "salon"
ids found 338 (skipped known 0) · details fetched 338 · rows kept 74
338 unique places across 6 areas and up to 3 pages each. 74 cleared every gate: operational, phone present, no website on the listing, rating and review count above the thresholds. The other 264 failed at least one; the script doesn't break that down, it just keeps what passes.
What the agent does with the CSV
Reads prospects.csv back and ranks rows by rating times reviews, then shows the top 10 with name, phone, area and Maps status. Format of the file:
place_id,name,phone,address,city,category,status,found_on,rating,reviews
Re-running the same city and category appends only new place_ids; the skipped known count tells you how many it already had.
Cost of this run
18 text-search pages (6 areas x 3) plus 338 details calls on the Places API (New). Check your own pricing tier and set a daily cap in Google Cloud before scaling to more categories.
Next steps
- Open the top 10 on Maps for a one-minute sanity check each
- Run the Tier 2 Website Pipeline skill on the best 3 to build pitch demos
- Re-run with another category in the same city
prospects.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
What you get. A prospects.csv of local businesses that list no website, ranked by rating times reviews in the summary Claude gives you. Columns: place_id, name, phone, address, city, category, status, found_on, rating, reviews.
How it runs. Tell Claude a city and a category ("barber in Leeds"). A Node script queries Google Places API (New) and keeps a business only if it is operational, has no websiteUri, has a phone number, and meets your minimum rating (default 4.0) and review count (default 20). Re-runs skip place IDs already in the CSV. Big city? Split it with SUBAREAS. The script prints the real counts. In the demo run for a capital-city salon search: 338 found, 338 fetched, 74 kept. Useful for web designers, SEO and marketing freelancers, or anyone building a local outreach list.
What's in the package.
SKILL.md(58 lines)scripts/prospects.js(94 lines, Node 20+, no dependencies)- README with API key setup; CHANGELOG
Honest limits. You supply a Google Places API key and pay Google's usage; set a budget alert first. One query returns at most about 60 places, so use SUBAREAS for more. "No website" means none on the Google profile; an owner may still have one, so check before pitching. Phone numbers and ratings are as Google reports them.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Sales & Lead Gen.
Requires a Google Cloud project with the Google Places API (New) enabled. Limited to Google's data accuracy regarding website existence and operational status.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 11 days ago