Three van routes ready before the pierogi cool
Piotr makes pierogi with his mother in a small kitchen in Warsaw. Sixty corner shops sell them.
Listen to the story:
The challenge
Orders land in a shared sheet all night. At five in the morning he sorts them for three drivers by hand, guessing who goes where. Drivers cross the river twice, the vans run late, and some shops sell out before the pierogi arrive.
How the flow works
With xMap Flows, Piotr built Horizon. Horizon is an AI employee: a flow of 5 blocks.
When the night’s orders land in the sheet,
New orders in the sheet (New rows)
Horizon splits the shops into three fair areas,
Three fair areas (Split by territory)
plans the best route for each driver,
Each driver’s route (Route planner)
sends it to each driver on WhatsApp,
Route to each driver (WhatsApp Business)
and keeps the delivery log up to date.
Delivery log (Google Sheets)
What it solves
- Sorting orders at dawn: solved by New rows and Split by territory
- River crossed twice: solved by Route planner
- Shops sell out first: solved by Route planner and WhatsApp Business
The result
At five, Piotr’s phone already shows three routes. No driver crosses the river twice. The vans are back by ten instead of noon, and every shop has fresh pierogi before the breakfast rush.
Piotr used to plan routes at dawn. Now he folds dumplings.
An illustrative scenario: the figures are modelled to show what the flow produces, not a customer's results.
The flow, block by block
- 1
New orders in the sheet
Starts the flow when new rows appear in a Google Sheet or in a table in My data.
- 2
Three fair areas
Shares the items out between your reps by area: compact territories of about the same size, so every rep gets a fair share close together.
- 3
Each driver’s route
Puts the places that reach it in the best order to visit them in a day, from a start you pick: one route, one for each rep (by a field such as owner), or shared out between a number of reps.
- 4
Route to each driver
WhatsApp Business · WhatsApp
Send text, media and template messages from your WhatsApp Business number.
- 5
Templates to build it
Ready-made flows with the same blocks. Open one, change the city and the kind of place, and run it.
- Night patrol routes past banks and jewellersBanks and jewellers shared between patrol cars in the best order each night.
- Fishing boats inside a marine protected areaFishing boats inside a protected area, to the officers every hour.
- Merchandiser visit plan for the weekEach merchandiser’s stores for the week, in the best order from the depot, around road closures.
- Neighbourhood facts and a blurb for every listing in my sheetAdd a listing to a sheet and get its neighbourhood facts and a walkability score.
- Field sales routes to sign up new restaurantsNew independent restaurants shared between your field reps in the best visiting order.
- New outlets, graded and routed to each repNew outlets graded, researched and routed to the nearest rep, with what to pitch at each.
Industries
Learn how it works
- Territory planningDividing a market into areas for reps or teams.
- Route planningPutting a day's visits into a good order, for one rep or several.
- Check in at each stop on your phoneToday’s visits in order: navigate, then say what happened, add a note and a photo.
- Share results out between your reps by areaFair, compact territories, one for each rep.
- Plan the day’s routes for your repsPut the stops in the best order, one route or one for each rep, with directions links.
More stories from Food & delivery
- First through every new bakery's doorSara is a field sales rep at a big flour and baking supplies company in Tunis. She sells to bakeries.
- A second ramen shop where the lunch crowd isKenji owns a small ramen shop in Calgary’s Beltline. The line goes out the door, so he wants a second one.
- Every new bar on a rep’s list by MondayMateo leads sales at a craft brewery in Monterrey. Four reps sell his beer to bars and restaurants across the city.
- Better beans for the cafes that need themValentina roasts coffee in a small workshop in Villa Crespo, Buenos Aires. She sells her beans to cafes.
Build this flow on your own city
Run a live search on the home page without an account, or let Ask xMap build the flow from one sentence.