Latest / The Local Marketing Podcast with Fexingo: Small Business, Google Maps, and Local SEO / How a Local Plumber Uses Google Maps for Emergency Dispatching
Transcript
- Lucas: So here's a stat that stopped me this week: the average local plumber in a mid-sized city spends 22 minutes per emergency call just driving across town because dispatch is based on who answered the phone first, not who's closest. Luna: Twenty-two minutes? That's almost a quarter of an hour for every single call-out. Lucas: Exactly. And that's not traffic time — that's pure inefficiency from bad routing. So I found a plumber in Portland, Jenna Russo, who runs a four-truck operation. She decided to fix this with basically Google Maps and a shared Google Sheet. Luna: No dispatch software? No CRM integration? Just Maps and a spreadsheet? Lucas: Just Maps and a Sheet. And it cut her average arrival time by 30 percent in the first month. Let me walk you through exactly what she did, because it's replicable for any field-service business. Luna: I'm all ears. I know a few electricians who'd kill for that. Lucas: So Jenna had four plumbers, each with a company van. Before the change, the office would take the emergency call, look at a printed map on the wall, guess who was closest, and call that person. But the guesses were bad — they didn't know real-time positions. Luna: Right, because a plumber who left for a supply run 20 minutes ago is now on the other side of town. Lucas: Exactly. So Jenna did two things. First, she had each plumber share their real-time location via Google Maps' location sharing feature — just a permanent link from their personal Google account to a dedicated 'dispatch' Gmail account she set up. Second, she created a Google Sheet with four tabs, one per truck. Luna: Okay, so the dispatcher can see all four dots on a single map view? Lucas: That's the key. In Google Maps, you can open multiple shared locations at once if you save them as labeled pins. So the dispatcher — usually Jenna herself — would open Maps on a tablet, see all four plumbers as moving blue dots, estimate which one was physically nearest to the customer's address, and then call that plumber. Luna: But how does the Sheet come in? Seems like you could just eyeball it from the map. Lucas: You could, but the Sheet solved a different problem: tracking who was 'available' vs 'on a job' vs 'on break'. Each tab had a simple status column. Plumbers updated it themselves — a dropdown with three options. The dispatcher cross-referenced the map with the status. If the closest dot was 'on a job', they moved to the next closest. Luna: That's smart. So the map gives you proximity, the Sheet gives you availability. Together they replace a $200-a-month dispatch platform. Lucas: Exactly. And Jenna told me the whole setup took about an hour. The hardest part was getting the plumbers to remember to update the Sheet when they finished a job. She solved that with a simple rule: the last person to touch the Sheet buys coffee the next morning. Luna: Peer pressure. I love it. So what was the actual impact on the numbers? Lucas: First month: average arrival time dropped from 34 minutes to 24 minutes. That's a 30 percent improvement. Over a year, she estimated they saved about 220 hours of collective driving time. That translated to roughly $80,000 in additional revenue because they could take more calls per day without adding a fifth truck. Luna: Eighty grand from a free tool and a spreadsheet? That's a massive ROI. Lucas: It is. But here's where it gets even more interesting. Jenna also started using Google Maps' 'Your Timeline' feature — the one that shows where you've been — to audit her plumbers' routes after the fact. She'd pull each plumber's timeline once a week and look for patterns. Luna: What did she find? Lucas: She found that one plumber was consistently taking a 10-minute detour through a residential area. Turned out he was stopping by his girlfriend's house. Another was leaving the job site 15 minutes early but logging it as 'travel time'. The timelines didn't lie. Luna: Oof. That's awkward. Did she confront them? Lucas: She did, but not punitively. She framed it as efficiency coaching. The guy with the detour agreed to cut it out. The early-leaver started logging accurate times. She said the timeline audits alone recovered about two hours of lost productivity per week per truck. Luna: So the same tool that improved dispatching also improved accountability. That's a twofer. Lucas: Exactly. And look — this isn't just for plumbers. Any service business with mobile workers can use this. Landscapers, pool cleaners, HVAC techs, even mobile pet groomers. The principle is the same: real-time location plus a simple status tracker beats expensive software for most small operations. Luna: But what about a solo operator? One person, one truck. Is this overkill? Lucas: For a solo operator, the dispatching piece is irrelevant — you're the only one. But the timeline audit is still valuable. If you're a one-person plumbing business, you can check your own timeline at the end of the week and ask: 'Did I take the most efficient route? Did I waste time on unnecessary stops?' Luna: That's a good point. Self-audit is underrated. I know a solo electrician who uses his timeline to log hours for tax purposes. Lucas: Yeah, that's another use case. So the core takeaway: Google Maps isn't just for customer navigation. It's a free operations tool if you use location sharing and timeline data intentionally. You don't need a $10,000 dispatch system. Luna: And the spreadsheet — don't forget the spreadsheet. Low-tech, high-impact. Lucas: Right. Low-tech, high-impact. And you know, speaking of low-tech, high-impact — if these marketing conversations have sparked something you've actually used in your own business, that's exactly why we keep this show going without ads or sponsors. Listener support is what makes that possible. Luna: Yeah, it's a small gesture that adds up. If you've gotten value from an episode — maybe you tried a Google Maps hack like Jenna's — and you want to help us stay independent, you can find us at buy me a coffee dot com slash fexingo. Lucas: It genuinely helps. And it keeps the show exactly what it is: practical, specific, no fluff. So back to Jenna's story — she actually took it a step further. She started using Google Maps' 'Saved places' feature to pin common supply houses and parts stores. Luna: Oh, like a custom layer? So the dispatcher could see not just where the plumbers were, but where they could pick up parts nearby? Lucas: Exactly. She created a map with all the suppliers she uses — Ferguson, Home Depot, a local plumbing supply shop — and color-coded them. So when a plumber was heading to a job and realized they needed a specific valve, the dispatcher could look at the map and say, 'You're two blocks from the Ferguson on Burnside, swing by.' Luna: That's brilliant. It turns the map into a decision-support tool. And it's all free. Lucas: All free. The only investment was Jenna's time to set up the pins and train her team. And the result was that supply-run trips went from averaging 25 minutes to 12 minutes because they were always routed to the closest store, not the one they usually went to. Luna: So total time savings: 10 minutes per supply run, 10 minutes per dispatch improvement, plus the accountability gains. That's a lot of reclaimed hours. Lucas: It is. And Jenna's story is a reminder that before you buy software, ask: 'Can I solve this with what I already have?' Often the answer is yes. Luna: Yeah. And that's a good note to end on. Next week, we're looking at a different angle — how a local art gallery uses Google Maps to drive foot traffic during off-peak hours. Lucas: Looking forward to it. Until then, keep your dots moving.