Print

Import RapidAPI Data to Google Sheets (Any API)

In this guide, we’ll walk through how to import data from any RapidAPI application directly into Google Sheets, using the API Connector add-on for Sheets.

API Connector currently only has a built-in integration for RapidAPI's API Football, so their other APIs require configuring your own custom connection. This article is a general guide showing how to set up a custom connection in API Connector for any API listed on RapidAPI's platform. The related articles listed below provide more detailed instructions for some specific APIs.

Related articles

Contents

Before You Begin

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

Part 1: Subscribe to the RapidAPI API

  1. Create an account at RapidAPI and log in. While logged in, navigate to the API page you're interested in.
  2. Click Subscribe to Test
  3. You will now see a list of pricing plans. These generally include a free plan to try out the API. Click Subscribe on plan for which you'd like to subscribe.
  4. Whichever plan you choose (even the free one), you'll need to enter your credit card details at this point, and can then return to the documentation.

Part 2: Create your API request

  1. Available endpoints are listed in the lefthand sidebar. For example, the Yahoo Finance API shows that we can select GET market/v2/get-quotes
    yahoofinance-endpoints
  2. Scroll down and fill out any required parameters.
    yahoofinance-parameters
  3. If you like, click the Test Endpoint button to see the response in the RapidAPI window, and visually verify that your request has fetched the data you're looking for.
  4. Now click the Code Snippets tab, and choose (Shell) cURL from the dropdown. Click Copy Code to grab the entire curl snippet; we'll use that next.
    yahoofinance-copycode

Part 3: Pull RapidAPI Data into Sheets

We can now enter this cURL snippet into API Connector using API Connector's cURL import tool.

  1. Open up Google Sheets and click Extensions > API Connector > Import/Export > Import cURL
  2. Paste in the cURL snippet we retrieved above. Click Import.
    yahoofinance-importcurl
  3. You'll see the entire request pre-configured in the sidebar.
  4. Create a new tab and click Set current to use that tab as your data destination.
  5. Name your request and click Run. A moment later you’ll see the response from RapidAPI in your sheet.
  6. To get other data data, play around with the endpoint list in the left pane in RapidAPI to retrieve other information. 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.

Part 4: API Documentation

RapidAPI's list of APIs: https://rapidapi.com/hub

Leave a Comment

Jump To