Trade counters near each van base
The best trade counters near each van base, for parts.
What it does
Every quarter: hardware stores, plumbing and electrical suppliers within 5 km of each of your van bases, the best-rated first, so technicians know where to pick up parts.
In one sentence: Monthly on the 1st at 08:00, take your table, find hardware stores, plumbing supply stores and electrical supply stores nearby, remove duplicates, then add row in Google Sheets and email the list to you.
Why it is useful
Technicians lose time hunting for parts. A list of good counters near each base saves it.
Who it is for
Home services & trades. Cleaning, plumbing, electrical, pest control, moving and repair businesses filling their vans, winning contracts and planning around the weather. Every use case for home services & trades
Best use cases
- A plumbing company
- An electrical contractor
- An HVAC service firm
What each run gives you
- A Google Sheet
The time it saves
Monthly on the 1st at 08:00. Doing the same work by hand takes about 30 minutes each time; it runs about 1 time a month, so it saves about 1 hours a month (an estimate). It is easy: 6 blocks.
The flow, block by block
- On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
- Our van basesYour data · My dataBrings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.
- Trade counters nearbyxMap data · Nearby placesPlaces around a point from xMap’s own places database (300M+ places, refreshed every month): pick the types of place (more than 5,000, such as Restaurant, Cafe, Pharmacy, Hospital or Gas station, or a whole group of them) and how far to look.
- Each counter onceLogic · Remove duplicatesKeeps one of each item when the same one arrives more than once, for example from two searches that overlap.
- Update the trade counters sheetApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
- Email me the resultsAction · EmailSends one email per run with all the items, or one email per item.
Every block can be changed after you use the template: the city, the type of place, the score, where the results go.
Use it now
Answer a few questions, enter your work email, and it runs in your own account, kept running until you pause it. Use this template.
How to set it up
- The xMap Flows browser extension: what is around this business: On a company’s website or a place on a map, one click shows its market and the AI employees to hire for it.
- Build your first flow in ten minutes: From a blank page to a flow that emails you a ranked list every morning.
- What xMap remembers about your company: Your city, industry and what you sell, filled in for you and always yours to change.
- Ask the map a question: How many of a kind of place, how many people for each, and where the gaps are, answered on the spot.
- How to score candidate store sites: Compare sites on residents, competitors and neighbours, with an AI score and a reason.
- Location intelligence: Using where things are, and what is around them, to make business decisions.
- POI data (points of interest): Records of places such as shops, clinics and offices, with their category, position and details.
More for Home services & trades
- Office towers for window and facade cleaning: The biggest office buildings scored for window and facade cleaning.
- Where to launch laundry pickup: Young, busy blocks with few laundries, to launch pickup.
- Universities at semester end, for student moves and storage: Campuses ranked by the students around them, for moving and storage.
- New apartment buildings for cleaning contracts: New apartment buildings with the property manager, for cleaning contracts.
- Busy restaurant kitchens for deep cleaning: The busiest kitchens graded for deep cleaning, to the sales team.
- Franchise territories by households: Your city split into franchise territories with similar populations.