Import Football Data from RapidAPI to Google Sheets
This guide will show you how to pull major and minor league football stats into Google Sheets, using the API Connector add-on for Sheets. We will use the API-Football API, which is accessible via the RapidAPI marketplace. Please note that this API is freemium, and requires a credit card to access, though you won’t need to pay anything unless you go over the limits. (If you just want to learn more about RapidAPI and don’t want to sign up with a card, feel free to skip part 1 and then follow along with one of their free APIs, e.g. Airports Finder or Football Science).
- Before You Begin
- Part 1: Subscribe to the API-Football API
- Part 2: Create your API Request URL
- Part 3: Pull Football API data into Sheets
- Part 4: Get More Football API Data
BEFORE YOU BEGIN
Click here to install the API Connector add-on from the Google Marketplace.
PART 1: SUBSCRIBE TO THE API-FOOTBALL API ON RAPIDAPI
- If you haven’t already, create an account and log in to your RapidAPI account. While logged in, navigate to the API-Football API located at https://rapidapi.com/api-sports/api/api-football
- Click Subscribe to Test
- You will now see a list of pricing plans. Click Subscribe on the free Basic plan, and enter your credit card details.
- Once you’re subscribed, you’ll be directed back to the main API page.
PART 2: GET YOUR API REQUEST DETAILS FROM RAPID API
- Available endpoints are listed in the lefthand sidebar. For this example, let’s choose GET predictions.
- Connection information for your request will now populate the window. We’ll be copying code snippet values into API Connector, so choose
(Shell) cURLformat from the dropdown, as you’ll be able to copy and paste the URL directly (some code snippet formats display query strings separately from the base URL, which is less convenient for our purposes).
PART 3: PULL FOOTBALL API DATA INTO SHEETS
We can now enter our values into API Connector and import football API data directly into Google Sheets.
- Open up Google Sheets and click Add-ons > API Connector > Open.
- In the Create tab, enter the API URL provided by the cURL snippet above (
- Under Headers enter the headers displayed in the code snippet. They will be key-value pairs like this:
Replace YOUR_API_KEY with the API key shown in the code snippet. These values are also available in the Header Parameters section in the main pane. All together, it should look like this:
x-rapidapi-host api-football-v1.p.rapidapi.com x-rapidapi-key YOUR_API_KEY
- Create a new tab and click ‘Set current’ to use that tab as your data destination.
- Name your request and select ‘Compact’ report style under Output options. This is not strictly necessary, but for this request it makes the response a bit easier to read. (More on report styles here: Report Styles).
- Click Run and a moment later you’ll see a list of football predictions in your Google Sheet:
PART 4: GET MORE FOOTBALL API DATA
- Play around with the endpoint list in the left pane to retrieve other information like leagues, teams, events, players, statistics, etc. Each time you click an endpoint, the new URL will appear in the code snippet box, where you can copy and paste it into API Connector.
- You can also play around with the parameters listed in the main window. As before, when you make an update, it will automatically be reflected in the URL that you copy and paste from the code snippets section.