This article covers in detail how to import football data to Google Sheets from Sportradar using Amigo Data–a Google Sheets extension. Sportradar collects and analyses data for bookmarkers, media companies and sports federations.
Using Sportradar API, we can retrieve football data such as competition information, live timelines, daily summaries, head-to-head statistics, player profiles, season transfer information, win probabilities for every match, and even fun facts.
We can also import odds comparison data for a given schedule or for a specific player.
Here are the steps on how to import football data to Google Sheets:
- Install the Amigo Data add-on
- Create a Sportradar API Portal account
- Register an application and get the API key
- Choose a data endpoint
- Import the data to Google Sheets
Let’s get to the business! The game, I mean.
How to import football data to Google Sheets
1. Install the Amigo Data add-on
Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.
Alternatively, you can get it from Google Sheets.
- Open Google Sheets
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo Data and install it.
2. Create a Sportradar API Portal account
Go to developer.sportradar.com and click Register.
Fill in all the required fields and click the Register button. Confirm the account by clicking the link sent to the email address to complete the registration.
After completing the registration, we’ll be able to generate a football API and retrieve football data from Sportradar.
3. Register an application and get the soccer API key
Navigate to My Account and click on Applications.
Click Create a New App to generate a football API key.
Register an application by filling in all the necessary details. Select all the sport or league for which you want to get a key. Make sure that soccer is selected.
Go to My Account to find the keys for the sports/leagues you’ve selected.
4. Choose a data endpoint
Go to the API documentation page. Here’s the link.
To test endpoints using the interactive API documentation, click API Sandbox.
Change the sport to Soccer.
If you selected the soccer API while registering the app, the API key should be automatically added on selecting the sport. If the sport or the league isn’t added, then you can go to My Apps and add more APIs.
Underneath you’ll find the list of all endpoint categories. Select any one. Eg. Season Schedule.
Fill in the parameters. In the season_id field, enter the season ID for which you want to retrieve the schedule. Eg. sr:season:93741 for English Premier League 2022-23 season.
Each competition–eg. LaLiga, Champions League, FIFA World Cup, etc–has its own ID. They can be found by using the Competitions endpoint. And the season ID with the Competition Seasons by using the competition ID obtained with the Competitions endpoint.
Change the format to .json. Then click the Try it! button.
A few moments later, we’ll see the request status along with the request URL and the response body.
Note that depending on the size of the data we’ve requested, the loading time will vary–from a few seconds to many.
The REQUEST URI is the endpoint URL we’ll use to import the data to Google Sheets.
Here’s the endpoint URL to get the season schedule for EPL 2022-23.
https://api.sportradar.us/soccer/trial/v4/en/seasons/sr:season:93741/schedules.json?api_key=API_KEYReplace API_KEY in the URL with your API key.
5. Import the data to Google Sheets
Open Google Sheets and launch Amigo Data from the Extensions tab.
Select Custom API from the list of sources.
Paste the request URI obtained in the previous step in the API URL field.
Click the PREVIEW button. The preview of the data will appear in a short while or a while later depending on the size of the dataset.
Flatten and expand the nested data points and clean the data by deleting information you don’t want. Then click IMPORT.
The requested data will be imported to Google Sheets in a while. Shown below is a screenshot of the imported data.
The imported data can be automatically updated at regular intervals–eg. weekly. To learn how to set a refresh schedule and set up alerts to get the report sent to your inbox, click this link.
Some other endpoints
Head-to-head statistics
Use the Competitor vs Competitor endpoint to get the head-to-head stats for two different clubs. The endpoint URL below will return the head-to-head statistics for Manchester United and Liverpool. sr:competitor:35 is the ID for Man United and 44 for Liverpool.
https://api.sportradar.us/soccer/trial/v4/en/competitors/sr:competitor:35/versus/sr:competitor:44/summaries.json?api_key=API_KEYSeasonal competitor statistics
The Seasonal Competitor Statistics endpoint retrieves the players and club statistics for a particular club in a given season.
Manchester City stats for the season 2022-23 can be retrieved by using the following endpoint URL.
https://api.sportradar.us/soccer/trial/v4/en/seasons/sr:season:93741/competitors/sr:competitor:17/statistics.json?api_key=API_KEYFor another another Premier League club, replace the competitor ID with that of the club. For another club in another league, replace both the competitor ID and the season ID.
Transfers list
List of all the transfers in a season for a league can be got using the Seasons Transfers endpoint.
The endpoint below will fetch the results of all the transfers in the Premier League for the season 2022-23.
https://api.sportradar.us/soccer/trial/v4/en/seasons/sr:season:93741/transfers.json?api_key=API_KEYYou can use Amigo Data to import various other types of data into Google Sheets such as stock data, latest releases and track information from Spotify, Wikipedia page metrics, and crypto prices. Visit our blog to discover more.
Some similar articles you may be interested in.
Import Reddit Data to Google Sheets