The Scenario
You're the fleet operations manager and you have 10 long-distance EV deliveries planned for next week. Each one has an origin, a destination, and a listed battery range — they're all in a Google Sheet. What you don't have yet is the route plan: which charging stations each vehicle should stop at, in what order, and what the estimated total journey time looks like with charging factored in. The drivers want that information before they leave. You need it before your planning call tomorrow morning.
The bad version:
- Open TomTom's EV route planner, enter the first origin and destination, set the battery parameters, step through the recommended charging stops, screenshot the result, and manually transcribe the stop names, addresses, and charging times into the sheet
- Do that for all 10 routes
- Realize trip 7 has a different vehicle battery spec so its parameters were wrong the whole time and you have to redo it
Your planning call is at 9 AM. There are 10 routes and you haven't started.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the origin-destination pairs and battery parameters, calls TomTom's long-distance EV routing endpoint for each trip, and writes the charging stop details and journey times back into the sheet.
For each origin/destination lat/lng pair in columns A through D of this sheet, plan a long-distance EV route using TomTom with a battery range of 250km, and write the number of charging stops and total journey time into columns E and F
What You Get
- Column E: number of recommended charging stops for that trip
- Column F: total journey time including charging time in minutes
- Detailed charging stop data (name, address, charging time) available if you ask for it in a results sub-table
What If the Data Is Not Quite Ready
Battery range varies by vehicle
For each row in this sheet, use the origin lat/lng in columns A and B, the destination lat/lng in columns C and D, and the battery range in km in column E to plan a TomTom long-distance EV route. Write the number of charging stops into column F and total journey time into column G.
You need the full charging stop itinerary, not just counts
Calculate the TomTom long-distance EV route for the trip from the origin in cell A1 to the destination in cell B1 with a full battery at the start. Write each recommended charging stop's name, address, and charging time into rows below.
Origin and destination are addresses, not coordinates
For each row in this sheet, geocode the origin address in column A and the destination address in column B using TomTom, then plan the long-distance EV route with a 300km battery range. Write the number of charging stops into column C and total journey time in hours and minutes into column D.
Full pre-trip brief for all 10 routes
For each trip in this sheet with origin lat/lng in columns A-B and destination lat/lng in columns C-D, plan the TomTom EV route assuming 250km battery range. Write stop count into column E, total journey time into column F, and the name and estimated charging time of each stop into columns G onward. Flag any route where TomTom recommends more than 3 charging stops in column H.
One prompt builds the complete trip brief for all 10 routes.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your EV delivery routes, then ask it to plan each trip using TomTom. For checking real-time plug availability at the stations along the routes, see the EV charging availability spoke.