Search API Connector Documentation
Import API-Football Data to Google Sheets
This guide will show you how to pull major and minor league football stats into Google Sheets from the API-Football API, using the API Connector add-on for Sheets.
- Before You Begin
- Part 1: Get your API Key
- Part 2: Fetch Data from API-Football
- Part 3: Create a Custom Request
- Part 4: API Documentation
Before You Begin
Click here to install the API Connector add-on from the Google Marketplace.
Part 1: Get your API Key
- 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, and enter your credit card details. If you want to test it out for free, choose the Basic plan.
- Once you’re subscribed, you’ll be directed back to the main API page. You can find your key in the Code Snippets section. Copy that down as we’ll need it shortly.
Part 2: Fetch Data from API-Football
The easiest way to get started with the API-Football API is through API Connector’s built-in integration.
- Select API-Football from the drop-down list of applications
- Under Authorization, enter your RapidAPI API key.
- Choose an endpoint, for example
- Set at least one parameter, like a date or team ID.
- Choose a destination sheet, name your request, and hit Run to see the response data in your sheet.
Part 3: Create a Custom Request
Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration. When you create a custom request, you add your complete URL into the request URL field, along with two headers:
1) Key =
x-rapidapi-host, Value =
2) Key =
x-rapidapi-key, Value =
The easiest way is to copy cURL format requests from the RapidAPI Code Snippets section.
Import those cURL snippets into API Connector using the cURL importer at Extensions > API Connector > Import / Export > Import cURL. Click Run to see the results in your sheet.
Part 4: API Documentation
Official API documentation: https://www.api-football.com/documentation-v3
RapidAPI documentation: https://rapidapi.com/api-sports/api/api-football/