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).
- Part 1: Subscribe to the API-Football API
- Part 2: Create your API Request URL
- Part 3: Pull API data into Sheets
- Part 4: Notes and Expansions
- 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.
- 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) cURL format 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).
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 > Create New API Request.
- In the Create Request interface, enter the Request 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:
x-rapidapi-host api-football-v1.p.rapidapi.com x-rapidapi-key YOUR_API_KEY
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:
- Create a new tab. You can call it whatever you like, but here we’ll call it ‘Predictions’. While still in that tab, click ‘Set’ to use that tab as your data destination.
- Name your request. Again we’ll call it ‘Predictions’
- Under Output options, select ‘Compact’ report style. 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:
- 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.
- If you’re looking for a more dynamic, ticker-like experience for live scores (the /fixtures/live endpoint), check out the API Connector custom function IMPORTAPI() for faster refresh rates.
- Now go build! Send over a link if you make something cool 🙂