The Scenario
You are a fantasy football manager with a serious streak. The Gameweek 31 deadline is Tuesday at 6:30 PM and you need to check injury and suspension reports for all 20 Premier League squads before you finalise your transfers. There are 17 hours until the deadline. You want player name, injury type, and expected return date for every sidelined player across every club in one sheet.
The bad version:
- You go to the API-Sports injuires endpoint, call it for team ID 33 (Manchester United), get six injured players
- You repeat for team ID 40 (Liverpool), team ID 42 (Arsenal), and so on
- Twenty teams, twenty API calls, twenty JSON responses with different numbers of injured players
- You concatenate the results, fix the date formatting (the API returns return dates as "Season" for long-term injuries), and paste into a sheet
- You look at the sheet and realise you forgot to include suspensions, which are in a separate endpoint
- It is 11 PM and you still have not compared your squad to the injury list.
The faster version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that calls the injury and suspension endpoints for all 20 Premier League clubs and consolidates the output into a single table.
Open the SheetXAI sidebar and type:
Fetch current injury and suspension data for all teams in the Premier League for the current season and write player name, team, injury type, and expected return into columns A through D. Separate injury rows from suspension rows with a 'Status' column in column E labelled either 'Injured' or 'Suspended'.
SheetXAI calls the API-Sports injuries endpoint across all 20 clubs, handles the "Season" return-date edge case by writing "Long-term" into the return column, and includes a Status column so you can filter injured and suspended players separately. The whole table is in one sheet, sorted by team.
What You Get
A consolidated injury and suspension table:
- Player name and team — all sidelined players across all 20 clubs
- Injury type — muscle, knock, suspension, illness
- Expected return date — readable date or "Long-term" for season-ending injuries
- Status column — Injured or Suspended, so you can filter separately
All 20 teams in one table means you can use a single FILTER formula to check which players in your squad are in this list, rather than cross-referencing 20 separate pulls.
What If the Data Is Not Quite Ready
Injury research for fantasy decisions usually needs more than a raw list. SheetXAI can add the targeting layer inline.
When you want the list cross-referenced against your squad
Your fantasy squad is in the Squad tab, column A. You want to know immediately which of your players appear in the injury list.
After building the injury table, check each player name against the player names in the Squad tab (column A). Write 'In My Squad' into column F for any injured or suspended player who is in your squad. Sort those rows to the top of the table.
When return dates use different formats across the data
Some return dates come through as "Season", some as specific dates, some as "2-3 weeks". Your date-sort formula breaks on the mixed formats.
Standardise the return date column. Map 'Season' to 'Long-term'. Map '2-3 weeks' style entries to a date range calculated from today. Leave specific dates as-is. Write a new column called 'Return Category' with three values: 'This Gameweek', 'Next 2 Gameweeks', or 'Long-term' based on the expected return.
When you only want players from teams in your upcoming fixtures
You play three more gameweeks before the international break. You only care about injuries in the squads of the clubs your fantasy players will face.
Filter the injury table to show only players from teams in the list in the Fixtures tab (column A). Write those rows to a new tab called 'Relevant Injuries'. Sort by Return Category with 'This Gameweek' absences at the top.
When you want the full pre-deadline brief in one pass
You have no data yet. You want the full injury table, the cross-reference against your squad, the return categories, the relevant-fixtures filter, and a cell at the top telling you how many of your squad players are doubtful or out.
Fetch current injury and suspension data for all 20 Premier League clubs for the current season. Write player name, team, injury type, expected return, and status (Injured/Suspended) into the main tab. Standardise return dates into Return Categories (This Gameweek / Next 2 Gameweeks / Long-term). Cross-reference against my squad in the Squad tab and flag squad players in column F. Create a 'My Risks' tab with only my flagged players sorted by Return Category. Write the count of my squad players who are doubtful or out this gameweek into cell A1.
The pattern: instead of pulling the injury data and then running the cross-reference separately, you describe the full pre-deadline brief and SheetXAI builds the complete picture in one go.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull injury and suspension reports for all Premier League squads into your sheet before your next transfer deadline. The API-Sports integration is included in every SheetXAI plan. For related workflows, see how to bulk-import Gameweek player stats from API-Sports or the API-Sports in Google Sheets overview.