The Scenario
You are a fleet manager at a logistics company. The company just transitioned 45 vehicles of its delivery fleet to electric. The vehicles are listed in a Google Sheet with make, model, and year in columns A, B, and C. Finance needs a total-cost-of-ownership model by end of next week and it cannot be built without battery capacity, charging power, and electric range for each vehicle.
Your procurement lead spent two afternoons last week trying to pull specs from manufacturer websites. Three vehicles are discontinued models with no current web page. Two returned conflicting specs between the US and EU versions.
The bad version of this week:
- Procurement lead opens the Tesla website, finds the Model 3 specs, copies battery capacity
- Moves to the Rivian page, finds a different spec sheet with a different format
- Can't find the discontinued Nissan LEAF 2019 page, falls back to a forum post
- By Wednesday he has 20 of 45 vehicles done and the conflicting specs are unresolved
- Finance builds the model on 20 vehicles and calls it a representative sample.
The clean version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet. It reads your EV inventory and calls the API Ninjas EV specs endpoint for each vehicle, writing battery capacity, charging power, and range back to the columns you name.
Open the SheetXAI sidebar and type:
For each EV make and model in columns A and B, look up the battery capacity, max charging power, and electric range from API Ninjas and fill columns D, E, and F.
SheetXAI calls the EV specs endpoint for all 45 rows and writes three fields per vehicle. Discontinued models get flagged instead of silently returning wrong data.
What You Get
A complete EV fleet spec sheet ready for the TCO model:
- Column D: Battery capacity (kWh) — usable capacity from API Ninjas
- Column E: Max charging power (kW) — maximum DC fast-charge rate
- Column F: Electric range (miles) — EPA-rated range
Finance now has defensible specs for all 45 vehicles, not a 20-vehicle sample or data sourced from forum posts.
Need battery size alongside range and charge time? Ask in the same prompt.
What If the Data Is Not Quite Ready
EV fleet sheets accumulate inconsistencies. SheetXAI handles them inline.
When make/model names don't match the API Ninjas format
Your sheet uses display names like "Tesla Model 3 LR" but the API uses standardized model names.
Normalize the make and model names in columns A and B to API Ninjas standard format before fetching EV specs. Write the normalized model name into column C, then fill battery capacity, max charging power, and range into columns D, E, and F.
When some rows are not EVs
Your sheet has a mix of EVs and a few remaining ICE vehicles that haven't been replaced yet.
For rows where column C (fuel type) is "Electric" or "BEV," fetch EV specs from API Ninjas and fill columns D–F. For all other rows, write "NOT EV" in column D and leave E and F blank.
When you want to add a range-anxiety flag for long-haul routes
Your longest delivery route is 280 miles. Any vehicle with a range under 300 miles needs a flag.
After writing electric range into column F, add a "Range Caution" flag in column G for any vehicle where column F is below 300 miles.
When the full TCO prep run is one prompt
Forty-five EVs, mixed naming conventions, some non-EVs in the sheet, range flags, and a computed cost-per-mile estimate Finance needs alongside the specs.
Normalize make and model names in columns A and B to API Ninjas format. For rows where column C is "Electric" or "BEV," fetch battery capacity, max charging power, and range from API Ninjas and fill columns D, E, and F. For non-EV rows, write "NOT EV" in column D. Flag any EV with range below 300 miles as "Range Caution" in column G. Then calculate an estimated cost-per-mile assuming 0.13 per kWh and write into column H.
The pattern: spec enrichment, filtering, flagging, and a derived financial metric all in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open any fleet inventory sheet, then ask SheetXAI to add EV specs using API Ninjas. The API Ninjas integration is included in every SheetXAI plan. See also how to decode VINs and add vehicle specs or the API Ninjas in Google Sheets overview.