The Scenario
You are a sports agency analyst. Transfer window closes in three weeks and your firm is evaluating five central midfielder prospects for a client meeting on Friday. You need a comparison workbook: career clubs, seasons played at each, and career goal totals for each player, with one tab per player and a summary tab at the front.
You have the five player IDs. You need the career histories out of the API and into Excel before the Friday briefing.
The bad version:
- You call the API-Sports player/statistics endpoint for player ID 276
- The response nests career stats inside a statistics array, each element with a nested team object and a nested games object
- You write a Power Query M formula to expand the array; it expands one level but leaves the team name nested one level deeper
- You abandon Power Query, write a Python script for player one, get the output, repeat for players 874, 284, 306, and 521
- You paste the five outputs into five Excel tabs manually
- Player 284 has two stints at the same club in different seasons that you collapsed by mistake
- You are fixing tab three at 8 AM Friday and the client meeting is at 10 AM.
The faster version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the player career endpoint for a list of IDs and writes each player's history to its own tab automatically.
Open the SheetXAI sidebar and type:
For player IDs 276, 874, 284, 306, and 521, fetch their career club history — club name, season, appearances, goals — and write each player to a separate workbook tab named after the player. Add a Summary tab at the front listing each player's total career appearances and total career goals.
SheetXAI calls the API-Sports player statistics endpoint for each ID, writes the career history to individual tabs, and builds the summary tab with career totals. Each club stint is a separate row, so loan spells and second stints appear correctly.
What You Get
Five career history tabs plus one summary:
- Per-player tabs — club name, season, appearances, goals, one row per stint
- Summary tab — player name, total career appearances, total career goals across all clubs
Each stint at a club is a separate row, including loan periods. Your client can see the full career arc without any collapsed data hiding the detail.
What If the Data Is Not Quite Ready
Scouting comparison workbooks usually need analytical depth. SheetXAI can add it in the same prompt.
When career stats include loan stints you want to flag separately
Two of the five players had loan stints. The client wants to distinguish loan appearances from permanent-contract appearances in the briefing.
For each player tab, identify rows where the stint duration was less than 12 months or where the player returned to the parent club immediately after. Flag those rows with a 'Loan' label in column E.
When you want goals-per-game added as a comparison metric
The recruitment director wants an efficiency metric on the Summary tab.
On the Summary tab, add a column called 'Goals per Game' calculated as total goals divided by total appearances, rounded to two decimal places. Sort the summary tab by Goals per Game descending.
When one player ID returns no data for a season
API-Sports occasionally has gaps for lower-league seasons. You want those gaps flagged rather than silently dropped.
For any season where appearance data is missing or zero, write 'Data Unavailable' into the appearances column rather than leaving it blank. Add a note in column F for those rows so the analyst knows to verify.
When you want the full scouting brief built in one pass
You have the five player IDs and want the career tabs, the summary, the goals-per-game metric, a trophy count per player, and a Premier League experience flag, all before the Friday meeting.
For player IDs 276, 874, 284, 306, and 521, fetch career club history and write each to a separate workbook tab. Build a Summary tab with total career appearances, total goals, goals per game (rounded to 2 decimal places), number of trophies won, and a Yes/No column for whether the player has Premier League experience. Sort the summary by goals per game descending.
The pattern: instead of pulling five API responses and building a summary tab as two separate tasks, you describe the full deliverable once and SheetXAI handles the data pipeline and the analytical layer together.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull career history for a list of player IDs into your Excel workbook with one tab per player. The API-Sports integration is included in every SheetXAI plan. For related workflows, see how to build a top scorers and assists comparison table in Excel or the API-Sports in Excel overview.