Weekly Google Maps Lead Prospector for Local Services SMBs and Agencies

Build me a weekly local-services lead prospector for my agency. It should run on a cron trigger every Monday at 6am in my timezone.

Inputs I will configure: (1) a service niche, for example "dentists" or "roofers", and (2) a list of target cities, for example Austin, Denver, and Nashville.

On each run, for every city in my list the agent should use Bright Data SERP Search against Google Maps for the query "<niche> in <city>" and collect the business listings it returns. For each listing capture name, category, website, phone, address, and review count or rating.

For any listing that has a website, the agent should then use Bright Data Scrape URL with Web Unlocker to fetch the homepage and read the visible copy. Using both the listing details and the homepage content, the agent should qualify each lead against signals like: site looks outdated or thin, no clear online booking or contact flow, fewer than around 50 reviews, weak positioning compared to other businesses in the same city. The agent decides which leads pass, this isn't a fixed rule.

For each qualified lead, the agent should write a short 2 to 3 sentence pitch angle that calls out something specific it saw on the site or in the listing. The pitch should feel like a real SDR wrote it, not a templated blast.

Then for each qualified lead, use HubSpot Create Company to add the business (set name, domain from the website, phone, city, and a property tagging it with the source city and niche). Before creating, the agent should check whether a company with the same website or name already exists in HubSpot and skip if so. Then use HubSpot Create Note attached to the new company, with the pitch angle and the Google Maps listing URL in the note body.

At the end of the run, use Slack Send a Message to post a single weekly digest to the channel #prospecting. The digest should include: total qualified leads added, a breakdown by city, the top 5 highest-fit leads with their business name, city, and pitch angle, and a link to the HubSpot view of recently added companies tagged with this run.

Integrations to use: Bright Data (SERP Search, Scrape URL with Web Unlocker), HubSpot (Create Company, Create Note), Slack (Send a Message).

This should be an agent workflow because qualifying a local business from its homepage and writing a pitch angle grounded in what it sees requires judgment, not a fixed if/then rule set.

Additional information

What does this prompt do?

Every Monday at 6am, searches Google Maps for your service niche across each of your target cities and pulls back fresh business listings with name, category, website, phone, address, and rating.
For any listing that has a website, opens the homepage and reads the copy to spot weak signals like outdated design, no booking flow, thin review counts, or missing service detail.
Writes a short 2 to 3 sentence pitch angle per qualified lead, grounded in something specific from the site or the listing, and creates a HubSpot Company with an attached note carrying the pitch and the source listing link.
Posts a single weekly Slack digest to your prospecting channel with leads added per city, the top 5 best-fit ones with their pitch angles, and a link to the HubSpot view.

What do I need to use this?

A Bright Data account for Google Maps searches and homepage scraping.
A HubSpot account where new companies and notes can be created.
A Slack workspace and a channel for the weekly prospecting digest.
A short list of target cities and the service niche you sell into, for example dentists in Austin, Denver, and Nashville.

How can I customize it?

Change the schedule from Monday at 6am to any cadence that fits your outbound rhythm, like daily or every other week.
Swap the qualification rules to match your offer, for example focus on shops with fewer than 25 reviews, no online booking, or a site that hasn't been updated in years.
Edit the pitch angle style so it sounds like your team, whether that's casual, consultative, or value-focused.
Pick a different Slack channel for the digest, or send the recap to a sales lead by DM instead.

Frequently asked questions

Will this work for any local service niche?

Yes. You give it the niche and the cities you sell into, and it runs the same Google Maps search and homepage qualification for dentists, roofers, med spas, HVAC, law firms, gyms, or anything else with a local footprint.

How many leads will it add to HubSpot each week?

It depends on your niche and city list. A typical run on three cities adds between 30 and 90 new companies per week, filtered down to the ones the agent thinks are actually worth reaching out to.

Can I run this on more than three cities?

Yes. You can list as many cities as you want, though more cities means more searches and more scraping, so usage costs scale with the size of your list.

Does it deduplicate against companies that already exist in HubSpot?

The agent checks for existing companies by website or name before creating a new one, so the same business shouldn't get added twice across weekly runs.

Why is this an agent workflow and not a fixed automation?

Reading a homepage and deciding whether a local business is a good fit, then writing a personalized pitch angle, is judgment work. An agent handles that better than a rigid rules-based flow.