The Scenario
You are a fantasy football analyst. It is Tuesday evening and you want to start building a fixture-difficulty rating model for the rest of the Premier League season. You need the full 2024/25 fixture list — all 380 matches — with kickoff dates, home and away teams, and venue. You also need the current standings so you can weight each fixture by the opponent's position.
The bad version:
- You go to the API-Sports docs and look up the fixtures endpoint
- You write a Python script to call the endpoint with league ID 39 and season 2024
- The response comes back as deeply nested JSON, 380 objects, each with a fixture object nested inside a league object nested inside an array
- You write a second script to flatten it into rows
- You export to CSV, open it in Sheets, fix the encoding issue with the venue names
- You repeat the whole process for the standings endpoint
- You have spent three hours on data prep for a model you have not started yet.
The faster version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the sheet context and calls API-Sports directly, so you never touch a JSON response.
Open the SheetXAI sidebar and type:
Pull all 2024/25 Premier League fixtures with date, home team, away team, and venue into this sheet, one row per match. Then get the current Premier League standings — team, played, won, drawn, lost, goals for, goals against, and points — and paste them starting in column H.
SheetXAI calls the fixtures endpoint and the standings endpoint, flattens both responses, and writes them into the sheet side by side. The fixture list lands in columns A through D. The standings land in columns H through O. If you want them on separate tabs, say so and it splits them out.
What You Get
A single sheet with two structured data sets:
- Fixture list — all 380 rows with match date, home team, away team, and venue
- Standings table — all 20 clubs with played, won, drawn, lost, GF, GA, and points
The fixture dates come through in a consistent format because SheetXAI normalises the Unix timestamps from the API into readable dates on the way in. You do not have to format anything after the pull.
Once both data sets are in the sheet, you can reference the standings table from your difficulty model formula directly. No VLOOKUP across files, no manual copy and paste.
What If the Data Is Not Quite Ready
Most fixture-difficulty models need more than the raw data. SheetXAI can do the enrichment and the analysis in the same prompt.
When the fixture dates come through as UTC timestamps
The API returns kickoff times in UTC. Your model needs them in UK local time, including BST offsets for the summer fixtures.
Convert the dates in column A from UTC to UK local time (apply BST offset for matches between late March and late October). Write the adjusted dates into a new column called 'Local Kickoff'.
When you want difficulty ratings calculated inline
You have the standings table and the fixture list in the same sheet. You want a difficulty score per fixture without building a separate formula sheet.
For each fixture in column A through D, look up the away team's points in the standings table in columns H through O and write a difficulty rating into column E: use points divided by 114 to get a 0–1 scale, then label it Easy (under 0.33), Medium (0.33–0.66), or Hard (above 0.66).
When some future fixtures have placeholder venue data
API-Sports sometimes returns TBC for venue when the host club has not confirmed the ground. You want those flagged so you can fill them in manually.
Find every row where the venue column contains TBC or is blank and highlight those cells in yellow. Write a count of TBC venues into cell F1.
When you want the full model in one pass
You have not pulled any data yet. You want the fixture list, the standings, the difficulty ratings, and a summary tab all from one prompt.
Pull all 2024/25 Premier League fixtures into columns A–D, then get the current standings into columns H–O. Calculate a difficulty rating per fixture in column E using the away team's points divided by 114 and label it Easy, Medium, or Hard. Then create a tab called 'Summary' showing each team's remaining fixture count by difficulty band.
The pattern: instead of pulling the data and then building the model separately, you describe the end state and SheetXAI handles the data pipeline and the analytical layer in one go.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull the current Premier League fixture list and standings into any sheet you have open. The API-Sports integration is included in every SheetXAI plan. For related workflows, see how to pull pre-match bookmaker odds by fixture ID or the API-Sports in Google Sheets overview.