Import IMDb Data To Google Sheets

Import IMDb data to Google Sheets
Reading Time: 5 minutes

When it comes to getting information about movies and TV series, there are a few better places to go to than Internet Movie Database, more popularly known by its abbreviation, IMDb.

Here in this article, we’re going to learn how to import IMDb data to Google Sheets with IMDb API using Amigo Data, data integration and automation tool.

Here’s a trailer of the data imported into Google Sheets with the IMDb API.

IMDb data imported into Google Sheets

Steps to import IMDb data to Google Sheets.

  1. Install the Amigo Data add-on
  2. Get the IMDb API key
  3. Choose data endpoint
  4. Import the data to Google Sheets

How to import IMDb data to Google Sheets

To pull data from IMDb to Google Sheets using IMDb API, follow the steps below.

1. Install the Amigo Data add-on

Get the Amigo Data add-on from Google Workspace Marketplace to import IMDb into Google Sheets.

Click here to install.

Install Amigo to import IMDb data to Google Sheets

2. Get the IMDb API key

Go to the IMDb API documentation and click Register.

IMDb API documentation page

Fill in the details and click the REGISTER button to register for the IMDb API.

Creating a new account to use the IMDb API

Click the confirmation link sent to your email to complete the registration.

Click on the username. And then Profile to find the IMDb API key.

IMDb API profile section

You’ll find the IMDb API key under Profile.

IMDb API key

Note the key and keep it confidential. This will be used to retrieve IMDb data into Google Sheets.

3. Choose the data endpoint

From the home page, navigate to the IMDb API documentation page by clicking API.

Navigating to the IMDb API documentation from the homepage

On the IMDb API documentation page, we’ll find the list of all data types that we can retrieve with the IMDb API.

Select any of the categories. We’ll, for the purpose of this tutorial, scroll to Others and choose MostPopularTVs.

Selecting the IMDb API endpoint

Expand that section to uncover the IMDb API endpoint URL. The endpoint URL is given under Test.

The endpoint URL of the data to import

Copy the IMDb API endpoint URL. This will be used to import IMDb data to Google Sheets.

4. Import IMDb data to Google Sheets

Open a new spreadsheet and launch Amigo Data to import IMDb data to Google Sheets using IMDb API.

Launch Amigo to import IMDb data to Google Sheets

Select Custom API from the list of sources.

Selecting the source in Amigo Data

Enter the IMDb API endpoint URL in the API URL field.

Pasting the endpoint

Click the PREVIEW button to retrieve the IMDb data and preview them.

Preview button

Then flatten and expand the nested datasets. Once that is done, click the IMPORT button.

A few moments later, you’ll have a spreadsheet populated with the data from IMDb with the title, casts, rating, release year, rating count, and images of the show amongst others.

Shown below is a snippet of the data imported from IMDb into Google Sheets using the IMDb API.

Snippet of the data imported from IMDb to Google Sheets

You can likewise import dozens of other types of data from IMDb with IMDb API. Following are some other examples.

User reviews for Rick and Morty

The last parameter starting with tt is the IMDb movie/show ID. We can replace it with any other valid ID to get the review for that particular show or movie.

The movie or show ID can be found using the Search endpoints.

Note: Replace your_api_key in the URL with your IMDb API key.

For more endpoints, visit the IMDb API documentation page.

After importing the data from IMDb documentation, you can set a refresh schedule so that the data are updated automatically at regular intervals. To learn how to set a refresh schedule, follow this link.


Some frequently asked questions

To pull IMDb ratings into Google Sheets with IMDb API, select the Ratings endpoint under the Title section. Then in the ID parameter, enter the ID of the movie/show for which you want to retrieve the ratings.

To import movie or show reviews from IMDb or Metacritic using IMDb API, use the Reviews or MetacriticReviews, respectively, from the Title section. The movie show ID is required, which you can find using the search endpoints.

Yes, there are free IMDb APIs which let you retrieve data from IMDb and import them into Google Sheets. One of these is the IMDb-API. The free plan allows up to 100 requests per day with no restrictions on the type of data.

There are several other types of data that you can import into Google Sheets using Amigo Data such as stock data, US FDA data, US patent data, and cryptocurrency prices and market cap to name a few. For these and many more, visit our blog.

Some related articles you may be interested in:

Import data from Spotify to Google Sheets

Import Wikipedia data to Google Sheets

Import Reddit data to Google Sheets

Leave a Reply