Search API Connector Documentation

Print

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.

This guide will access API-Football via the RapidAPI marketplace, but if you prefer you can access their API directly from api-football.com.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get your API Key

  1. 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
  2. Click Subscribe to Test
    api-football-img2
  3. 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.
    api-football-img3
  4. 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.
    apifootball-key

Part 2: Pull Data from API-Football to Sheets

The easiest way to get started with the API-Football API is through API Connector’s built-in integration.

  1. Select API-Football from the drop-down list of applications
    apifootball-application
  2. Under Authorization, enter your RapidAPI API key.
    apifootball-authorization
  3. Choose an endpoint, for example /fixtures
  4. Set at least one parameter, like a date or team ID.
  5. Choose a destination sheet, name your request, and hit Run to see the response data in your sheet.
    apifootball-response

Part 3: Create a Custom Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration. To create a custom request, add the complete URL into the request URL field, along with two headers:
1) Key = x-rapidapi-host, Value = api-football-v1.p.rapidapi.com
2) Key = x-rapidapi-key, Value = your_key

The easiest way is to copy cURL format requests from the RapidAPI Code Snippets section.
api-football-img5

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.
api-football-img9

Part 4: API Documentation

Official API documentation: https://www.api-football.com/documentation-v3

RapidAPI documentation: https://rapidapi.com/api-sports/api/api-football/

2 thoughts on “Import API-Football Data to Google Sheets”

Leave a Comment

Jump To...