The Scenario
You manage a fleet of 30 electric vehicles and your company has approved specific charging stations for reimbursement. The station IDs — TomTom charging availability IDs — are in an Excel workbook that's been building up for months. Your job this week is to take a snapshot of which stations currently have plugs available so the fleet coordinator can plan tomorrow's charging schedule. There is no live dashboard. There is only you and this workbook.
The bad version:
- Find the TomTom EV charging availability documentation, construct an API call for the first station ID, parse the response, read the number of available connectors, total connectors, and connector types, type those values into the workbook
- Do that 30 times
- Get halfway through and realize the API response structure changed slightly between station types so your column alignment is off for 6 rows
Fleet coordinator needs the snapshot before the end of shift. That's in two hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the station IDs, calls TomTom's EV charging availability endpoint for each one, and writes the current availability data back into the workbook.
For each EV charging station ID in column A of my Excel sheet, get the current TomTom availability status and write available plugs, unavailable plugs, and last updated timestamp into columns B, C, and D
What You Get
- Column B: number of available plugs right now
- Column C: number of unavailable plugs
- Column D: last updated timestamp from TomTom
- Any station returning an error flagged visibly so you know which IDs need verification
What If the Data Is Not Quite Ready
Station IDs are mixed in with other text in the column
For each row in column A where the cell contains a TomTom charging station ID (numeric string or starts with "EV-"), fetch the TomTom charging availability and write available connectors, total connectors, and connector types into columns B, C, and D. Skip rows that don't match.
Flag stations where availability has dropped to zero
For each station ID in column A, fetch TomTom EV charging availability and write available plugs into column B and total plugs into column C. Flag any station where available plugs is zero in column D with "all occupied".
You also need connector type details
For each charging station availability ID in column A of this workbook, fetch the TomTom EV charging availability data and write the number of available connectors, total connectors, and connector types into columns B, C, and D
Full availability snapshot with utilization rate
For each station ID in column A, fetch TomTom EV charging availability. Write available connectors into column B, total connectors into column C, and connector types into column D. Calculate utilization rate as (total minus available) divided by total and write as a percentage into column E. Sort by column E descending.
One prompt fetches all 30 stations, calculates utilization, and sorts the output.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your EV station IDs, then ask it to pull current availability from TomTom. For planning long-distance EV routes with charging stops, see the EV route planning spoke.