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 a Google Sheet 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 spreadsheet.
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 sheet
- 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 Google Sheet. It reads the station IDs, calls TomTom's EV charging availability endpoint for each one, and writes the current availability data back into the sheet.
For each charging station availability ID in column A of this sheet, 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
What You Get
- Column B: number of available connectors right now
- Column C: total installed connectors at that station
- Column D: connector types present (CCS, CHAdeMO, Type 2, etc.)
- Any station returning an error or null 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 (starts with "EV-" or is a numeric string), 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.
You also need the last-updated timestamp
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
Flag stations where availability has dropped to zero
For each station ID in column A, fetch TomTom EV charging availability and write available connectors into column B and total connectors into column C. Flag any station where available connectors is zero in column D with "all occupied".
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 it as a percentage into column E. Sort the sheet by column E descending so the most-utilized stations appear at the top.
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 Google Sheet with your EV station IDs, then ask it to pull current availability from TomTom. If you're also planning long-distance EV routes with charging stops, see the EV route planning spoke.