The Scenario
You are a same-day courier operations manager. It is 11:30 AM and 20 new pickup requests have come in since the morning dispatch. The addresses are sitting in a Google Sheet, column A, one per row.
Your drivers are already on their routes. You need Route4Me to tell you which existing route each new stop should be inserted into, and where in that route it fits best, so dispatchers can approve the insertions quickly. The recommendations need to go back into the sheet, recommended route_id in column C and insertion position in column D, so dispatchers do not have to open Route4Me and look up each one manually.
The bad version of this:
- You open Route4Me's optimization panel for each driver's route
- You manually test inserting the new address and note the suggested position
- You do that twenty times, once per new pickup
- You type the route IDs and positions into the sheet by hand
- Two dispatchers are waiting for the recommendations and you are on stop twelve.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads each new address and calls Route4Me's optimization API to find the best insertion point, writing the recommendation back to the same row.
Open the SheetXAI sidebar and type:
For each new address in column A of my Google Sheet, call Route4Me to find the best existing route to insert it into, and write the recommended route_id and insertion position back to columns C and D.
SheetXAI reads all 20 addresses, queries Route4Me's optimization endpoint for each one, and writes the recommended route_id and insertion position back row by row. Dispatchers see all 20 recommendations in the sheet without leaving it.
What You Get
A dispatcher-ready insertion plan written into the sheet:
- Column C — recommended Route4Me route_id for each new stop
- Column D — suggested insertion position within that route
- Column E (optional) — estimated extra distance added by the insertion
The recommendations are real optimization outputs, not guesses. Route4Me factors in current route length, driver proximity, and time windows when suggesting where to insert the stop.
Dispatchers can approve the recommendations in the sheet and a second prompt can execute the actual insertions in Route4Me.
What If the Data Is Not Quite Ready
Ad-hoc pickup requests come in messy. SheetXAI handles cleanup and the optimization query in the same prompt.
When the addresses are in combined format
New pickup requests came in as "123 Main St, Chicago, IL 60601" in a single column instead of split fields.
Parse each address in column A into street, city, state, and zip. Then for each parsed address, call Route4Me to find the best existing route for insertion and write the recommended route_id and insertion position to columns C and D.
When some requests have time window constraints
A few new stops have a required pickup window, noted in column B as a time range like "1:00 PM - 2:30 PM." The insertion recommendation should respect the window.
For each new address in column A, call Route4Me to find the best insertion route. Where column B contains a time window, include it as a constraint in the optimization request. Write the recommended route_id and insertion position to columns C and D. Flag any stop whose time window cannot be met by any active route in column E.
When you want to limit insertions to routes that have fewer than twelve stops
You have a policy that no route should exceed twelve stops. The insertion recommendation should only consider routes below that threshold.
For each new address in column A, find the best Route4Me route for insertion that currently has fewer than 12 stops. Write the recommended route_id and current stop count to columns C and D. If no qualifying route exists, write "NO ROUTE AVAILABLE" in column C.
When you need the full chain: parse, filter, find insertion, and execute approved ones in one shot
You want to go from raw pickup requests all the way to executed insertions for any stop where the dispatcher has typed "approve" in column B.
Parse each address in column A into a clean format. For rows where column B is blank, call Route4Me to find the best insertion route and write the recommended route_id and position to columns C and D. For rows where column B already says "approve," call Route4Me to execute the insertion into the recommended route and write "inserted" or an error to column E.
The pattern: instead of finding insertion candidates manually, presenting them to dispatchers, and then executing approved ones across three separate steps, you describe the full decision loop in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with new delivery or pickup addresses, then ask it to find Route4Me insertion points for each one. The Route4Me integration is included in every SheetXAI plan. For full route optimization from scratch, see how to geocode and build an optimized route or the Route4Me in Google Sheets overview.