The problem this solves
Selling to local businesses starts with a map, and maps are a poor place to build a list. The businesses that matter to you have a rating above a threshold, a website you can research, and a real phone number; the rest are closed, unrated or unreachable. Scrolling a map app and copying details into a spreadsheet takes an afternoon per city and produces a list full of typos and businesses that shut down last year.
The rating threshold is more than a quality filter. A <business type> holding 4.5 stars over hundreds of reviews is run by someone who cares about the customer experience and has revenue to invest in it; a business with a working website has already decided to spend on its own growth. Those two facts together are the local-business version of a buying signal, and they are exactly the facts a map search will not filter on cleanly.
How the mission runs
- Search local business data for the type and city. The Prospecting Agent runs the local business search for <business type> across <city> and its immediate metro, pulling every listing with its name, address, phone, rating, review count and website where one exists. The search is exhaustive for the area rather than a first page of results, so the list represents the market.
- Apply the rating floor and the website requirement. Listings rated below 4.5 or with too few reviews for the rating to mean anything are set aside, and so are listings with no website. The agent then checks that each remaining website resolves and belongs to the business, which removes dead domains and listings that point at a directory page.
- Resolve domains and dedupe locations. Each website is reduced to its domain and multi-location businesses are grouped so a chain with four branches appears once with four addresses, unless you ask for one row per location. Obvious duplicates from directory noise are merged.
- Deliver the CSV and the Google Sheet. The finished rows are saved as a list, exported as a CSV, and written to a Google Sheet named <city> <business type> with the rating and review-count columns sortable, so a rep can start at the top.
The prompt
This is the exact objective the agent receives. Swap the obvious placeholders for your own domain, segment or channel and run it as-is from the console, Slack, or the API.
What comes back
A CSV and a Google Sheet named <city> <business type> containing every business of that type in the city rated 4.5 or higher with a working website, one row per business with name, address, phone, rating, review count and domain. The agent reports how many listings it found in total, how many cleared the rating floor and how many had a usable website, so you know the size of the market as well as the size of the list.
Make it yours
- Add the owner or general manager with a verified email for each business, which turns the sheet into an outreach list.
- Lower the threshold to 4.0 and add a minimum of 50 reviews when you want established businesses regardless of a single bad month.
- Run it for five cities in one mission and get a tab per city in the same sheet.
Frequently asked questions
How current is the local business data?
Listings, ratings and review counts reflect the current public state of each business at the time the mission runs. Because the result is saved as a list, a refresh later shows which businesses moved above or below the threshold.
Can I get phone numbers for the decision-maker rather than the front desk?
Yes. Ask for the owner or manager and the phone finder looks for a direct number; where only the business line is available, the row says so.
Does this work outside the United States?
Local business data covers cities worldwide. Name the city and country in the prompt and the same filters apply.