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.
Steps to import IMDb data to Google Sheets.
- Install the Amigo Data add-on
- Get the IMDb API key
- Choose data endpoint
- 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.
2. Get the IMDb API key
Go to the IMDb API documentation and click Register.
Fill in the details and click the REGISTER button to register for 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.
You’ll find the IMDb API key under Profile.
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.
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.
Expand that section to uncover the IMDb API endpoint URL. The endpoint URL is given under Test.
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.
Select Custom API from the list of sources.
Enter the IMDb API endpoint URL in the API URL field.
Click the PREVIEW button to retrieve the IMDb data and preview them.
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.
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
https://imdb-api.com/en/API/Reviews/your_api_key/tt2861424
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.
Full cast list of House of Dragon
https://imdb-api.com/en/API/FullCast/your_api_key/tt11198330
Top 250 movies
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
How to pull IMDb ratings into Google Sheets?
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.
How to import movie reviews into Google Sheets?
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.
Is there a free IMDb API?
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