Import IMDb Data To Google Sheets

Import IMDb data to Google Sheets
Reading Time: 4 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 using Amigo Data, a Google Sheets extension that lets us import all kinds of data 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

1. Install the Amigo Data add-on

Get the Amigo Data add-on from Google Workspace Marketplace. Click here to install.

Amigo Data in Google Workspace Marketplace

2. Get the IMDb API key

Go to imdb-api.com and click Register.

IMDb API homepage

Fill in the details and click the REGISTER button.

Creating a new account

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

Click on the username. And then Profile.

IMDb API profile section

You’ll find the API key under Profile.

IMDb API key

Note the key and do not share it with anyone.

3. Choose the data endpoint

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

Navigating to the API documentation from the homepage

Choose any of the categories. We’ll scroll to Others and choose MostPopularTVs.

Selecting the endpoint

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

The endpoint URL of the data to import

4. Import the data to Google Sheets

Open a new spreadsheet and launch Amigo Data.

Launching Amigo Data in Google Sheets

Select Custom API from the list of sources.

Selecting the source in Amigo Data

Paste the endpoint in the  API URL field.

Pasting the endpoint

Click the PREVIEW button.

Preview button

Then flatten and expand the dataset so that they are organised suitably. 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 imported data.

Snippet of the data imported from IMDb to Google Sheets

You can likewise import dozens of other types of data from IMDb. 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.

Note: Replace your_api_key in the URL with your 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.

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.

Some related articles you may be interested in:

https://blog.tryamigo.com/import-data-from-spotify-to-google-sheets/

https://blog.tryamigo.com/import-wikipedia-data-to-google-sheets/

https://blog.tryamigo.com/import-reddit-data-to-google-sheets/