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 for Sheets. 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).
- Before You Begin
- Part 1: Subscribe to the unofficial Netflix API
- Part 2: Create your API Request URL
- Part 3: Pull Netflix API Data into Sheets
- Part 4: Notes and Expansions
BEFORE YOU BEGIN
Click here to install the API Connector add-on from the Google Marketplace.
PART 1: SUBSCRIBE TO THE UNOFFICIAL NETFLIX API ON RAPIDAPI
- 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
- Click Test Endpoint
- A modal will open prompting you to subscribe. Click Review Pricing Plans
- 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.
- 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.
PART 2: GET YOUR API REQUEST DETAILS FROM RAPID API
- Available endpoints are listed in the lefthand sidebar. For this example, let’s choose GET New Release per Country.
- Access details for your request will now populate the window. We’ll be copying code snippet values into API Connector, so choose
(Shell) cURLformat 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).
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.
- Open up Google Sheets and click Add-ons > API Connector > Open.
- In the Create screen, enter the Request URL provided above:
- Under Headers enter the headers displayed in the code snippet. They will be key-value pairs like this:
x-rapidapi-host unogs-unogs-v1.p.rapidapi.com x-rapidapi-key YOUR_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:
- 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.
- Name your request. Again we’ll call it ‘Netflix_US_New’
- Click Run and a moment later you’ll see a list of United States Netflix new releases in your Google Sheet:
PART 4: RAPIDAPI + GOOGLE SHEETS NOTES AND EXPANSIONS
- If you want to grab the associated images, you can use Google Sheets’ native IMAGE() function.
Tip: You can add it into an array formula, so you don’t even need to copy it down, like this:
- 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.
- 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.
- Now go explore! RapidAPI offers thousands of APIs on their platform, for all different categories and interests.