Search API Connector Documentation

Print

Import Netflix Data from RapidAPI to Google Sheets

In this guide, we will walk through how to pull data from the Unofficial Netflix API (uNoGS) directly into Google Sheets, using the API Connector add-on for Sheets.

This is actually the most efficient API Connector guide listed on this site :). Besides getting Netflix data, you can use this method to connect Google Sheets to the thousands of other APIs listed in the RapidAPI marketplace.

Contents

Before You Begin

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

Part 1: Subscribe to the Unofficial Netflix API

  1. Create an account at RapidAPI and log in. While logged in, navigate to the Unofficial Netflix Online Global Search API located at https://rapidapi.com/unogs/api/unogs
    rapidapi-img1
  2. Click Subscribe to Test
    unogs-subscribe
  3. You will now see a list of pricing plans. Click Subscribe on plan for which you'd like to subscribe.
    unogs-plans
  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, and there are currently two available API versions (v1 and 2). We'll use the new v2 API and search for Titles.
  2. Scroll down and fill out any parameters of interest. For example, entering a new_date of 2023-01-01 will fetch titles added after 2023-01-01.
    unogs-search
  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.
    unogs-copycurl

Part 3: Pull Netflix API 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.
    unogs-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 the unofficial Netflix API appear in your sheet.
    unogs-response

Part 4: Notes

  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 in RapidAPI 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. RapidAPI offers thousands of APIs on their platform, for all different categories and interests, so check out their other APIs too.

Part 5: API Documentation

Unofficial Netflix API documentation: https://rapidapi.com/unogs/api/unogs

Leave a Comment

Jump To...