Import Netflix Data from RapidAPI to Google Sheets

Welcome to the most efficient API Connector guide listed on this site :). It will show you how to get Netflix data in Google Sheets, using the API Connector add-on. But more than that, it will show you how to connect Google Sheets to the thousands of other APIs listed in the RapidAPI marketplace.

For this example, we’ll use an unofficial Netflix API to search the global Netflix catalog. 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 UNOFFICIAL NETFLIX 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 unofficial Netflix online Global Search API located at https://rapidapi.com/unogs/api/unogs
    rapidapi-img1
  2. Click Test Endpoint
    rapidapi-img2
  3. A modal will open prompting you to subscribe. Click Review Pricing Plans
    rapidapi-img3
  4. You will now see a list of pricing plans. Click Subscribe on the free Basic plan, and enter your credit card details in the modal that appears.
    rapidapi-img4
  5. Now that you’re subscribed, click Test Endpoints (or just click the back button in your browser) to return to the main API request screen.
    rapidapi-img5

PART 2: GET YOUR API REQUEST DETAILS FROM RAPID API

  1. Available endpoints are listed in the lefthand sidebar. For this example, let’s choose GET New Release per Country.
    rapidapi-img6
  2. Access details 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).
    rapidapi-img7

PART 3: PULL NETFLIX API DATA INTO SHEETS

We can now enter our values into API Connector and import Netflix data directly into Google Sheets.

  1. Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
  2. In the Create Request interface, enter the Request URL provided above:
    https://unogs-unogs-v1.p.rapidapi.com/aaapi.cgi?q=get%3Anew7%3AUS&p=1&t=ns&st=adv

    rapidapi-img8

  3. Under Headers enter the headers displayed in the code snippet. They will be key-value pairs like this:
    x-rapidapi-hostunogs-unogs-v1.p.rapidapi.com
    x-rapidapi-keyYOUR_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:
    rapidapi-img9

  4. Create a new tab. You can call it whatever you like, but here we’ll call it ‘Netflix_US_New’. While still in that tab, click ‘Set’ to use that tab as your data destination.
  5. Name your request. Again we’ll call it ‘Netflix_US_New’
  6. Click Run and a moment later you’ll see a list of United States Netflix new releases in your Google Sheet:
    rapidapi-img10

 

PART 4: RAPIDAPI + GOOGLE SHEETS NOTES AND EXPANSIONS

  1. If you want to grab the associated images, you can use Google Sheets’ native IMAGE() function.
    rapidapi-img11
    Tip: You can add it into an array formula, so you don’t even need to copy it down, like this: =arrayformula(image(D2:D))
  2. Play around with the endpoint list in the left pane to retrieve other information like expiring releases, country IDs, title details, 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.
  3. 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.
    rapidapi-img12
  4. Now go explore! RapidAPI offers thousands of APIs on their platform, for all different categories and interests.

Leave a Comment