Search API Connector Documentation

Print

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 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: Subscribe to the API-Football API on RapidAPI

  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. We’ll use the Basic plan for this guide.
    api-football-img3
  4. Once you’re subscribed, you’ll be directed back to the main API page.

Part 2: Create Your API Request URL

  1. Click Endpoints in the menu bar to enter RapidAPI’s API documentation and playground
    api-football-img1
  2. The nice thing about RapidAPI is that you can easily create requests by clicking on endpoints. Let’s choose the predictions endpoint from the sidebar.
    api-football-img4
  3. 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, and then click Copy Code.
    api-football-img5

Part 3: Pull API-Football Data into Sheets

Now let’s enter that request into API Connector.

  1. Open up Google Sheets and click Extensions > API Connector > Import / Export > Import cURL.
  2. In the cURL import modal, paste in the snippet from above.
    api-football-img6
  3. Click Import and the entire request should appear in the sidebar.
    api-football-img7
  4. Create a new tab and click Set current to use that tab as your data destination.
  5. Name your request and select Grid report style under Output options. For this request it makes the response easier to read. (More on report styles here: Report Styles).
    api-football-img8
  6. Click Run and a moment later you’ll see a list of football predictions in your Google Sheet:
    api-football-img9
  7. (Optional) If you only need some fields, or want to fix columns in place, click Edit Fields to choose the columns you want to see in your report.

Part 4: Get More Football API Data

  1. 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.
  2. 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 cURL snippet that copy and paste from the code snippets section.
    api-football-img10

Part 5: API Documentation

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

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

Previous Import Financial Modeling Prep Data to Google Sheets
Next Import Freshdesk Data to Google Sheets

Leave a Comment

Table of Contents