Find weak local service businesses on Google Maps and email a ranked shortlist

Scans Google Maps across your cities and trades, keeps only businesses with weak online presence, and emails a ranked, deduplicated shortlist every week

Brushed metal map pin with a glowing teal center on a dark background, two smaller pins fading behind it amid teal mist

About

This template runs a prospecting agent for anyone selling to local service businesses: web designers, marketing agencies, SEO consultants and anyone who improves a business's online presence. It finds the businesses that most need your help and delivers them ready to contact.

What it does

The agent rotates through your list of cities and trades on Google Maps, then filters down to the businesses weak enough to be worth a pitch. It skips chains and franchises, scores each candidate against a grid, and checks every result against past runs so you never see the same business twice. The output is a ranked shortlist emailed to you, plus an append-only record in Google Sheets and contacts synced to HubSpot.

How it works

  1. On a weekly schedule, Tuesday at 8am, the agent picks the next city and trade from your rotation.
  2. It searches Google Maps within that scope and applies the chain and franchise heuristic to drop businesses that are not a fit.
  3. Each remaining business is scored on signs of a weak online presence, then checked against two deduplication keys so repeats from earlier runs are removed.
  4. The qualified businesses are ranked, written to your Google Sheet, pushed to HubSpot, and sent to you as a shortlist email through Gmail.

The qualification logic lives in a reusable skill that carries the rotation rule, the search scope, the scoring grid and the deduplication keys, so every run stays consistent as your target cities and trades grow.

What you will need

  • Gmail

  • Google Maps

  • Google Sheets

  • HubSpot

Agents in this template

Local Service Leads

Rotates through your cities and trades on Google Maps, keeps only the businesses weak enough to need you, dedupes against every past run, and emails a ranked shortlist.

Connectors

Skills · 1

local-lead-qualification

Load at every run, from Phase 3 onward. Carries the rotation rule, the Google Maps search scope, the chain and franchise heuristic, the scoring grid, the two deduplication keys, the append-only export rule, the failure rule that protects coverage, and the four table schemas to recreate if a table is missing.

Scheduled tasks · 1

weekly local lead hunt

At 08:00 AM, only on Tuesday

Frequently asked questions

Which accounts do I need to connect?

Four: Google Maps for the search, Google Sheets for the append-only record, HubSpot for contact sync, and Gmail to send the shortlist email. Setup takes about five minutes.

How often does it run?

Once a week, every Tuesday at 8am. On each run the agent picks the next city and trade from your rotation, so coverage moves through your list over time rather than repeating the same scope.

Will I see the same business twice?

No. Each candidate is checked against two deduplication keys and compared to every past run, so repeats are removed before the shortlist is built. The Google Sheet keeps an append-only record of what has already been found.

How does it decide a business is worth pitching?

It scores each business on signs of a weak online presence against a scoring grid, and applies a chain and franchise heuristic to drop businesses that are not a fit. Only the businesses weak enough to need help make the shortlist, ranked by that score.

What do I get from each run?

A ranked, deduplicated shortlist emailed to you through Gmail. The same qualified businesses are written to your Google Sheet and pushed to HubSpot as contacts, ready to contact.

Can I add more cities and trades over time?

Yes. The rotation rule and search scope live in a reusable skill along with the scoring grid and deduplication keys, so the agent stays consistent as you grow your list of target cities and trades.

More Agencies templates

Row of metallic report panels receding into darkness, front card etched with a glowing gold trend line spiking upward and a
Agencies

Report weekly Meta Ads metrics per client in Google Docs and Slack

Pulls last-7-day Meta Ads metrics per client every Monday, writes a Google Doc for each, and posts a consolidated Slack summary with anomaly flags

1 agent5 min setup
Glowing blue glass document panel with lines of text linked by luminous curved threads
Agencies

Add internal links to blog articles in Google Docs with an approval step

Adds relevant internal links to a blog article in Google Docs and returns an enhanced copy, with an approval step before anything ships

1 agent5 min setup
Brushed metal checklist card with blue edge lighting and a magnifying glass showing a crosshair reticle, on a dark background
Agencies

Audit websites for conversion, SEO and accessibility fixes with prioritized

Audits a website and returns prioritized fixes for conversion, SEO and accessibility issues found across its pages

1 agent2 min setup

Your first agent is
three minutes away

Start for free
Rerun

Run your work on agents. Build them, watch them work, and keep your eyes on everything.

Rerun - Build, monitor and share self-improving autonomous agents | Product Hunt

Resources

TemplatesBlogBrand kitCommunity

Legal

Terms of ServiceRefund PolicyAcceptable UseCreator TermsPrivacy PolicyCookie PolicyDPA

© 2026 Rerun. All rights reserved.